Thank you in advance for your help and insights about this issue:
I have a parent table called db_rmas with a column named Manufacturer_Status, and child table called rma_updates referenced to the db_rmas with a column called Update. What I want to achieve is that anytime there is a new row in the child table the data from the column update make copies the same exact update in the Manufacturer_Status Column from parent table. This is what I have done so far but it is not working.
1. I created an action for the child table (rma_updates) to trigger another action to the referenced row
2. Then I created another action to set the values of the referenced child to table to the Manufacturer_status column in the parent Table:
FInally I created an automation so that anytime a row is updated from the child table (rma_updates), it may run a data action to run the Referenced action Update RMAs Status previously set in Actions:
After doing this, when creating a new record in the child table, the column manufacturer_status doesn't change at all.
If there is another way to do it, I appreacite your suggestions
Should the highlighted part in the bot, the referenced table be set to db_rmas rather than rma_updates?
Also the referenced action name should be "Set Manufacturer Status from latest Update"?
You're right. I was wrong about that setting, but I changed that and still the row value doesn't sync change to the parent table ๐
Please check what errors if any " Audit History " and " Automation Monitor" are showing when you run the bot.
User | Count |
---|---|
15 | |
9 | |
9 | |
7 | |
3 |