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

  • Ginta
    Asked on August 9, 2018 at 3: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

  • Ashwin JotForm Support
    Replied on August 9, 2018 at 5: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.

  • Ahad Rajput
    Replied on August 12, 2018 at 3: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!

  • Victoria_K
    Replied on August 12, 2018 at 4: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.

  • Ahad Rajput
    Replied on August 13, 2018 at 2: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?

  • Adrian
    Replied on August 13, 2018 at 3: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.