What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

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

    Asked by metapon 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!

  • Profile Image
    JotForm Support

    Answered by jonathan on May 19, 2017 at 02: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.

     

     

     

  • Profile Image
    JotForm Support

    Answered by jonathan on May 19, 2017 at 02: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.