Field Match Trigger
I have two Custom Fields which are Date fields. They cannot match and the second field cannot precede the first.
If either of these occur I would like to trigger a message.
Possible? Not possible?
Cheers
Sean
0
Folllowing List for Post: Field Match Trigger
[this list is visible for admins and agents only]
Sean Sykes - how are the fields filled in?
If one of them is filled in after the other, an automation could trigger based on the "when custom field changes" trigger.
If both are done in the same form, I don't know of a way to trigger a notification.
Hi Sean Sykes,
is not possible with standard automations in Wrike.
You need to manage this kind of flow with external software or Wrike Integrate.
Hi Sean Sykes,
I've an idea to test.
You have two date fields, you can create a third field that is a calculated field
([First date]-[Second Date])/8
so calculation has the number of days between two dates.
Then you need to create 2 automations with 2 different triggers:
1- If First date changes
2- and if Calculated Field >= 1
3- Then do some actions
and
1- If Second date changes
2- and if "Calculated Field" >= 1
3- Then do some actions
it should work =)
Let me know
Pietro Poli for some reason the Calculated Field does not show up when I select Custom Field under the And if section of the Automation.
This is my Calculated Field
Yes Sean Sykes, I've tested on my own.
I confirm that you can't trigger and filter on formula custom fields.
Sorry!
Hey it was a great idea!
Thanks