Tables, several lookup values in different columns in one table

[MJvanEwijk]

Hello, is it possible to select an item/value from a column in another table with several “list colums” like

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

[Marc_Dillon]

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:

help.appsheet.com

Dropdown from Valid_If

How to create a dropdown that depends on a particular list of values.

---

A better way would be to use this structure.

Then you could use this kind of expression for valid_if

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

[MJvanEwijk]

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

[MJvanEwijk]

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

[Marc_Dillon]

MJvanEwijk:

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.

MJvanEwijk:

Is deeklink expression possible?

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