How to select drop down values from another table?

AppSheet AppSheet Q&A
1

I have my main data entry form “Records” with a column for “Site Number”. I have a second table “Sites” with columns “Site Number” and “Site Name”.

Currently I have a dropdown with the list of site numbers that will enter the number into the Site Number column of the “Records” form.

What I want in the app, is for the user to see a dropdown list from the “Site Names” column of the “Sites” table, but I want the “Site Number” entered into the “Records” table. In other words, I want the user to see the site names, but have the app enter the site numbers into the Records table.

I have been playing with SELECT, LOOKUP, and VALID_IF but can’t seem to get it right.

1 Like
2

Hi @entomophile

In your “Records” table, you have a column “Site Number”.

Please set this column with type Ref, and select the source table “Sites”.

Aurelien_3-1681398211625.png
Aurelien_3-1681398211625.png521×231 8.16 KB

Aurelien_1-1681398157222.png
Aurelien_1-1681398157222.png767×442 22.8 KB

LAST STEP: the one you are probably missing :slightly_smiling_face:

In your table “Site”, set the Label property on the “Site name”.

Aurelien_0-1681398123119.png
Aurelien_0-1681398123119.png605×237 10.6 KB

For reference:

References between tables - AppSheet Help

Columns: The Essentials - AppSheet Help

Add row labels - AppSheet Help

2 Likes
3

You are correct! I was missing that last step. I was making it way more complicated than I needed to. Thank you!