If you select Form View for your layout, you will see only one record at a time. New Record/Request is what a submit button can use to create that new blank record. When you first access this layout, a script can search for a blank record and create one if such is not found.
An Alternative approach is to set up a second set of fields with global storage in a different table. The user enters data into the global fields to fill out the form. When they click Submit, the script creates a new record and uses set field to copy the contents of the global fields to corresponding non-global fields in the new record and then a second set of set field steps with "" as the calculated result clears the global fields to prep the layout for the next report submission.
Thanks so much. The thing that I'd like to avoid is users being able to see the other form submissions. If I use your first method, which is easier for sure, the users would still be able to scroll through the previous responses. In addition, on creation each user's account name fills in a field automatically. So if a new record was created immediately on submission, the new record would automatically have their account name.
Would that be the case with the second with the second method you noted?
I'm basically looking for something that will behave like a web form. Blank upon loading, submits, and then no record of the submissions on the front end, only in the backend table.
Thanks so much.
The global field based submission form avoids those issues, but there are also ways to avoid them with the first method.
The thing that I'd like to avoid is users being able to see the other form submissions.
You can use a script to isolate the new blank record as the only record in the found set. If you then hide/lock the status toolbar and use a custom menu that drops out certain menu options that can bring up other records, their only options for accessing data become those you control with scripted buttons on the form.
if a new record was created immediately on submission, the new record would automatically have their account name.
You might change this field to auto-enter this info when the field is modified instead of when it is created. You could also use a script to update the auto-entered info when the record is committed.