The orders that are being submitted via the jot form are not populating the Google spreadsheet behind it.

  • lauren.kelly
    Asked on November 4, 2015 at 6:45 AM

     

    When you go onto the DPD/Travis Perkins web site and order stationary via the following link

     

    https://sites.google.com/a/travisperkins.co.uk/dpd/services/request-stationery

     

    It allows you to order the required items and then I can see it appear on the submissions table in Jot Form but then the information is not populating our excel copy so we have no visibility of who is ordering what. I'm not sure if there is a problem with the link between the jot form and our spread sheet.  Could someone take a look at it and advise me please.  

     

    My phone number is07469 401965

     

    thank you with you help with this 

     

    regards

     

    Matthew Gomez

  • Ben
    Replied on November 4, 2015 at 11:24 AM

    I presume Matthew that you mean Google Spreadsheet instead of the Excel Spreadsheet. Looking at the form I see that you have indeed integrated your form with Google Spreadsheet.

    Now if you are no longer receiving the data in it, my suggestion is to recreate the integration.

    You can do that by:

    1. removing the current integration
    2. re-creating the Google SpreadSheet integration: How to Integrate Form with Google Spreadsheet

    Once you do, you would be able to push to the new spreadsheet all the old data as well.

    I do want to mention that the integration should not break on its own, so I presume that you have made some edits on your spreadsheet. If so, do note that moving the spreadsheet, renaming it or making edits in the sheet that is created by the integration will cause your integration to stop working again.