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

AppSheet AppSheet Q&A
1

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!!!

2

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.

3

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

4

Thank you very much, I found the solution

5

Excellent!