Referenced columned are downloaded to the database with the ID information instead the value of the column

[Gianni_Bortolot]

Hi, I am starting with app sheet and have 2 referenced columns which when I save the new register in the database, they store the key value instead of the value that corresponds to the column.
For example:
Customer ID = 1234
Cutomer Name = Question

In the master database when I enter a new data, I have:
ID: xxxx
Date: 17/12/20
Customer name = 1234 (instead of Question)

Thanks

[Suvrutt_Gurjar]

It is not exactly clear what your data structure is. It sounds that you will need to probably dereference your label column to get it populated in the child table. The reference column always stores the value of the parent table’s key in the child table. However while displaying to the user in the child table, it shows the label of the parent table.

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

help.appsheet.com

Row Labels

How to determine which columns are prominently displayed in a view.

https://www.appsheet.com/templates/This-app-shows-the-difference-between-keys-and-row-labels?appGuid...