DISPLAY A LIST OF OPTIONS BUT STORE A DIFFERENT VALUE

[jeffme96]

Hello.
I'm new to appsheet, please could someone help me with a solution regarding the problem I'm having:

I have a list of options that are displayed by enum but I don't really need to store that string of text that is displayed, I need to store a number and then add it in another row.

In html it would be done like this

<option value="6">Recto</option>

<option value="4">Inclinado o ligeramente torcido</option>

How could I do it or how would be the correct way to implement it?

Thanks for your help

[Suvrutt_Gurjar]

You could do it in a couple of ways

1. You could add a small table with those options listed as key and label and then reference that table in the other table where you are using the dropdown

ID (Key Column)	Description (Label column)
6	(6) Recto
4	(4) Inclinado.....
3	(3) Torcido.....
1	(1) Muy.......

AppSheet displays lables in referenced columns and stores keys in the backend table

References between tables - AppSheet Help

Related Sample app: Row labels and keys

2) You could add another column that extracts the desired part of the dropdown text. You could use various AppSheet text expressions to do that.