Is there a widget that update the "Latest Update Date"?

  • metapon
    Asked on May 18, 2017 at 11:04 PM

    Hi, 

    Is there a widget that update the "Latest Update Date"? 

    I want to hide this field and make it auto collect the latest date someone update. (or even better, someone changed the "status" field - so I know when was the last status change)

    What I tried already

    - Set regular date field to to hidden and set default to current date doesn't work

    - Date time single widget also didn't work for me. 

     

    form: (in thai language) https://form.jotform.me/70733000966452

     

    cheers!

  • jonathan
    Replied on May 19, 2017 at 2:21 AM

    What I tried already

    - Set regular date field to to hidden and set default to current date doesn't work

    I assume you were Editing the existing submission data using the Edit Link in the email.

    From what I remember, for the DateTime field value to change when editing the submission, you can use Conditions to trigger the date field to update.

    I will create a test form to check this functionality. I'll be back shortly.

     

     

     

  • jonathan
    Replied on May 19, 2017 at 2:56 AM

    I apologize for giving false expectation. As it turned out, the method I described which worked before is no longer possible on the current version of the Form Builder.

    There is no way to auto update a DateTime value existing in the form when editing submission data (either via Edit link or Edit mode).

    However, an alternative method that you may want to look at is having the Last Updated Date value show up in the Email or the Thank You message of the form.

    Check our user guide on : Add-a-Date-on-Email-Notification

    ---

    I found a solution offered by our colleague Seth on another private thread which I think is applicable to your requirement also.

    I pasted below the detailed instructions.

    Let us know if there is more we can help you with.

    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.