Action to Set values of some columns in this row not updating

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

3X_6_4_648636571aff326338fc8d12feee28336ef862e9.png

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

3X_9_b_9bc019f027d373b217a448aeaaab889353f99b26.png

The expression for getting the Cancellation column value from the source row is below….

3X_6_3_631ac94089377f3148eae1f0ba124ceb4025a637.png

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

0 2 1,053
2 REPLIES 2
Top Labels in this Space