Hi - I need to create a form that has submit after the first part (to save data in case users choose not to complete the form) and then a final submit after the second part.
I'm using the slide show option to stay on the same page, but when the user hits the first submit the data base moves to the following line (e.g. for the same user, info in columns A and B will be on line 2 and for questions in columns C and D will be on line 1). I need to keep all of the data on the same line in the database.
I tried making the database write&read to go back a line after the user hits the first submit, but that causes a whole lot of other problems and I've been advised it should be write only database.
Any suggestions how to code this?