-
dhammadenaAsked 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
-
BJoannaReplied 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.