Automation for Column Update Does Not Work When Record Is Deleted in Child Table

[SM_LEARN]

Hello Team,

I have several tables to track employee salaries: PayStubs (parent), Cash, and Bank (children). When we pay employees, the "paid" column in PayStubs gets updated via a bot. This works fine when I add or change a record, but the bot doesn't seem to work when a record is deleted in a child table.

Thanks in advance for your help.

Regards,

San

[dbaum]

An automation's event that is triggered by changes in one table will never be triggered by changes in another table, even if the other table is a child table.

Create an automation triggered by changes in the child table.

[SM_LEARN]

Thanks for you response. I think automation is on the child table.

1) Any changes Cash Table event is trigger:

2) Referenced Table and Rows

3) Action perfomed on the PayStub Table to update the PAID column:

Please correct me.

Regards,

San

[dbaum]

---

@SM_LEARN wrote:

the bot doesn't seem to work when a record is deleted in a child table

---

What exactly happens? For example:

• The automation doesn't even trigger?
• The automation triggers but errors out?
• The automation triggers and completes but doesn't update the PAID column accurately?

ICYMI: Consider making columns (e.g., PAID) that aggregate (e.g., SUM) data from other tables (e.g., CASH) virtual columns, which always reflect current data, rather than data source columns, which depend on explicitly updating a row. 

[SM_LEARN]

• The automation doesn't even trigger? Yes. Only in Add or Update mode.
• The automation triggers but errors out? No. I checked monitoring unable to find out error and why in delete mode PAID does not get updated
• The automation triggers and completes but doesn't update the PAID column accurately? PAID column accurately updates only in add and update mode.

I will try VC option as per your recommendations. Thank you!

[dbaum]

---

@SM_LEARN wrote:

• The automation doesn't even trigger? Yes. Only in Add or Update mode.

---

What user interaction with the app results in deletion of a CASH table row?

[Suvrutt_Gurjar]

In case you wish to pursue the real column update path, You may find the below post thread and solution  by @Steve  in that post relevant. Please also take look at the below post in that thread. This queries related to  other dependent actions not getting executed when triggered by another delete action keep coming up. 

You may also want to take a look at the solution by Steve. Essentially the solution suggests performing dependent update actions first and then perform the main delete.

Auto Action after delete does not get triggered - Google Cloud Community