This is a strategy question. I have a Dynamic Form that adds a new record to a custom table called Tickets on the form completion event. I would like to be able to include the new TicketID field value in the confirmation email that the form sends out. Can you advise me on how to accomplish this?
The TicketId field is a key field with auto increment, so the form will not have the value of that field until the record is actually created.
Can I have a confirmation email - completion event wait until it gets a return value from a save record - sql completion event before firing off the confirmation email?
Or how else can it be done? Thanks in advance.