Updating a value in Child table when Parent is updated

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

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

  • 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?

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

Yes Steve…on one date only one Game

1 Like

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.

1 Like

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

2 Likes

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?

See also

Thanks so much Steve ! This works perfectly and everything falls into place

Just one more questions…

How do you remove these In Line buttons?

image

1 Like

Ok got it…its from the Slice Actions…thanks

2 Likes

Hi Steve
I have same above problem but if i use virtual column (data studio google need to use child table to do report , it can not see virtual column. Can we have another ways?