Struggling with database

Need help Database
1

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.

formExample
formExample1305×887 36.8 KB

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.

2

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

3

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.

-Jon