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
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.
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
@SM_LEARN wrote:
the bot doesn't seem to work when a record is deleted in a child table
What exactly happens? For example:
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.
I will try VC option as per your recommendations. Thank you!
@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?
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
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |