Populating enumlist values from a ref table

[Tom_automated]

I am trying to figure out how to populate an enumlist column with values from another table. My main table:

The values of ‘band’

I would like the user to be able to maintain the enumlist i.e. update/add/delete the values in the list. So I made another table:

How do I connect the 2 tables so that the enumlist values of ‘band’ in the main table are picked up from the second table? I tried creating a virtual column of ‘band’ in the main table and using that as a Ref to the second table, but it seems that you cannot do that:

[Suvrutt_Gurjar · Accepted solution]

Please try with valid_if constraint expression as

Second Table[Band] in the enumlist column of the main table.

May I request you, if possible at your convenience to update the post thread if an approach suggested has been useful or whenever you yourself got a solution to the requirement posted. I believe that will help any community member in future who is looking for a solution to similar requirement.

[Tom_automated]

The valid_if constraint works for this step, but now I have another problem trying to connect the ‘band’ and ‘phone’ columns Get 2 column values of specific row from another table using valid_if.

[Steve]

help.appsheet.com

The "Lookup/Dropdown" Data Pattern

A classic data pattern used to help users pick values from a fixed list of options

help.appsheet.com

Dropdown from Valid_If

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

[Tom_automated]

Sample for scenario 1 of https://help.appsheet.com/en/articles/1211505-the-lookup-dropdown-data-pattern no longer exists.

[Steve]

I’ve removed the reference to the non-existent app. Thanks for pointing it out!