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

[herbetdavid]

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?

[TeeSee1]

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-... to create rows from an enumlist)

[herbetdavid]

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

[TeeSee1]

I do not see why it wouldn't work

https://spreadsheetpoint.com/google-sheets-limitations/#:~:text=Google%20Sheets%20both.-,Maximum%20o....