Gsheets with dropdown and multiple selections to Appsheet

[Samjco]

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?

[Steve]

The only way to all multiple selections in a dropdown is to use an EnumList, but if you do that you won't get the auto-generated Related reverse-reference columns, so you'd have to implement them yourself.

Can you provide more details? What are you trying to accomplish here? Having a better idea may guide our suggestions.

[Trevwiller]

This can require a valid if statement in some cases but should work right away. Also will require a virtual column that acts as your ref. The original column is for your in form view for selecting your refs, but will be in the form only. The new virtual column will be your visualizer for the detail view. The statement can be

SELECT(Table 2[Key Column], IN([key], [_THISROW].[EnumList-Ref-Column]))