Integration also allows us to export the data directly to our database, which makes it easier for the data to be processed down the line. What are the benefits of integrating JotForm and Google Sheets?īy integrating JotForm and Google Sheets, we can easily create surveys and cplect data from our customers, who will then be able to view the data in their own Google spreadsheets.It offers online cplaboration tops so that multiple people can work on the same spreadsheet at the same time. Google Sheets is an online spreadsheet application made by Google. The cplected data can then be easily exported to Google Sheets. These forms can be used to cplect data from customers through email, phone, SMS, or by direct entry on the website. JotForm won’t let me select the Drive subfolder when creating a new form, so that didn’t pan out.JotForm is a web-based form builder that helps users create and embed forms on their website. My next attempt was to get each JotForm to create a new spreadsheet in a specific folder then try to pull it into a master spreadsheet that could then be pulled into Coda.
I don’t think you can push directly to Coda in any way…?).
It’d be too much to have her setup each form to be pushed through Zapier/Integromat to the common Coda table (since there isn’t a direct Coda to JotForm integration. It’s a pretty simple setup for my colleague who will be responsible for replicating the JotForm template. Master sheet/tab hasn’tt worked out but I’m contacting Zapier to see if they have any suggestions.Īs far as I can tell, my only option is to get the Google Sheet option to work. My adventures in trying to get all the auto-generated sheets to push to one I started experimenting and was able to push my Google Sheet rows to a Coda table.
Hello! Sorry it took me a few days to get back to this. I’ll take a look and see if Zapier or Integromat can watch a folder and upload new sheets from there into a Coda table. I can’t ask them to get the data connections working when they’re adding 10+ forms in one form creation spree. I need to limit how much work my colleagues who are making the forms need to do (they’re replicating a template with a few individual updates to each one). Or make a separate Google Sheet for each form and then connect that over to the next tool (e.g. A lot of the tools I’ve seen need you to set up a whole process for each sheet in a bigger Google Sheet (or JotForm). The “max number of…” is just so I can get those numbers into my dashboard so I can make calculations like X number of seats remain.Īs far as I can tell, the real trouble is making sure all sheets’ content gets sent directly to Coda. Hello! Yes, the columns of data I’m pulling is the same for each form (event date, online registrations, max number of online seats, in-person registrations, max number of in-person seats).
0 kommentar(er)
