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

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

    Jotform Integrations: Last Update Date Column

    Hello.

    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
    Alexander_G
    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.


    Thanks,

    Alex


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

    Hello,

    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.

    1611348277_600b39352fa45_

    1611348300_600b394c7cf6f_

    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:

    https://www.jotform.com/edit/{id}?second

    https://www.jotform.com/edit/{id}?third

    {id} = submissions ID

    1611348743_600b3b07ccbe0_


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


    Sincerely,

    Alex

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

    Hi there,

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

    1641904807_61dd7aa789dbd_

    1641904915_61dd7b13daab5_

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

    Regards.

  • Profile Image
    dhrupal.atlanta
    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
    Cecile_A
    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.

    1642375185_61e4a8116d929_7.png

    Let us know if you have any other concerns. 

    Thank you.