EnumList not showing the id I selected but other data instead

[Benny_mk]

So the problem I'm facing is that I want to show the ID (in my case is the "Nota" column) but it shows the date instead in the enumList. What seems to be the problem.

For the suggested values, I fill in the same thing as the valid_if formula but it shows error :

p.s. I am also trying to show a list of data from the table referred that is selected in the enumList, how would I do that?

[Joseph_Seddik]

Ref columns will only store the values of the key column in the referenced table. If you want to get a the values of another column in the referenced table, you should then have another column that calculates the required values through a dereference expression.

Please read these guides carefully:

References Between Tables | AppSheet Help Center 

Dereference Expressions | AppSheet Help Center  

[Benny_mk]

That's the thing, the enumlist doesnt show the key value, but other value instead

[Joseph_Seddik · Accepted solution]

The Ref column WILL store the key values, have a look at the spreadsheet. 

However, in your Forms and Views, the displayed value will be the Date because you have set this column as Label. 

If you want your "No. Nota" column to be displayed, then mark it as Label instead. 

[Benny_mk]

That works. Thanks a lot!! 

[graham_howe]

What are the key and display fields in your referenced table and what are their types?

[graham_howe]

That is by design, it is one of the powerful aspects of relating tables through references. Although it is the key value being stored, it is the display value which will be seen. Read the links that @Joseph_Seddik provided and if you still have questions then come back with some further screen shots of what you are seeing.

[Joseph_Seddik]

@graham_howe again and again and again 😁