Hi there,
I’m trying to make an action-triggered workflow to notify users. The sequence is that one user is working on a specific entry and when they’re ready, there is a share button (action) that sets the value of a hidden timestamp column to now(). There is then a workflow that says whenever there is an update to entries on this table it should fire an email to the right people, but only when ISNOTBLANK([hidden timestamp column]). But the email is fired on every update, even without the condition being satisfied.
Any suggestions? thanks
Olivia
Solved! Go to Solution.
Use AND(ISNOTBLANK([TimestampColumn]),[_THISROW_BEFORE].[TimestampColumn]<>[_THISROW_AFTER].[TimestampColumn]). This will fire your Workflow only when the action button is pressed.
Use AND(ISNOTBLANK([TimestampColumn]),[_THISROW_BEFORE].[TimestampColumn]<>[_THISROW_AFTER].[TimestampColumn]). This will fire your Workflow only when the action button is pressed.
excellent, thanks a lot!
You’re welcome
User | Count |
---|---|
25 | |
24 | |
24 | |
20 | |
16 |