hi i have created 2 table namely
- Attendance - Parent Table
- Work Log - Child Table
In the Parent Table i have made Date as Key and Unique ID as Label
In child table i have a column Attendance ID which is being referenced from the Parent table Unique ID
The issue is when in the Appsheet editor preview while testing it shows the child table pulling the attendance ID from the parent table to the child table, which is correct.
But while the data is transferred to the Google Sheet. the Child table shows the Date(Key) in Attendance ID, which is supposed to be the Unique ID of Parent Table.
Screenshots of issue as below,
Parent table entry as in preview
Child Table screenshot - Preview
Child Table Data in Google Sheet after saving
I have made Date as key in Parent Table so that there are no no rows with the same date