Jotform Integrations: Last Update Date Column

  • Profile Image
    rtolmach
    Asked on February 24, 2021 at 03:21 AM

    Hello Jotform

    If someone submits a form at, for instance, 1pm, and then they edit it at 2pm, how can I capture the time they submit the edited form?

    I actually want to know both date/times: original submission and edit.

    Thank you!
    Robert

  • Profile Image
    Jovanne_A
    Answered on February 24, 2021 at 07:22 AM

    Hi Rober, thank you for contacting support.

    You can check the Last Update Date column on the Table.

    1614169330_603644f2e53b5_1.png

    I hope this helps. Let us know if you have further questions.

  • Profile Image
    rtolmach
    Answered on February 24, 2021 at 08:33 PM
    I see that I can use the Show/Hide Columns to add the “Last Edit” update to a Jotform table. If I do that, then when I use the google sheet integration, will that column appear in the google sheet?
    Thanks

    Robert Tolmach
    Co-Founder
    ChangingThePresent.org
    rtolmach@ChangingThePresent.org




    ...
  • Profile Image
    rtolmach
    Answered on February 25, 2021 at 01:44 AM
    I understand how to do what you described, and it works in the jotform table.
    However, when I integrate the form with Google sheets, that new “Last Update Date” does not appear in the google sheet. I do not see how to make it appear there.
    Can I make the integration go from the jotform table (as opposed to defining it in the jotform) so the “Last Update Date” appears in my google sheet? I really need that info there.

    Thanks

    Robert Tolmach
    Co-Founder
    ChangingThePresent.org
    rtolmach@ChangingThePresent.org




    ...
  • Profile Image
    octavius
    Answered on February 25, 2021 at 06:38 AM

    Hello,

    Thank you for the clarification. Unfortunately, it is not possible to add the "Last Update Date" column to the Google Sheets Integration since it is not an actual form field on your form. However, we have escalated your request to our developers. However, we can’t give you an ETA on it, as it depends on their workload. We will inform you on this thread if they have any updates.

    As a workaround for your needs, you can add two different Date Picker fields and Get Page URL Widget.

    Please follow these steps,

    1) On the Form Builder, click the Add Form Elements button and add the First Date Picker field. Then, set up the Date Picker field.

    1614252080_603788300ad60_sc1.gif

    2) Add the Second Date Picker field and follow the same steps.

    1614252234_603788ca96080_sc2.gif

    3) Go to the Widgets tab and add the Get Page URL Widget to your form. Once you add the Widget, you can hide it.

    1614252326_603789267c56a_sc3.gif

    4) Go to the Settings tab and open the Conditions section. Select the Show/Hide Field option. Then, set up the condition.

    1614252456_603789a8c5c74_sc4.gif

    5) Set up the Google Sheets integration.

    You will be able to view the date that your users fill your form on the Current Date column and you will be able to view the date that your users edit their answers on the Edit Date column.

    6) From the Properties of the Date Picker field, you can enable the "Read Only" feature so that your customers will not be able to change the Date Picker value while editing their answers.

    1614253023_60378bdf1282e_Screen Shot 202

    Here is a screencast,

    1614252903_60378b67ba577_sc5.gif

    If you need further assistance, please let us know.