Re: Updating a value in Child table when Parent is...

Sitalia · 06-26-2021 05:59 AM

I have a Parent Table with the following columns

Id
Game Date
Game Format

others

I have a Child table with the following columns

Id
Game Date (which references the Parent table with “is part of” enabled)
Game Format

others

I want to keep the Game Format column in the child in sync with the value in the Parent table…so if the value in the parent is changed, the corresponding value in the child table needs to be updated for all rows where Game Date in Table 1 = Game Date in Table 2

Right now any updates to Game Format in the parent does not automatically update corresponding values in the child

Seen quite a few posts on this topic but unable to get it to work. Struggling especially with the expression to select the rows in the child table to update

Can someone please help

Thanks

Steve

What is the Ref column in the child table that refers to the parent row?

Sitalia

Game Date (which references the Parent table with “is part of” enabled) - as I mentioned in the earlier post…is this what you are asking for please?

Steve

Hmm… I hope not. Is Game Date the key column of the parent table?

Sitalia

Yes Steve…on one date only one Game

Steve

Well, that’s going to be a problem, then: AppSheet won’t let you change a key column’s value after the row is created. Instead, consider making the Id column the key column. Note that changing it will break any existing references between children and their parent.

Sitalia

oh ok…just wondering, its only the Game Format column that I want to update into the child when the Game Format in the parent is later changed

So lets say when i created the parent record the value of Game Format in the parent is XYZ…when I create a child table record the Game format column in the child table is auto populated with XYZ as I have a formula using a dereference…

The problem is when the Game Format column is subsequently changed to something else in the parent…so how so I get the updated Game format value now in the parent to be updated into the Game format column of the child table

Hope I am clear

Steve

Ah, okay. I missed that earlier.

One approach is to convert the Game Format column to a virtual column. As a virtual column, the value would update itself automatically. The downside is that a virtual column is not stored in your spreadsheet. Would this approach work for you?

Updating a value in Child table when Parent is updated