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

  • osfgreenshow
    Asked on November 15, 2017 at 4: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.

  • David JotForm Support Manager
    Replied on November 15, 2017 at 5: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 Screenshot 10

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

    1510786233current Screenshot 21

    Let us know if you need more help.