Create reference number using FormItSaveForm ID?

70 Posts

Cotton Reply #1, 11 years, 1 month ago

Is there a way to pull the ID of a form that is saved into the Formit DB and call that into the send email template?
I need to create a unique reference for each email sent and include it in the customer email that is sent when submitted. This seemed like the most logical solution.

Thanks in advance

This question has been answered by comp_nerd26. See the first response.

295 Posts

comp_nerd26 Reply #2, 11 years, 1 month ago

rather than using the ID, why dont you use a hidden field with a reference number? i.e yyyy-mm-dd H:i:s or unix timestamp. you could use modx or javascript to create the unique number. that way when the form gets inserted all you do is reference the input name in the email template

discuss.answer

295 Posts

comp_nerd26 Reply #3, 11 years, 1 month ago

for example:

<input type="hidden" name="refnum" value="[[snippet]]">

snippet:

<?php
return date('yyyy-mm-dd H:i:s',strtotime('NOW'));

a a column refnum is created with the unique number in.

call the hidden input in your email template

[[+refnum]]

70 Posts

Cotton Reply #4, 11 years, 1 month ago

Perfect, thank you comp_nerd.

I went with the following snippet to make it look a little less like date and time

<?php
return date('dm-yH-is',strtotime('NOW'));

295 Posts

comp_nerd26 Reply #5, 11 years, 1 month ago

great, happy to assist

Answered Create reference number using FormItSaveForm ID?