Generate reference number prior to email confirmation
752887Jun 7 2010 — edited Jun 8 2010Hi All,
I have an issu.e where I have a form that a user submits for a change request
This change request is then emailed to a mailbox for someone to action.
The issue I have is that I have is that then change request number that is created automatically upon insert into the table is not being sent, it is showing as blank.
I have a feeling that it is because the email is being sent prior to the record being inserted into the Database and the change request number then being generated.
The process of sending the email is attached to the click of the submit button.
Please could someone point me in the right direction of what I could do or take a closer look at.
Many Thanks
Kev