Conditions > Dates: Conditionally adding X days not working

Hi,

Every Thursday, I send a JotForm for the people to register for our bridge activiy the following Monday.

Is there a way to show the following Monday's date into the form, to indicate the date they would be playing?

Thank you

Hi Normand,

Thanks for reaching out to Jotform Support. The user may submit your form on a different day after you sent the form, so it is hard to create a formula that will fill their play date based on the date they submitted your form. The best way I can think of is to add the Date Picker element in your form, set a custom date, and then show the field based on condition set. Let me show you how:

• In Form Builder, click on the Add Form Element menu on the left side of the page.
• Under the Basic tab, scroll down to Date Picker. Drag and drop the element to your form.
• Select the Date Picker and click on the Gear icon to access its Properties.
• Under the Options tab, select Custom and select the Monday date.
• Under the Advanced tab, toggle the Read Only and Hide Field switch to On.

Now, let's set up the conditional logic what will display the Date Picker. Let's do it:

• Click on the Settings tab in the orange navigation bar at the top of Form Builder.
• Select Conditions on the left side of the screen.
• Select Show/Hide Field.
  
• Set the then set the conditions just like you see below.
  
• Finally, click on Save.

Here's a screencast of the expected form behavior:

Reach out again if you need any other help.

Thank you.

I should have added the word "automatically" in the following sentence.

Is there a way to "automatically" show the following Monday's date into the form, to indicate the date they would be playing?

If I understand correctly your solution, I would have to modify the form every week to change the date.

In that case, I simply can add a text (paragraph) field and write the date.

I would like to show the date of the Monday following the date when they fill out the form.

Thank you

Hi Normand,

Thanks for reaching out to Jotform Support. If I understand correctly, you will only send the form every Thursday for people to register for your bridge activity. Is that correct? If so, you can easily use the date string in form calculations to automatically show the date on Monday when they will play in a few easy steps. Let me show you how.

1. In Form Builder, on the left side of the screen, click on Add Form Element.
2. Click on Date Picker, go to Widgets, and click on the Form Calculation Widget.

We have to set the date picker to default to current.

1. In Form Builder, go to your Date Picker and click on the Gear Icon.
2. Go to Options, and on Default Date, click on Current.

To calculate the date using the form calculation widget, using the date string.

1. In Form Builder, go to your Form Calculation Widget and click on the Wand Icon.
2. Click on the Three Horizontal Dots, scroll down, and select dateString().
3. Click on Add Field, click on Date (your date picker), click on the Plus Sign (+) and the number 4, and finally click on Save.

Here is the calculation in the form calculation widget.

Here is a preview of the cloned form, and for testing purposes only, I have set the date for Thursday.

Here are guides on How to Perform Form Calculation Using a Widget and Form Calculation: Math Function Reference.

Let us know if there’s anything else we can help you with.

Thank you again for trying to help me.

However, I had not wanted to repeat the sentence written by Chris, above. He wrote: "The user may submit your form on a different day after you sent the form, so it is hard to create a formula that will fill their play date based on the date they submitted your form."

Therefore the calculation that you are suggesting, only works if they submit the form on the Thursday. Therefore when someone fills out the form on a Friday or Saturday, the date will be incorrect.

Would you have another suggestion?

Thank you

Hi Normand,

I'm sorry for the confusion. My initial understanding that you will only need to get the next Monday after you sent the form. The first step is to identify what day is the current date (I named it booking date in my demo form). To do this, we will be using Form Calculation widget, we will set this to hidden. We will also need to create a conditional logic. Let me show you how:

1. In Form Builder, click on the Add Form Element menu on the left side of the page.
2. Under the Widgets tab, search for Form Calculation. Drag and drop the widget into your form.
   
3. In the widget Settings that opens on the right-side of the page, set up the operation as shown in the screencast below.
   
   
4. Finally, click on Save.

Next, let's set up the conditional logic. Here's how:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2. Click on Conditions in the menu on the left side of the page.
3. Click +Add a New Condition.
   
4. Select Update/Calculate Field and then set the conditions just like you see below if the user selects Thursday in the booking date.
   The value is 4 because the user filled out the form on Thursday, thus, there are 4 days before the next Monday.
5. Finally, click on Save.

Here is a screencast of the form in action:

Here is the link to my demo form. Feel free to test or clone the form to inspect the settings.

Give it a try and let us know how it goes.

Wow... It works well.

Thank you, very much.

It's great.

I really appreciate your outstanding services.

Thank you again and have a great day

You did great
Thank you
De : Jotform <noreply>
Envoyé : October 3, 2023 13:00
À : info <info>
Objet : Your ticket has been answered. Tell us how we did!
[Jotform]<https:>
View this email in your browser<https:>
[Autoresponder]
Support ticket answered:
How to automatically enter a date?
Hello NormandDegre,
Your support ticket "How to automatically enter a date?<https:>" has been answered. If you still need assistance, just reply to this email.
Click one of the icons below to let us know what you think of our service and how we can improve.
[icon face 1]<https:>
[icon face 2]<https:>
[icon face 3]<https:>
[icon face 4]<https:>
[icon face 5]<https:>
Thank you as always!
[Jotform Team]
4 Embarcadero Center, Suite 780, San Francisco CA 94111
24/7 Support<https:>
Unsubscribe Thread<https:>
</https:></https:></https:></https:></https:></https:></https:></https:></https:></https:></info></noreply>...

Hi,

Sorry to bother you again.

The date calculation worked for a while on my form. However, the calculation is now incorrect and I cannot figure out what is wrong.

The hidden field "Jour de la semaine" (weekday) does not seem to indicate the day of the week.

Please help.

The field "Vous vous enregistrez pour la partie du lundi le:" should indicate the following Monday

https://www.jotform.com/build/232604175783964

Thank you

Hi Normand,

Thanks for getting back to us. I'm really sorry that this is happening. Because of your form's access settings, I can't clone your form to test it on my end.

But, I've gone ahead and cleared your form caches to see if it would fix the issue. If the issue still persists, please try to remove the Date Calculation that you've set up, and add it again. Can you go ahead and try it again and let us know how it goes? If the same thing happens again, we'll investigate it more to see if we can figure out what's going on.

Give it a try and let us know how it goes.

Thank you

Since I did not want people to register before the problem was fixed, I had deactivated the form. Sorry.

I added a text showing the correct date and hid the field with the wrong calculation.

I was not able to fix it.

A calculation is made, but I get the Sunday instead of the Monday date.

Thanks

Hi Normand,

Thanks for getting back to us. I’m really sorry that this is happening. I cloned your form and tested it to see if I could replicate the issue, but everything was working properly. Check out the screencast below to see my results:

Could you try using a different internet browser or incognito/private mode if it makes a difference? Can you try it again and see how it goes? If you run into the same issue again, let us know, and we'll do some more testing to see what's going on.

Let us know if there’s anything else we can help you with.

Thank you.

It is very strange. I also created a clone to test various possibilities. I changed the date in the "Date d'enregistrement" field.

The calculation works for any dates after November 6th, but not for the dates between November first and November 6th. I always get November 5th as the calculation result.

Original form: https://www.jotform.com/build/232604175783964

Hi Normand,

I'm very sorry to hear that. I'll need a bit of time to look into this. I will be back shortly.

Hi Normand,

Thanks for patiently waiting. I cloned your form and was able to replicate the issue. The Vous vous enregistrez pour la partie du lundi le field does not change regardless of the Date entered on Date d'enregistrement. Check out my screenshot below to see my results:

I created a ticket and escalated this to our Developer team. Although we don't know exactly when the issue will be fixed, we’ll circle back to this thread when we have an update.

As for your other question, I've moved it to a new thread to avoid confusion. Please wait for my reply here. 

Thanks for your patience and understanding, we appreciate it.

Hi Normand,

Thank you for reaching out to Jotform Support. There is a better way to build these conditions. I will show you an example.

These are the conditions I set for a demo form:

If you want to check for a date, you can use IS EQUAL TO DAY state when you build your Update/Calculate Field condition.

You can try this demo form and you can clone it. To clone, you can refer to this guide.

Give it a try and let us know how it goes.

Thank you

That worked in my cloned form.

I will modify my original form next week and let you know if I still have an issue.

Thanks again