I am doing a form where users can input data to be added to the database. I would like to reset the form upon successful submission of data for the user to continue adding different sets of data.
I have a reference number field where the values would be inputted automatically, so I do not want to clear that field. Also, the reference number increases by 1 automatically.
I would like to clear all text fields except for the reference number's text field, and at the same time, increment the reference number by 1. Currently, I can only do this by returning to my main page, then clicking on Add Data again.
Is there any code for this without the need to return to the main page?