Cannot find my original jotform spreadsheet that resulted from survey responses

  • dhammadena
    Asked on April 12, 2017 at 1:05 AM

    Egads! This is a nightmare. My responses had been going into my googlesheets, but then the data became terribly corrupted in that mode.  When I just now tried to access my original data via jotform website, I could not find my spreadsheet data anywhere.

    Jeeze! I can't believe that the data has been corrupted. All the first data fields are missing and instead there is a repetitive date overwriting the first 13 cells in each row. Also, the data does not transfer accurately into Googlesheets, which is a real drag.

    If you can't fix this, I will be up shits creek.

    Not sure if this is helpful, but I copied and pasted the spreadsheet and you can see the repetitions.

    Submission Date Submission Date Submission Date Submission Date Submission Date Submission Date Submission Date Submission Date Postal / Zip Code Country E-mail 2 Arrival Date Departure Date Airport pickup needed Airline and flight Number Date Time Airline and flight Number 2 Date 2 Time 2 Do You Have Special Dietary Needs? Do You Have Special Housing or Health Needs? Have You Ever Attended A Retreat at Dhamma Dena? Are You New to Vipassana Meditation? Payment Information, select one $100 Deposit Required - I will pay by Pay Deposit Now  with PayPal (You may use any credit card to pay as a PayPal guest): Products Pay Deposit Now  with PayPal (You may use any credit card to pay as a PayPal guest): Payer Info Pay Deposit Now  with PayPal (You may use any credit card to pay as a PayPal guest): Payer Address 
    (707) 6325589 (707) 328 9633 dharmacreeksangha@gmail.com  PO Box 68  Jenner CA 95450 United States 04-24-2017 05-09-2017 No       Non-Gluten  Yes No I do not need financial assistance I will send a check to PO Box 183, Joshua Tree CA 92252    76.102.176.120 
    (360) 2925077 (360 ) 2925077 carlalindquist@gmail.com  22910 90th Ave. W. Unit D404  Edmonds Washington 98026 United States 04-28-2017 05-07-2018 No       None No. Yes No Requesting Work Exchange for fee reduction I will send a check to PO Box 183, Joshua Tree CA 92252    173.52.249.189 
    (530) 6478262  shanfofannan@gmail.com  130 Terry Loop  Watsonville CA 95076 United States 04-26-2017 05-08-2017         I am requesting to be the Supper Cook, per instructions from Satima. No No Requesting Full Scholarship: Willing to cook breakfast or light supper (soup+) daily I will send a check to PO Box 183, Joshua Tree CA 92252    108.199.97.36 
    (707) 391-4745 (707) 391-4745 tisha888@gmail.com  PO Box 1386  Ukiah CA 95482 United States 04-30-2017 05-07-2017 No       Non-Gluten  Yes No I do not need financial assistance Pay by credit card    70.36.224.178 
    (626) 817-9247 (818) 822-9936 lmcasserly@gmail.com  3769 n. hollingsworth rd  altadena ca 91001 United States 04-28-1917 05-05-1917 No        "Yes, I have insomnia and get up during the night
    several times. So I would like to request a private
    room.  Thank you." No No I do not need financial assistance Pay by credit card    138.229.220.231 
    (510) 9081098 (510) 9081098 laprimeralissa@gmail.com 848 Cleveland St. #A  Oakland CA 94606 United States 04-28-2017 05-07-2017            Requesting Full Scholarship: Willing to cook breakfast or light supper (soup+) daily Pay by credit card    76.218.70.83 364461090380931187 Edit Submission
    (77272) 4860510 (772) 4860510 djprov@bellsouth.net 3421 SW Canoe Creek Terrace  Palm City Fl 34990 United States 04-26-2017 05-09-2017 Yes AA fl 2260 04-26-2017 7:00 PM AA fl2587 05-09-2017 11:20 AM Non-Gluten Samadhi House please. Room #1. Can I please get the first room on the left when you enter the living room area. I like the light. Thank you. Yes No I do not need financial assistance Pay by credit card    66.176.132.53 364481104352243597 Edit Submission
    (510) 4991492 (510) 4991492 leewpurser@hotmail.com 610 Mt. Oak Ave  St Petersburg FL 33702 United States 03-28-2017 04-07-2017         I will need a chair in the meditation hall...have a sever stenosis. I'm 71 and would prefer a single, but understand completely if one is not available. My meditation practice of many years helps me with this! No No I do not need financial assistance Pay by credit card    173.171.206.126 364798710621196167 Edit Submission
    (6198201418) 6198201418  camistylist@gmail.com 9785 Mesa Springs Way #71 San Diego CA 92125 United States 04-30-2017 05-03-2017 No         No Yes Requesting Work Exchange for fee reduction Pay by credit card    76.176.215.186 365175943681965608 Edit Submission
    (347) 2991205 (347) 2991205 laurielazerbeam@gmail.com 457 Haight Street  SAn Francisco CA 94117 United States 03-26-2017 05-09-2017 Yes Alaska , 04-26-2017 6:30 PM Alaska 05-09-2017 5:20 PM  if possible solo or curtain. Yes No I do not need financial assistance I will send a check to PO Box 183, Joshua Tree CA 92252    73.223.196.82 365184315286428043 Edit Submission
    (773) 9553004 (312) 3204318 gokl@sbcglobal.net 5838 S. Stony Island Ave., #15E  Chicago IL 60637 United States 04-28-2017 05-07-2017 No         No Yes I do not need financial assistance Pay by credit card    107.210.252.95 365252125592612266 Edit Submission
    (7773739553004) 9553004 (312) 3204318 gokl@sbcglobal.net 5838 S. Stony Island Ave., #15E  Chicago IL 60637 United States 04-28-2017 05-07-2017 No         No Yes I do not need financial assistance Pay by credit card    107.210.252.95 365338625592654379 Edit Submission
    (8201418) 619  camillemarieh@gmail.com 9785 Mesa Springs Way #71 San Diego CA 92126 United States 04-30-2017 05-06-2017 No         No Yes Requesting Work Exchange for fee reduction Pay by credit card    107.77.231.114 365504405411922847 Edit Submission
    (503) 8942652 (503) 8942652 rpatchett66@gmail.com 316 Jordan Ave  Ventura CA 93001 United States 04-28-2017 05-07-2017 No         No No "Requesting Work Exchange for fee reduction
    Requesting Full Scholarship: Willing to cook breakfast or light supper (soup+) daily" I will send a check to PO Box 183, Joshua Tree CA 92252    70.197.64.57 366127012754501594 Edit Submission
    2017-03-31 0:44:43 2017-03-31 0:44:43 2017-03-31 0:44:43 2017-03-31 0:44:43 2017-03-31 0:44:43 2017-03-31 0:44:43 2017-03-31 0:44:43 2017-03-31 0:44:43 92223 United States  04-30-2017 03-05-2017          Yes No      
    2017-03-31 19:16:30 2017-03-31 19:16:30 2017-03-31 19:16:30 2017-03-31 19:16:30 2017-03-31 19:16:30 2017-03-31 19:16:30 2017-03-31 19:16:30 2017-03-31 19:16:30 90041 United States  05-03-2017 05-07-2017 No        I would like to share a room with Patricia Regan, preferably in Samadhi House, as we both have health issues and this makes the retreat easier for both of us. We will drive to DD together and be there for the same days. Thanks! Yes No      
    2017-04-01 17:14:07 2017-04-01 17:14:07 2017-04-01 17:14:07 2017-04-01 17:14:07 2017-04-01 17:14:07 2017-04-01 17:14:07 2017-04-01 17:14:07 2017-04-01 17:14:07 94110 United States  04-29-2017 05-05-2017 Yes American 04-29-2017 5:50 PM Alaska airlines 05-05-2017 5:20 PM No nightshades No Yes No      
    2017-04-03 23:03:18 2017-04-03 23:03:18 2017-04-03 23:03:18 2017-04-03 23:03:18 2017-04-03 23:03:18 2017-04-03 23:03:18 2017-04-03 23:03:18 2017-04-03 23:03:18 91208 United States  04-28-2017 05-07-2017 No        No No Yes      
    2017-04-07 21:56:08 2017-04-07 21:56:08 2017-04-07 21:56:08 2017-04-07 21:56:08 2017-04-07 21:56:08 2017-04-07 21:56:08 2017-04-07 21:56:08 2017-04-07 21:56:08 95448 United States  04-28-2017 05-05-2017 No         No Yes      
    2017-04-11 12:22:51 2017-04-11 12:22:51 2017-04-11 12:22:51 2017-04-11 12:22:51 2017-04-11 12:22:51 2017-04-11 12:22:51 2017-04-11 12:22:51 2017-04-11 12:22:51 91360 United States  04-28-2017 05-03-2017 No        No No No      
                                 
                                 

     
  • BJoanna
    Replied on April 12, 2017 at 3:27 AM

    I saw that on your other thread https://www.jotform.com/answers/1117174, you mentioned that you were able to find submissions on your JotForm account and that now you only have issues with your Google Spreadsheet integration. 

    If I understood you correctly you have modified your spreadsheet. Please note that this can break integration and it is not recommended. I would suggest you to re-integrate your form with Google Spreadsheet. Remove current integration and integrate your form again with Google Spreadsheet.

    How to Integrate Form with Google Spreadsheet

    If you need to add some additional data to your spreadsheet, I would suggest you to create another spreadsheet add pass data from original spreadsheet to new spreadsheet, using the ImportRange

    Then you can modify new spreadsheet.

    Hope this will help. Let us know if you need further assistance.