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! Go to 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.
User | Count |
---|---|
16 | |
12 | |
9 | |
4 | |
3 |