Tables, several lookup values in different columns in one table

Hello, is it possible to select an item/value from a column in another table with several “list colums” like
image
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

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.
image

Then you could use this kind of expression for valid_if

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

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

[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.

2 Likes