I am trying to set up the logic and database for the following flow, but really having a hard time figuring out the best way to do this.
The app contains a list of 4 forms a user can choose to create and edit. They begin the process by selecting the form on the right side radio buttons and clicking create form.
On the back end are the following data types/tables:
- User (contains info on user)
- Forms (contains a list of the 4 possible forms(1-4))
- Form 1 (contains all inputs for form 1, including a user field which is connected to the User and a Form field which is connected to the Forms data type.
- Same for the rest of the forms
Right now when a new Form 1 is created, a new row is added to the Form 1 table. However, I cannot figure out how to get it to display in the repeating group in order to allow the user to edit it.
This makes me wonder if I need to add a list of forms to each User table. Or maybe even create 4 additional columns per user. One column for a list of Form 1’s, Form 2’s, and so on.
If you were to set something like this up, how would you do it?
Thank you so so much.