- chris peabodyAsked on April 06, 2016 at 07:44 AM
I'd like to create an online form which populates an excel spread sheet, with the responses going to specific cells within a template (not blank) spreadsheet. For example, I have a spreadsheet which I need clients to complete. They must fill the spreadsheet in beginning at line 15 without altering any other aspect of the existing spreadsheet. Can I upload a template spreadsheet which will be used for the form responses to populate and specify where each question response would populate in the sheet? Can I then have the option for the user to download the completed spreadsheet or have it emailed to them? Thanks.
- JotForm SupportWelvinAnswered on April 06, 2016 at 08:30 AM
You can possibly do this through Zapier. With Zapier, you can select what spreadsheet to populate with a data from your Jotform form, assuming that you have it on your Google Drive folders.
Here's an example of the integration through Zapier. Selecting spreadsheet and its sheet:
Then mapping the fields:
Here's the link to the specific Zap from Zapier: https://zapier.com/zapbook/google-sheets/jotform/.
Our built-in Google Spreadsheet integration won't allow you to do this.
Unfortunately, sending a download link to the user is not possible with Zapier. You mean to send users the spreadsheet of their submission, right? Individual file? If so, it's not possible. Once you select the spreadsheet, all submissions to your form will be passed to this spreadsheet.
Do let us know if you have any questions with this method.
- chris peabodyAnswered on April 06, 2016 at 10:45 AMHi Welvin,
Thanks this is really helpful. One thing I’m unclear of is the ability to customise precisely which cell from responses populate? For example I understand that column headers need to be on row 1 - if I need responses to begin to populate from row 15 is this possible?
The state51 Conspiracy
Web Facebook Twitter
17 Hereford Street, London, E2 6EX
+44 (0)20 7729 4343
- BenAnswered on April 06, 2016 at 11:49 AM
The only way to do that is for you to manually add the first 13 rows (+ 1 row holding the headers), which would mean that there are 14 rows, and the next entry would be on row 15.