Hi Everyone,
I have an app wherein I need to control the revision number whenever someone edits the details of that row item. This works well by comparing [_THISROW_BEFORE] <> [_THISROW_AFTER] using an automation.
However I came across on an issue wherein I am also required to add another count to the revision number if there are changes to its reference table (ie. there is an addition to the list of contacts)
Any suggestions that can help me breeze through this issue?
The goal is to add 1 on the revision number if the list below has additions/deductions/updated
Triggering another Bot from the child table and then update the revision in the parent record is probably the best way to do it.
Thanks @AleksiAlkio, what type bot should be the best to do this?
With the "Run action on rows" you can trigger an update action on your parent table.
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |