Update form field value condition not working to update a datetime field from another datetime field

  • GerMurphy
    Asked on February 13, 2015 at 2:36 PM

    Hi

    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.

    Thanks

    Ger

    Jotform Thread 515714 Screenshot
  • KadeJM
    Replied on February 13, 2015 at 5:02 PM

    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.

  • KadeJM
    Replied on February 13, 2015 at 5:47 PM

    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. 

    Update form field value condition not working to update a datetime field from another datetime field Image 1 Screenshot 40

    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.

    Update form field value condition not working to update a datetime field from another datetime field Image 2 Screenshot 51

    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.

     

    Update form field value condition not working to update a datetime field from another datetime field Image 3 Screenshot 62

  • GerMurphy
    Replied on February 16, 2015 at 5:28 AM

    Thanks.

     

    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!  :)

     

    Update form field value condition not working to update a datetime field from another datetime field Image 1 Screenshot 20

  • Ashwin JotForm Support
    Replied on February 16, 2015 at 8:51 AM

    Hello Ger,

    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:

    Update form field value condition not working to update a datetime field from another datetime field Image 1 Screenshot 20

     

    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.

    Thank you!