I have two forms in my application. One has data (Form A) while another is a stateless form (Form B). Form A (the form with data) has various fields and one of those fields is a unique ID field (Ticket ID - put in by me).
- The stateless form records data entry in a single single-line field
- I want to use this data just entered to search the Ticket ID field of Form A
- If there is a match in the Ticket ID field of Form A then I want to modify certain fields of the record which contains this Ticket ID, like add 1 to value of one field, put the current date+time in one field, then show a success HTML page to the user
- If there is no match then I want to show a failure HTML page to user
I already have Form A and Form B created. I have also already created success and failure HTML pages. I just need help to understand what scripting I need to do to accomplish the above task sequence (specifically how to do the search and make edits in fields of specific record which matches the search).