-
ocstokrodeAsked on March 15, 2021 at 5:52 AM
Hi
We want to achieve when a customer will book a meeting room on Saturday he will get the room for the weekend (Saturday and Sunday). I believe I can manage this, but I' struggling now to calculate a date +1
I have made a test form
This works and I can also get the name of the date (current for test purpose only Monday is defined and working). But the formule date+1 went wrong. I get a number calculation in stead. 18694,96 ???
The condition rule I used to calculate the +1 date is:
And I also need the "name of the day"+1
Please can you help me and also tell what I did wrong?Thanks a lot!
MarcPage URL: https://form.jotform.com/210732631733045 -
Sigit JotForm SupportReplied on March 15, 2021 at 11:01 AM
Greetings,
Kindly allow me some time to conduct some tests.
Thank you. Regards.
-
Sigit JotForm SupportReplied on March 15, 2021 at 11:39 AM
Greetings,
Thank you for your patience.
This is my cloned version of the form https://form.jotform.com/210733896140960
If you want to duplicate the form, please follow this guide: https://www.jotform.com/help/42-how-to-clone-an-existing-form-from-a-url
It is possible using Calculation widget and Conditional logic.
The Calculation widget dateString function can change the date into string, then use Conditional logic to populate the other fields.
I.e. Capturing Mon on the Booking Date (String format) and populate Booking Day Date field with Monday.
Repeat the process for the other days.
Calculate a date + 1 and populate Booking Date + 1 field
The Calculation widget dateString function can change the date into string.
Related guides:
- https://www.jotform.com/help/259-how-to-perform-form-calculation-using-a-widget
- https://www.jotform.com/help/267-form-calculation-math-function-reference
- https://www.jotform.com/help/57-smart-forms-conditional-logic-for-online-forms
Please give it a try, and let us know if you need further assistance.
Regards.