Reference Data of Customer Name and ID is not showing up correctly on 'sale' sheet

[annieyong]

Hi, need help!

The reference data of Customer Name and ID from Customer table is not showing up correctly on the Sale table. ID is appearing on the Customer Name column (on the spreadsheet) when customer name is entered via appsheet. Thanks  

[dbaum]

If the [Customer Name] column is configured as a Ref type column in order to link the Sales table's customers to the Customers table, then it's indeed the Customer ID value that should be stored in the spreadsheet in that column. Then, within AppSheet the Customer Name would be displayed in views based on the Sales table if a [Customer Name] column is designated as the Customers table's label column. From the context of the Sales table--for instance, in an expression--you can dereference the Customer ID value in the [Customer Name] column.

[annieyong · Accepted solution]

Hi Thanks a lot to Appsheet Community,  your kind advice have solved my problem.