From the previous page, data from the form is stored in shared parameters. This allows you to call an action of type 'serverAction' and submit the data directly. For this action the JSON server action 'executeSQL' is called and passed a SQL query with the appropriate parameter markers in place to substitute most of the form data. Some of the data will have to be checked and assigned to parameters before it can be added.
The following data needs to be checked before the action is finished:
These items will be completed over the next few steps.
For this step most of the code has been written below. This block of the script was copied from the 'dropTask' action below and the parts that have been modified have been highlighted.