Data: set the values of some columns in this row to changes in specific column only

Peter_S1
Participant IV

Hi,

I’ve created an action with Data: set the values of some columns in this row to insert today’s date when the a value of a Status column equals to Completed. Then in the Workflow I have the Update Event to Updates_Only and set the condition to [Status]=Completed.

So the above works and it inserts today’s date when the Status is changed to Completed. The issue is that when any sort of change takes place in that table (to other columns) it triggers the action. For instance, when a start date is changed, it would update the completion date today. Is there away to have the action trigger only if the change occurs to a specific column (status column only in this case).

Solved Solved
0 2 456
1 ACCEPTED SOLUTION

Please consider following

Option 1

Are the other columns changing after the Status column has moved to “Completed” status? That is probably happening because the workflow condition [Status]=Completed is true in all cases on all updates. Please consider a workflow condition something like
AND(
[_THISROW_BEFORE].[Status]<>[_THISROW_AFTER].[Status], [_THISROW_AFTER].[Status]=“Completed”
)

It will ensure the workflow listens to only changes in the [Status] column
Please refer below relevant post and article referred therein

Option 2
Another alternative you could explore is to use the Changetimestamp type column for your requirement that listens to changes in the status column and captures the change date.

https://www.appsheet.com/samples/Keep-track-of-when-columns-change?appGuidString=8a1572da-c548-418c-...

View solution in original post

2 REPLIES 2

Please consider following

Option 1

Are the other columns changing after the Status column has moved to “Completed” status? That is probably happening because the workflow condition [Status]=Completed is true in all cases on all updates. Please consider a workflow condition something like
AND(
[_THISROW_BEFORE].[Status]<>[_THISROW_AFTER].[Status], [_THISROW_AFTER].[Status]=“Completed”
)

It will ensure the workflow listens to only changes in the [Status] column
Please refer below relevant post and article referred therein

Option 2
Another alternative you could explore is to use the Changetimestamp type column for your requirement that listens to changes in the status column and captures the change date.

https://www.appsheet.com/samples/Keep-track-of-when-columns-change?appGuidString=8a1572da-c548-418c-...

Thank you, Suvrutt, option 1 works! Appreciate the help.

Top Labels in this Space