How to add the ID field to a Notification Email.

Discussion Ask a question
,
1

Hello Guys,

Can any one help with any idea of how i can add the Unique Database ID field of a User input to the Notification Email sent to users after they have filled and submitted a form on a page.

I have set up the Email Notification System that alerts both me and the users of my site of new submissions made into my database after filling the form. But i now want the unique ID of the newly created item in the database to by part of the message that will be sent in the notification email with code.

Anyone with any idea should please help.

Thanks
William

2

Hi William,

Add a hidden field on your form that gets the ID from the database. Then in the sendFormHandler() function (or whatever you call it), you can copy the contents of this hidden field to somewhere in the email.

Yisrael

3

Hello Yisrael,

Thanks for your quick response.
I am guessing that by hidden field you mean an input that is hidden on load and connected to the ID field of the database. I have tried doing that but the ID field is grayed while trying to connect that input to it in the Database through the dataset. What could be cause?

Please help.

4

Kindly note that i am not good at writing code at all. I need the codes to use if possible.

5

I would suggest using a text field and not an input field. Your problem might be because the field needs to get (read) the content of the field, but an input field is meant to write. Your dataset is also probably set to write-only which means it can’t read field.

6

Hello,
Got it sorted. Thanks a mill.

1 Like
7

Hi @inboxbillygold please could you share your fix?