Trigger Email Notification X-number of days before value in Custom Form Date Field? | Community
Skip to main content
RPalmer-SSC
RPalmer-SSC
Level 2
April 21, 2023
Question

Trigger Email Notification X-number of days before value in Custom Form Date Field?

  • April 21, 2023
  • 2 replies
  • 1070 views

We're considering Fusion, and I was wondering if it is possible to trigger an email notification based on a set # of days before the value in a date field? For example, if I have a "contract ends" date field in a custom form, I would want an email notification sent from Workfront 90 days before that date value as a reminder. Is this possible with Fusion?

 

Thank you!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    Jason_JB
    Jason_JB
    Level 5
    April 21, 2023

    Yes, if I was building this in Fusion I would likely use a scenario that runs daily and searches based on the criteria above. Others have more experience with the email notifications and can speak to any items to watch out for, but your ask is doable.

      RPalmer-SSC
      RPalmer-SSCAuthor
      Level 2
      April 24, 2023

      Thank you!

      ewanh
      Adobe Employee
      ewanhAdobe Employee
      Adobe Employee
      April 21, 2023

      Using the addDays function with a negative "-" date should do the trick: {{addDays(now; "-" + 90)}}.

       

       We have a few variations of how this works built into our templates like: Workfront - Cleanup requests with no new notes in past 30 days.

       

      A little more complex than what you need here...but an example:

       

        RPalmer-SSC
        RPalmer-SSCAuthor
        Level 2
        April 24, 2023

        Thank you for the example! Much appreciated...

        Terms & ConditionsAccessibility statement

        Loading footer...