Issue with Ref. being pulled from Parent table to child table

[DPM_reports]

hi i have created 2 table namely

1. Attendance - Parent Table
2. 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

Please Help.

@Aleksi

[Lynn]

Hi @DPM_reports
Have you checked these out

help.appsheet.com

What is a Key?

Learn the purpose of keys and why they’re necessary.

If you want the Unique ID in the child table it needs to be the Key in the parent table. Your date is in the ID column as it is the key from the parent table. The date shows in the parent table as it is the label.
What is in column A?

[DPM_reports]

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…

[Lynn]

It doesn’t appear to be on your child form. Sorry Its getting late here I may be getting confused.

[Kanha_PM_Office]

I am facing the same issue with my child table.

[Steve]

DPM_reports:

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

Your keys and references are all wrong. Please read and understand the article @Lynn posted.

[DPM_reports]

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.

[Aleksi · Accepted 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.

[Kanha_PM_Office]

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.