Regarding reminder email regarding appointment date

Dear Support Team,

I want send an email reminder to the PI one week before the end date of the project staff tenure. In this regards, I have created two field "Last Date of Appointment" with Date Picker basic element and another field with "reminder date" again with Date picker basic elemnt.

Now I set the conditions as follows :

But when i am trying to save the condition, i am getting a message as

Please make necessary corrections before saving. May i know the reason and if possibly can correct the mistake

Thanks & regards

Sachin

Hi Sachin,

Thanks for reaching out to Jotform Support. I'll need a bit of time to look into this. I’ll get back to you as soon as I can.

Thanks for your patience, we appreciate. 

Hi Sachin,

To meet your requirements, you will just need to adjust the condition to send a reminder email 1 week before to the form filler. Let me show you how:

1.In Form Builder, click on the Settings Tab at the top, then go to Conditions Tab on the left side panel.

2.Click on the +Add Condition button, then select Update/Calculate Field element from the options.

3.Set the recommender condition below:

4.Go to Emails Tab, then click on the +Add Email button, select Autoresponder Email from the options.

5.Go to Advanced Tab, then under Send Email Later option click on the dropdown and select the Reminder Date field.

Give it a try and let us know if you have any other questions.

Dear Support Team,

Thanks for your reply. As suggested, I have applied the condition as below

But when I checked the submissions in the table. I found that the reminder date is not as per our expectations. Please have a look

Ideally, as per the data, the reminder date should be Jul 5, 2025. But here the reminder date is Nov 30, 1899. and it's uniform for all the submissions. Can you please help me to sort it out.

Thanks & regards

BioE office

Hi Sachin,

I was able to replicate the issue in my cloned form. After investigating, I found the solution. Instead of using the dash (-), you just need to use the comma (,), just make sure that the coma is set as numeric not as string. Take a look at the screenshot of the condition below:

Take a look at the screenshot of the result below:Give it a try and let us know how it goes.