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

Find more posts tagged with

Comments

Mike Fank

@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.

Pietro Poli

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.

Pietro Poli

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

Sean Sykes

@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

Pietro Poli

Yes @Sean Sykes, I've tested on my own.
I confirm that you can't trigger and filter on formula custom fields.

Sorry!

Sean Sykes

Hey it was a great idea!

Thanks