Need to send email if DATE is > this month

  • Profile Image
    carolturner
    Asked on March 26, 2014 at 10:18 PM

    My form is used to add items to a calendar. In actual fact there are 4 calendars that must be added, so I send emails to each of the 4 calendar admins.  

    However, 1 of those calendars cannot be modified once the month of the event has begun - so I don't want to send an email to that calendar's admin unless the DATE of the event being added is next month or after. Or DATE > this month.

    Any idea how I can do that? The only dynamic info I have found for conditionals and dates is today().

    Thanks!

  • Profile Image
    Cesar
    Answered on March 27, 2014 at 12:02 AM

    You can use the conditional rules on dates. This can be done aslong as you have a DateTime field to base your condition from. 

    Once you have the DateTime Field with the 1st of the month of your event. Then go to the conditional options on the top toolbar of the Form Builder, and select:

    Send an Email After Submission:

    https://shots.jotform.com/cesar/screens/datef2.jpg

    You can then set an Auto Response Email to be sent as long as the condition is met:

    https://shots.jotform.com/cesar/screens/datef.jpg

     

    Do let us know if you need further assistance. Thank you.

  • Profile Image
    carolturner
    Answered on March 27, 2014 at 09:22 AM

    Thanks, Cesar. Looks like you have set it up so that the date that I am comparing against is hard coded. Is there a way to dynamically set the comparison date? Or will I have to have a hard coded conditional statement for every month as follows:

    FOR THE MONTH OF APRIL, WHERE MUST BE SUBMITTED BY 25TH OF PREVIOUS MONTH(MARCH)

    IF Event Date: After "2014-03-31"

    AND IF Event Date: Before "2014-05-01"

    AND IF TodayDate Before "2014-03-25"  <- TodayDate is hidden field with today's date

    Send Notifier email to recipient@server.com

    REPEAT FOR MAY, JUNE, JULY, ETC.  

    Is this what I have to do? And there is no copy facility for conditionals? OLJ.

  • Profile Image
    Carina
    Answered on March 27, 2014 at 11:12 AM

    For now the conditions need to be created manually and while using the Jotform editor I believe it is necessary to define manually a date to setup the condition.

    I will forward the copy facility suggestion to our developers so they can evaluate the feasibility of this feature.

    You will be notified through this thread once they have an update on this.

    Let us know if we can be of more assistance.

  • Profile Image
    ELENA KATECHAKI 
    Answered on January 27, 2016 at 06:34 AM

    Dear Sir /Madam ,

     

    Wish you well!

    i would like to know if i can send an email today with date of 2014

    Thank you !

  • Profile Image
    victor
    Answered on January 27, 2016 at 10:08 AM

    To assist you better, I have created a new thread that will be answered shortly by our team.

    http://www.jotform.com/answers/757503