Dropdown - Crossed Values

AppSheet AppSheet Q&A
1 
Hello,

I was wondering if it is possible to display in a dropdown different values ​​than what will be saved in the sheet?

For example. A table with orders that has a column with a status identifier and another table that has the status description.

10 = discarded

20 = in process

etc.

How could I have a dropdown in the orders view that shows the literals (discarded, in process, etc.) but saves in the orders table their identifier(10, 20, etc.)?

Thank you.
2

In Table STATUS DESCRIPTION - make key column as Identifier and label as Literals

In Table ORDERS - make column [Status] as Ref to Table STATUS DESCRIPTION

Now in App when you open Form, the Label (Description) will show, but actually only the Key (Identifier) is getting saved

3

Thanks a lot @jyothis_m , this is exactly what I was looking for.

1 Like