Hello all -
I have a virtual column called get_coll_id with a select statement in the Formula field that either returns all IDs in the column, 1 ID, or, when I select multiple, the field hides.
select(my_collection[my_collection_id], IN([plants_to_trade], list([plant_name])),true)
Purpose of my app
Users can create a new trade request where they can select 1 or more plants they are willing to trade (my_collection lists all the plants the user has) in exchange for 1 or more plants that the user is searching for (ISO table lists all the plants theyโre looking for and their characteristics, like size of plant).
Issue
Iโm using EnumList + List base for both dropdowns so users can select multiple plant names. I need to access the IDs for each plant selected in those dropdowns. Iโm trying to fill get_coll_id with the ID(s) of whatโs selected in plants_to_trade. It works great when I only select 1 item but the field completely hides if I select any more than that.
Hereโs a little video of the app that ends with the field hiding - itโs really weird. Google Drive: Sign-in
my_collection table:
willing_to_trade
Solved! Go to Solution.
Try it with these changes to the IN() portion of your expression.
select(my_collection[my_collection_id],
IN( [plant_name] , [_THISROW].[plants-to-trade] )
),true)
Make sure to review the help article on IN()
And note the usage of [_THISROW] to refer to the column in the Table that youโre running the expression from. I believe the SELECT() article should have more information about that.
Also, when a field suddenly gets hidden, that often means that either its App Formula, or Valid_If expression, is returning nothing.
Try it with these changes to the IN() portion of your expression.
select(my_collection[my_collection_id],
IN( [plant_name] , [_THISROW].[plants-to-trade] )
),true)
Make sure to review the help article on IN()
And note the usage of [_THISROW] to refer to the column in the Table that youโre running the expression from. I believe the SELECT() article should have more information about that.
Also, when a field suddenly gets hidden, that often means that either its App Formula, or Valid_If expression, is returning nothing.
Thank you so so so much!!!
User | Count |
---|---|
35 | |
31 | |
30 | |
19 | |
17 |