Hi there,
suppose i have a dropdown column and the user may have to select more than one references. Is it possible?
Thanks,
Rui
Solved! Go to 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:
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:
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:
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |