Email notification with URL that

Scriptcase 9 General
, , , ,
#1

Hello, is there a way to send I send an email (notification) after I save my form and put an URL in the email message which points directly to record in de form I just saved?

Thanks

#2

Pretty straightforward.
SELECT LAST_INSERT_ID() FROM tablename…
to get your record ID and put it in the Body of the message
send the email

#3

SELECT LAST_INSERT_ID() FROM tablename does not work for me. I had to use SELECT id_field FROM tabelname ORDER BY id_field DESC LIMIT 1

2 Likes
#4

SELECT MAX(id_field) FROM TABLE

2 Likes