In Enum List, it's possible to store user-selected options in different cells?

AppSheet AppSheet Q&A
,
1

I have an application that has a selection list with around 169 options. The user must select everything that interests him, but the usual Enum List saves the selected options in a single cell.

I need to use the selected options in BI, so I would need to store them in different cells. Any ideas on how to execute this? Suggestions for alternatives?

2

Would having 169 columns of Yes/No type with the names corresponding to the options work?

or you could create different rows for the selected options using LOOP actions. (see this demo app https://www.appsheet.com/templates/Examples-of-loops-using-actions?appGuidString=7b9ae746-1f51-4ecb-8c39-b322e1c12da6 to create rows from an enumlist)

1 Like
3

Yeah! Is it way! But, is it possible to do it with a Google Sheet integration as a BD?

4

I do not see why it wouldn’t work

https://spreadsheetpoint.com/google-sheets-limitations/#:~:text=Google%20Sheets%20both.-,Maximum%20of%2018%2C278%20Columns,Google%20Sheets%20in%20a%20worksheet.