JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Update form field value condition not working to update a datetime field from another datetime fieldAsked by GerMurphy on February 13, 2015 at 02:36 PM
I'm new to JotForm. Testing it out ahead of migrating from Adobe FormsCentral.
Ive built a responsive form but an aspect of it has stopped working. I want a date field to update another date field when changed. In particular I want a start date in a date range (StartDate and EndDate fields) to determine the end date in the next date range. Basically I want to track someone's employment record over the last 5 years with no gaps.
I had set up an "update form field value" condition as If StartDate1 is filled then StartDate1 value to EndDate2.
This was working yesterday but after some other changes today it is no longer working.
Any advice would be much appreciated.
Thank you for your interest in joining us here at JotForm, we'd be more than happy to help.
To my understanding I see that you want to use conditional logic to generate an employment form with no gaps in the employment history timeframe.
If your conditional logic has stopped working properly after some changes were made then most likely it is because a conflict probably exists within your form.
Fixing it may be a little tricky depending on the situation so usually if there are lots of conditions you can either try disabling the recent or field specific ones to narrow it down. It's usually best to make a clone and try it on the double to avoid complications of making it worse.
Please allow me some time to continue to look through your jotform here to test it more accurately and I will get back to you as soon as I can if I find anything that we need to help you fix possibly.
So after looking into this some more so far I believe I found a possible discrepancy where StartDate #1 is automatically updating the value in the EndDate #1. But, I think based on what you said above about your issue that you meant for that to populate the EndDate #2.
I believe I found the issue though because I noticed on several of your datetime field conditions that the "insert as text" option isn't checked. If you go back through that should fix it for you.
Here's a demo form of what I mean by that: http://form.jotformpro.com/form/50437099295969?
If you look at my demo form you'll notice it has 4 date fields 1,2,3,and 4.
If you fill in Date 1 you'll note that it will populate Date 3 on the next page. However, if you fill in Date 2 you'll notice that this does not populate Date 4. That is because that box to insert the field data as text is not ticked in the conditional value options for it to read that text tag input to carry over so it thinks there is a value where there is not one and just skips over it because of that.
I have ticked the "add field to equation as text by default" on all the conditions and still no luck.
Also, in your first screen shot above it shows the StartDate1 and EndDate1 as linked but they are not. Its just because the default date in EndDate1 is filled and you selected todays date as StartDate1 so it appears as if they are linked.
Could you have another look please? Sorry! :)
I believe that after enabling the " Add field to equation as text by default.", you will have to remove the date field name and select it again. Please check the screenshot below:
Please take a look at the following cloned form and see if this works as expected: http://form.jotformpro.com/form/50463140923953?
Feel free to clone this form for a closer look. The following guide should help you in form cloning: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL
Hope this helps.
Do get back to us if the issue persists.