Displaying more fields based on a dropdown selection

I am building an app where users can track their yarn projects. In every form, users will need to enter the project name, hook size, etc. Users should be able to enter the yarn information as well but this can often be multiple yarn colors, weights, etc. I have a drop down created with numbers 1-10. My idea was to have some sort of additional form appear to have repeated fields for the yarn info, so like Yarn Brand 1, Yarn Color 1, Yarn Weight 1 then a Yarn Brand 2, etc etc. Is the only way to do this to create these fields in the database? Or is there a way to repeat a form as many times as a user indicates in the numeric dropdown?

Bumping this for help. :slight_smile:

Hi,

From your notes, I understand that you want to allow users to select the number of forms they need. Once they make their selection, all the forms should appear. Essentially, the forms will be the same, but if a user selects five from the dropdown menu, then five forms should be displayed. Am I correct?

Yes, that is correct. The issue I’m running in to is that when the form is duplicated, I don’t have the option to “update” the current project; I only have the option to “create” new project. When users fill out the forms XX number of times, on a table, I want them to be able to view all the yarn types they entered.

It seems I can only “Update” project from the first form even though they are duplicated. Here’s first form:

Hi,

I think it’s good to have a form & on the same screen a list of all submissions visible. When the user submits a new project detail, that new record gets added to the list.

You can apply a condition as a visibility rule: "If the user has 5 project details in count, then this form will no longer be visible and instead will show a message saying “You have reached the limit”.

This will fix your issue and you can achieve what you want.

Inshort →

Project A → Can have multiple Yarn records

I hope this helps

Thanks
Shantanu

So below are screenshots of what I currently have set up. The first image is the first part of the form where a user will indicate how many types of yarn they need to add. Depending on what they enter here, it takes them to one of six screens (because the max is currently set to six). Each screen essentially has the fields repeated numerically yarn 1, yarn 2, yarn color 1, yarn color 2, etc. up to yarn 6. Preferably, I would rather it the current fill-in-the-blank field to have options 1-6 and then below the form would appear fields for them to enter in the selected number of yarn details. Where I’m running in to the issue is 1) I can’t create a “new” form and link it to UPDATE the current form details (I only have the option to CREATE NEW project) and I can’t figure out how to make the drop-down and subsequent fields show conditionally based on the drop-down selection. I hope that makes sense. I’m so close to having this done but it’s still looking a little messy and I’m just stumped on what I’m doing wrong.


If I try to add the same form a second time on the same screen, I only see CREATE new project - not an option to update the project details above on the same page.

Hi there,

I hope this will help - Unique Download Link | WeTransfer

Thanks
Shantanu