How can I have the product options in my forms pull from either QuickBooks or Google Sheets?

  • Profile Image
    dansilver1005
    Asked on May 29, 2017 at 10:23 AM

    I have all of my products and pricing in QuickBooks and in a Google Sheets. Instead of having to manually add them to my order form, I'd like for the order form to connect with either Google Sheets or QuickBooks, so the information automatically pulls in as I update it. Otherwise, I will have to update the same info in multiple places.

     

    How can I accomplish this?

     

    Thanks!

     

    Dan

  • Profile Image
    ashwin_d
    Answered on May 29, 2017 at 11:23 AM

    Hello Dan,

    Unfortunately it is currently not possible to populate the product data from any external source or previous submission data. 

    The only option is to manually add products and prices.

    Thank you!

  • Profile Image
    dansilver1005
    Answered on May 29, 2017 at 01:43 PM
    So all integrations are only one way? In other words, form data can be pushed into google sheets but data in sheets can't be used to populate fields?
    Is there a third party solution like zapier or Piesync that can bridge the two for 2 way integration?
    Or can I upload a csv file at least to populate the fields?
    Thanks!
    Dan
    Sent from my iPhone
    Please excuse any spelling errors, grammatical errors or other typographical mistakes. :)
    ...
  • Profile Image
    Kevin_G
    Answered on May 29, 2017 at 02:28 PM

    Yes, you're correct, I have checked on Zapier and I cannot find a way to get information from Google Spreadsheet to pre-populate in a JotForm form. You cannot import products or data from external sources in a JotForm. 

    You could generate your own script to display the information from an external source, but this would require to get the source code of your form. 

    How-to-get-the-Full-Source-Code-of-your-Form