Struggling with database

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:

  1. User (contains info on user)
  2. Forms (contains a list of the 4 possible forms(1-4))
  3. 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.
  4. 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.

Use input fields and style them to make them look like regular fields.

Hi daniel4,

What you’re trying to do shouldn’t be a big deal once you get the hang of the tool, but to help get us there, could you provide a few more details?

I understand that you’ve got 4 types of forms. Can a user fill out the same form more than once? There a specific set of form responses that should be show in a row, or only the ones that the user has filled out?

Finally, if you could share a link to what you’ve done in the application so far, it’d be easier to help troubleshoot.