Returning random number instead of actual value!

[AUXWORK]

Hi All,

I changed a column type as ref - to list as a dropdown.

In Appsheet its looks good

But the Returning Value in my google sheet is generated as a random number

Pls help i need the same value which showing in the Appsheet should be there in my google sheet.

[Suvrutt_Gurjar]

The reference column in the child table basically references parents table’s key. While displaying it in dropdown in the app , it displays the label of the parent table. If your key of the parent table is generated using UNIQUEID() , it will store the key in the backend Google sheet.

If you wish to store the label also of the parent table in the backend Google spreadsheet, please add and create a dereference column in the child table, that dereferences the label of the parent table.

Please take a look at the sample app and related articles

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

help.appsheet.com

Row Labels

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

help.appsheet.com

Dereference Expressions

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

[AUXWORK]

Prefect i got it…

Thanks a lot Suvrutt_Gurjar