Tables, several lookup values in different columns in one table

MJvanEwijk
Participant III

Hello, is it possible to select an item/value from a column in another table with several “list colums” like
3X_0_2_020f9c05f8a19c87fbee182fe11354e8462818ec.png
So when i select type “Booster Panel” in a form it will give me the items (Type numbers) from “booster panel” column to choose from, when I select “duct detector” I get the items under "duct detector "to choose from. “booster panel” and “duct detector” are in the same table as separate columns.

Can someone help, or is this not possible and do I need to setup a table for every Type
Thanks Muk

0 4 255
4 REPLIES 4

You can make it work that way, but it is not really the best way. You could do something like this:

IFS(
  [col] = "Booster" ,
  Table[Booster] ,
  [col] = "Duct" ,
  Table[Duct]
)

That expression would be in valid_if, by the way. If you’re not familiar:


A better way would be to use this structure.
3X_4_c_4c23a963dc183ed4568e4d8a5d66c722bc4e56bc.png

Then you could use this kind of expression for valid_if

SELECT(
  Table[Value] ,
  [category] = [_THISROW].[col]
)

MJvanEwijk
Participant III

Thank you, I will try.
Is deeklink expression possible?

MJvanEwijk
Participant III

[quote=“Marc_Dillon, post:2, topic:55011”]

IFS(
  [col] = "Booster" ,
  Table[Booster] ,
  [col] = "Duct" ,
  Table[Duct]
)

So when I have 20 category this will be not possible using this expression??

Yes, it would be possible, just cumbersome, because you’d have to manually add 20 different condition-value pairs to the IFS(). Which is why my 2nd suggestion is probably better.

Deeplinks are for navigating to different views in the app. I’m not sure how that could relate to your original question here.

Top Labels in this Space