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

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

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!

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. :)
...

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