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.
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
Prefect i got it…
Thanks a lot Suvrutt_Gurjar
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |