How to update a date field with current time while editing 2nd time?

  • Profile Image
    Asked on January 07, 2022 at 10:19 AM

    Jotform Integrations: Last Update Date Column


    I read the instructions here on how to work around the last updated date/time not passing to Google sheets. I understand the process outlined above.

    The instructions work for the first edit when the field is blank to begin with. However, for the second edit, the old date that is now in the table gets filled in the field and the date no longer updates.

    Is there a work around to make the field auto update with current date and time even if the form was previously edited?

  • Profile Image
    Answered on January 07, 2022 at 12:43 PM

    Greetings, 👋

    Thanks for contacting us.

    Please, allow me some time to check the issue.

    Soon we will reply back to you.



  • Profile Image
    Answered on January 07, 2022 at 01:17 PM


    Thanks for your patience.

    I was able to replicate the issue on my side. Now, I created a report for our developers for further checking.

    Please, note that we can't give you an ETA of getting an update from them regarding this case.

    As for the workaround, here's what comes to my mind.

    We need to create SHOW/HIDE conditions for your 2nd and 3rd Edit if needed.

    Guide: 👉 How-to-show-or-hide-fields-on-edit-url

    We will use the same trick as for the first edit case. However, instead of edit word let's use the second for the 2nd edit and the third for the 3rd edit.



    F2, F3 - Date Picker widget. Please, set them up with the same options as your first edit time field.

    2. In this step you need to create custom edit links

    Guide: How-to-change-the-text-of-the-edit-link-in-your-email-alerts

    These links in your case should be:{id}?second{id}?third

    {id} = submissions ID


    Please, let us know if you want a demo form for this workaround or a further detailed explanation.



  • Profile Image
    Answered on January 11, 2022 at 07:42 AM

    Hi there,

    We added "Last Update Date" to Google Sheets integration. You can use it.



    Please let us know if you need further assistance on this matter.


  • Profile Image
    Answered on January 16, 2022 at 06:03 PM

    Oh! Thank you!!! Is it possible to add this without Google Sheets integration?

    Our form is receiving data right now and I don't want to break integration with Google Sheets.

    Will a new column be created in Google Sheets by Jotform or would I have to create this column in Google Sheets myself?

  • Profile Image
    Answered on January 16, 2022 at 06:20 PM

    Hello there,

    You can edit your integration and check Last Update Date. Once done, a column for it will be automatically created in Google Sheets.


    Let us know if you have any other concerns. 

    Thank you.