I have a table with a list of Regions- used as a global reference. I have another table for Use Case Availability - a list of use cases and an Available column which lists the Regions in which this use case is available.
SO I want two selectors so that I can quickly lookup a Use Case and a Region and get true / false for ‘is this use case available in this region’?
selector: useCaseSelect ; selectable items: Use case availability.Use case
selector: regionSelect ; selectable items: Regions.Region
This seems to work for the first item in the resultant list, but not others. Eg the list from Use Case Availability table ~= CAN, IRL, GER and this only works where regionSelect = CAN
I’ve added .split(",")because the list from the table automatically comes out with references, eg @CAN, @IRL.
hi @Jenni_Ajderian , welcome!
can you share a dummy doc with in one column the desired outcome. The community members then can have a look.
Cheers, Christiaan
It seems like this formula works for the first item in a list, but not others. But I thought the In operator was supposed to test the whole list? Sure there’s a simple fix!
Instead of a selector I should have been using a lookup. Lookups read the whole row of a table, and you select by the ‘display column’ of that table. So I needed to change the Use Case column of Use Case Availability to be the display column. That way I can select by use case, and read across to the Available column.
Splitting the use cases into a separate list does work for the selector, but not for this lookup solution as the availability information is in a separate table.
Thanks for your help, always good to get a second pair of eyes! Leaving this solution up in case it helps anyone else.