hi i have created 2 table namely
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
Please Help.
Solved! Go to Solution.
Using the date as a key in your parent table is fine… unless you have more users using the app at the same time. Then it can happen that two users are adding the same date value and then you can have duplicate records. Anyway… when using two different columns with the key and the label column, the key column’s value is always saved to your data source with the child record. The app will just show the label column’s value in the child record.
Hi @DPM_reports
Have you checked these out
i tried another workaround where i made the date both key and label…
Inspite of this in the app i see the ref. date being shown in the child table…but the same info is not being posted in the Google sheet…It shows blank in the google sheet…
It doesn’t appear to be on your child form. Sorry Its getting late here I may be getting confused.
I am facing the same issue with my child table.
Your keys and references are all wrong. Please read and understand the article @Lynn posted.
I seem to be confused…I read the article…can u Pls help me on this.
I don’t mind changing my key in parent table…but I don’t want the date to be duplicated and have 2 entries with same date.
Using the date as a key in your parent table is fine… unless you have more users using the app at the same time. Then it can happen that two users are adding the same date value and then you can have duplicate records. Anyway… when using two different columns with the key and the label column, the key column’s value is always saved to your data source with the child record. The app will just show the label column’s value in the child record.
Hi,
Parent Table Data
PA Id # -> Key
Child table Data
The PA Id # is not shown in the Child Table.
Before, it’s working fine. I changed the columns structure & regenerated & facing this issue
I also, changed the Security Filter to FALSE to support data as guided.
Any idea why?
Thank you.
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |