When user edits form response more than once, Current Date is not working

  • ilutheran
    Asked on May 1, 2019 at 11:27 AM

    We added a hidden date field to our form yesterday, setting it to always default to the current date. Our form users will be editing their forms at least twice, but this date field is not automatically updating to the current date when they are editing their response for the second or subsequent time.

    After we noticed the problem, I even then set the field to not allow "Past" or "Future" dates, and changed the "Read Only" setting to off (it had been "on"), but these settings apparently don't affect fields that are hidden from respondents? I tested it on my own form response, which I edited at 11am EST today, May 1st, and have attached the screenshot of the resulting date in this field after submission. 

    How can I get a date field on a form to update to the current date each time a respondent updates his/her survey, without requiring this date to be manually entered by the respondent?

    Thank you,

    Ann Winter

    Jotform Thread 1809865 Screenshot
  • BJoanna
    Replied on May 1, 2019 at 12:43 PM

    When the form was originally submitted the date field captured the current date. The date will not be changed when a form is edited, because the field was already populated.

    If you want to capture the Edit date, a possible solution is to set conditions to show the Date fields. 

    1556728799EDIT Screenshot 10

    How to Show or Hide Fields Base on User's Answer

    Here is a demo form - https://form.jotform.com/91204694689974 

    Feel free to test it and clone it

  • ilutheran
    Replied on May 1, 2019 at 2:26 PM

    So I'm understanding you to say that the survey respondent would have to manually enter the date when they edited their survey? There is no way to have the current date automatically populate a date field whenever a survey is updated by a respondent?

  • jonathan
    Replied on May 1, 2019 at 5:03 PM

    There is no way to have the current date automatically populate a date field whenever a survey is updated by a respondent?

    Unfortunately that is correct. There is no update script that can trigger changing the saved date field value to change to current date every time the form is in edit mode

    The most you can do is to trigger the user to manually modify the date value to the current date. You can do using the Get Page URL widget to detect that it is in "edit" mode.

    1556744530zzz 2019 05 02 04 Screenshot 10


    You can create Conditions when the form is in "edit" mode.

    Ex:

    1556744569zzz 2019 05 02 04 Screenshot 21


    Let us know if you need further assistance on this.