After adding payment tools, submission data is not displayed in google spreadsheet.

  • Profile Image
    Ginta
    Asked on August 09, 2018 at 03:26 AM

    Hey, after adding my products on the form the submission data doesn’t fill into the google spreadsheet. If you ignore the product field, it does. I’m confused what the issue is



    This is a re-post of a comment on Google Docs Integration: Send Responses to Google Spreadsheets. Instantly.

  • Profile Image
    ashwin_d
    Answered on August 09, 2018 at 05:51 AM

    I am sorry for the trouble caused to you. Do you mean to say that the submission data of form is not being added to integrated google spreadsheet if your form has payment tool?

    With which form you are having this issue with? What is your JotForm account username or the email address you have used in your account profile? I am unable to find any details with your email address sirlonely456@gmail.com. Alternatively you can also let us know any of your form ID, form URL or webpage URL where you have embedded your form and we will trace your account.

    We will wait for your response.

  • Profile Image
    Ahad Rajput 
    Answered on August 12, 2018 at 03:44 AM

    Hey, thanks for the quick answer. Email attached to the form should be officialmysticwatch@gmail.com    

     form link : https://form.jotform.com/82191294882162

    Basically, after integrating PayPal into the form and adding my products, the the submitted data isn’t getting filled into the integrated google sheet. If you skip the product option, the data does fill though. 

    Appreciate your help and support, hope to hear back soon!

  • Profile Image
    Victoria_K
    Answered on August 12, 2018 at 04:42 AM

    Hello,

    It is not recommended to modify the sheet or form after integration is set up as this can cause integration to break.

    Could you please try re-integrating your form with a new spreadsheet?

    Previously received submissions should be automatically forwarded to new sheet as well. 

    Please let us know if the issue persists afterwards.

  • Profile Image
    Ahad Rajput  
    Answered on August 13, 2018 at 02:01 PM

    hey, thanks For the quick reply as always. 

    Ive now intergrated a new google spreadsheet to the form, but it’s still not filling the submitted data if the PayPal integration option is being used (my products). 


    Any idea how to fix that?

  • Profile Image
    Adrian
    Answered on August 13, 2018 at 03:04 PM

    If your form has a Payment field, the form submission does not get added to the submissions table until the payment is completed.

    - If the payment process is not completed, the submission will stay as Incomplete and can be found by clicking the Incomplete Payments in the Submissions Page.

    Incomplete Payment submissions do not get added to the spreadsheet.

    Help Articles: 

    How-to-View-Incomplete-Payments

    Paypal-Incomplete-Payments-FAQ

    You can manually complete the submission to add it to the submissions table and to the integrated google spreadsheet. Please note that manually completing a submission will not process any payment. It will simply move the submission to the submissions table.

    - If the payment process is completed, the submission will be synced to the integrated spreadsheet as expected.