I am trying to set the value of a field in a row when the same field in another row of the same table is edited by the user
Above is the table……so when the user changes the value of the “Cancellation” Column of the 2nd last row, I want the “Cancellation” column of the last row to be updated with the same value, which is TRUE
The two lines are linked through the “Related Journal” column which cross references as you can see (734a2e84)
I have set up an action as below
The expression for getting the Cancellation column value from the source row is below….
Have set up a BOT to automate this whenever there is an EDIT event
The BOT run successfully which I checked in the Automation Monitor
However the update in the target row does not happen
Any pointers please where I am going wrong
User | Count |
---|---|
40 | |
35 | |
30 | |
23 | |
17 |