App with lots of user entered data

You would need 7 tables to store responses to each survey.

And maybe 7 helper tables where you will construct custom forms.

That way, people can go back and continue filling their form. Add a way for them to view their submitted responses and edit them as well. Prevent them from submitting a new entry should be straightforward with a relation to each response table, and hiding the button to open the form when the relation is not empty.

1 Like