Edit many columns at the same time? more than one answer per variable?

[RosarioBallve]

Hello!!

I have a variable (with 100 repetitions P1 … to P100). Each one can have 1, 2 or 3 answers.

The user selects the number of responses that he wants to have available for each variable.

Any ideas to do it?

I have to generate 3 columns in the excel per variable and then edit to show or not, according to what the user chose?

Can you edit more than one column at a time?
thanks!!!

[MultiTech]

You could use Show If formulas to conditionally show the groups of columns, but perhaps this is a case where switching to a relational database might prove more appropriate.

I made a video a few weeks ago talking about when to split or not, might help.

help.appsheet.com

Show_If Column Constraint

Conditionally show or hide a column depending on earlier values in a form.

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so that your data makes sense.

[Aleksi]

Are you able to take a printscreen for example from the form view, thanks.

[RosarioBallve]

Thank you very much, I found the solution

[Aleksi]

Excellent!