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.
Solved! Go to Solution.
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
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
Thanks a lot @jyothis_m , this is exactly what I was looking for.
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |