How to get form questions to be rows for each question

I have an app that will have multiple forms based on a column value. When you select a record it uses the value  of one of the columns to present (Form A, Form B, or Form C). The user then will answer questions on each form. I am needing to have each questions that is answered as a row rather than a column. My thought is that I will have a "Question table" which will store an ID and the text values of what the questions are. Then there will be a table/sheet that will have each questions response as a row.

 

Any help with this would be much appreciated.

Solved Solved
0 9 1,409
1 ACCEPTED SOLUTION

Then you could do it with the combination of  Bot and actions (Execute an action on a set of rows) to create those rows.

View solution in original post

9 REPLIES 9
Top Labels in this Space