Is there a sample expression for doing a cascading update from a child table to a parent?
I need to update the status on a parent row when a child is changed.
@Gray_Young This example shows a parent record calling actions on its child records, but the same basic idea applies: appsheet.com - Reference Actions - This app shows how to use reference actions
The โReferenced Rowsโ part of the action definition would just be LIST([Reference column to parent]) Reference Actions - This app shows how to use reference actions appsheet.com
Hi @tony, I just need the same thing. I cant find the sample app you mention .
Can you please share the correctly link . to check it out ?
Regards,
Geovanni
@Geovanni_Gerardo_Roj It is always great to check out the documentation. I would start here https://help.appsheet.com/en/articles/961426-references-between-tables
To save timeโฆfirst Iโll assume you create the proper โIsPartOfโ reference connection between the two tables. After that if you want to update a field on the Parent with the child row as your current row, it is as simple as:
[Parent ID].[Field to Update] = โvalue to update withโ
The Parent Id is simply a ref to the parent record and you can apply the โdotโ notation to access/dereference any field on the parent record.
@Geovanni_Gerardo_Roj Hereโs the app I mentioned:
User | Count |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |