I am reaching out to explain some issues I’m experiencing with Google Sheets and AppSheet. I have a Sheet1, where column B is named "OptionChoice." This column is set up as a multi-select dropdown, populated with values from Sheet2, specifically from column A (range A2:A), which contains "OptionName.
The issue arises when I create an AppSheet app based on my Google Sheet. If I set Sheet1's "OptionChoice" column as a Ref type pointing to Sheet2's "Options," I lose the ability to make multiple selections in AppSheet. The multi-select functionality only works if I set the field type to EnumList. However, I need the field to remain as a Ref type and still allow multiple selections because I want to establish a relationship between the two tables
How can I achieve this functionality while meeting both requirements?
LinkedIn
Twitter
