How to add columns based on user input from another column?

Michael Richard

I have a field called Number of Children in my form. The user then inputs the number of children they have. What I am looking to do is have other fields added based on what the user input for the Number of Children field. For example, if the user inputs 4 in the Number of Children field, I want a Name, Age, and Gender field to show up for the user to input the information in for all 4 children.

Any help would be awesome! Thank you!

Genevieve P.

Hi Michael,

You can use Conditional Logic in forms to have these other columns appear (see here for more information!).

You can either create these new columns when you create the form, or you may want to set up your sheet with all possible columns first, then use the rule in the form to indicate when they should appear.

Here's an example of how I would set this up, assuming that you want the Name/Age & Gender to all be filled out in the same column per-child:

Does that make sense? If this wouldn't work, it would be helpful to see a screen capture of your sheet with a bit more detail about what you're looking to do (but please block out any sensitive data).

Thanks!

Genevieve

Genevieve P.

No problem at all! Happy to help 🙂

Genevieve P.

Hi Michael,

You can use Conditional Logic in forms to have these other columns appear (see here for more information!).

You can either create these new columns when you create the form, or you may want to set up your sheet with all possible columns first, then use the rule in the form to indicate when they should appear.

Here's an example of how I would set this up, assuming that you want the Name/Age & Gender to all be filled out in the same column per-child:

Does that make sense? If this wouldn't work, it would be helpful to see a screen capture of your sheet with a bit more detail about what you're looking to do (but please block out any sensitive data).

Thanks!

Genevieve

Michael Richard

Sorry for the late response and thank you very much for the feedback. I really appreciate it!

Genevieve P.

No problem at all! Happy to help 🙂

FWPBIDev

This is fantastic. Thanks, Genevieve!