Submission was not included in the integrated Google Spreadsheet

  • Profile Image
    l.doig
    Asked on August 04, 2015 at 07:27 PM
    I have another enquiry please, I note one of the submissions were not included on the integrated spreadsheet. I note this person added their name and last name in the name field as supposed to name in name field and last name in last name field. Could this be the reason or should I look for another trigger that could have caused this?

    The form is under my submissions and if I download all submissions as an excel sheet, it does show there too, just not on the integrated sheet. Does this mean I’ll have to do a comparison to ensure all my entries are on the integrated sheet, as I’ve shared this one with my Principal to work from?
  • Profile Image
    jonathan
    Answered on August 04, 2015 at 10:52 PM

    Hi,

    Basically what you were saying is like this.

    There was a submission in the form that does not appear in the integrated Google Spreadsheet, BUT it appears when the submission is downloaded as Excel file.

    Can you please tell us which submission it is on your form http://www.jotform.com/51038455978870

    I know you have done the google spreadsheet re-integration process also for the form, but for another time, can you please redo the process again? Check afterwards if that missing submission now also appear on the Google Spreadsheet.

    We will wait for your updates.

    Thanks.

  • Profile Image
    l.doig
    Answered on August 04, 2015 at 11:25 PM
    Thank you, yes it seems to be fine now, I just opened it again it the entry was there! I noticed all my conditional formatting was gone, it almost looks as if I did do the re-integration, even although I haven’t. We’ve had some server issues in the last couple of days, I wonder if it’s related to this?? Anyhow, it is fixed now and all seems well.

    Many thanks again for your prompt response.

    Kind regards

    Lorraine Doig
    Principal’s PA
    Bethlehem College

    ...
  • Profile Image
    Chriistian
    Answered on August 05, 2015 at 01:21 AM

    Hi Lorraine

     

    On behalf of my colleague, Jonathan, you are welcome. Glad to hear that the issue is fixed now.

     

    Do let us know if you need further assistance.

     

    Regards.