- dansilver1005Asked 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?
- JotForm Supportashwin_dAnswered on May 29, 2017 at 11:23 AM
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.
- dansilver1005Answered on May 29, 2017 at 01:43 PMSo 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?
Sent from my iPhone
Please excuse any spelling errors, grammatical errors or other typographical mistakes. :)
- JotForm SupportKevin_GAnswered 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.