Google Spreadsheet Integration: how to update submission date upon submitting form on edit mode?

  • Profile Image
    osfgreenshow
    Asked on November 15, 2017 at 04:36 PM

    We use Jotform to let performing artist apply to our summer performance series. We are very excited to use the Edit Submission feature to allow the artist to update their submission from last year. We use GoogleDocs and GoogleSheets  to keep track of our submissions. Is there a way to capture the date of a submission edit. We are having new responder emails sent on edit but I cannot find a way to capture the edit date in the jotform submission itself.

  • Profile Image
    BDAVID
    Answered on November 15, 2017 at 05:52 PM

    Each time the form gets submitted through the edit link, the submission date will be updated to the date and time it was submitted again, however, it does not update to the already submitted entry found in the Google Spreadsheet integration.

    What you could do is to add a Date field setup with the current date:

    1510786143currentdate_001.png

    So, when the users submits it in the edit mode, and date will be updated:

    1510786233current.png

    Let us know if you need more help.