LinkedIn
Twitter
1 ACCEPTED SOLUTION
It’s possible yes, but if you’re wanting the ability to use the Ref column and allow people to select multiple options, it’s not a natively supported behavior by AppSheet; but that’s not to say you can’t make it work. 
Best thing about AppSheet is the fact that you can do any one thing 3,000 different ways. 
If you want to select multiple references, AND have those records show up in the inline view like they would if you had used a Ref column, you need to get a little fancy with formulas and virtual columns.
There’s two elements to this setup:
- the selection dropdown, and
- the virtual column that holds list of related records .
The Dropdown
To setup the dropdown, use the column type “Enumlist” and set it’s basetype to Ref.
After you save, another field will be visible that allows you to select which table the ref should point to:
The Virtual Column
Once this is setup, it’s time to build the virtual column; you’ll need to construct a formula to pull in the related records that correspond to what was just selected in the dropdown:
FILTER(“Table”, in([Key], [_thisrow].[Dropdown_Column]))
You can read more about FILTER() here:
