Condition to get current date is not working

  • Profile Image
    sleake
    Asked on February 09, 2018 at 11:42 AM

    The condition on my form is not working. It is supposed to update the 'Edit Date' field with the current date and it is not. Can you tell what is wrong with the condition? Thanks!

  • Profile Image
    Richie_P
    Answered on February 09, 2018 at 12:10 PM

    I cloned your form for testing purposes and I can't seem top replicate the issue.

    The date is up to date with the current date.

    Here is my screenshot.

    I have cleared your form cache, let us know if the issue still remains.


  • Profile Image
    sleake
    Answered on February 09, 2018 at 12:17 PM

    Thanks for checking. The first submission correctly starts with the current date. It's when the user makes changes and resubmits days/months later that the condition is not working.

    This form is designed for users to make monthly updates without refilling every field. That's why they don't start with a blank form each time.

  • Profile Image
    Richie_P
    Answered on February 09, 2018 at 12:25 PM

    Unfortunately,  even using a condition,we cannot auto update date time value in the form when editing submission data.

    However,I think I found an alternative method created by my colleague that might just help you. I pasted below the detailed instructions.

    Hello,

    As I understand you need a timestamp when a user edits a form submission. Unfortunately there is no widget or date field to do that. You need to do some tricks to do that. I researched a little bit about this issue and I found out a suggestion for you. Here are the steps:

    1) Add a {DATE} field on your email content without adding date field to your form:

    https://www.jotform.com/help/68-Add-a-Date-on-Email-Notification

    2) Add an 'Edit link' to the emails that you notify your managers (See step 3 for sending emails with conditions).

    https://www.jotform.com/help/40-How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date

    3) Also create an email that keeps track of all edits on the form. Also define conditions for other email alerts like if "this" field is filled send email to "that manager":

    https://www.jotform.com/help/167-How-to-Send-Email-Based-on-User-s-Answer

     

    In this set-up, when a manager edits the form, the general notification email alert will get the timestamp of the edit time, which I think is what you want.