How to integrate multiple forms into a single Google Spreadsheet?

Merging two Google Sheets

Hi,

I have two Jotforms collecting related by different pieces of information. Sheet 1 is collecting the details of calls coming in and sheet 2 is collecting the updates or resolutions to those calls. I've gone down this route as never worked out how to retrieve the original call details into a form so the user can update or close the call.

I have the output of these two forms going into 2 separate google sheets (being that you can't feed a form's info into a tab of an existing spreadsheet).

I now want to report across those two sheets but can't find a simple way how. IMPORTRANGE is good but doesn't auto refresh unless I manually update a cell on the sheet. VLOOKUP doesn't work across two sheets, works fine in two excels but not in two sheets.

Any ideas anyone on how to solve this?

In Summary:-

Form 1 (Helpdesk Call Logs) is integrated into Google sheets into sheet called Helpdesk Call Logs.

Form 2 (Helpdesk Call Updates) is integrated into Google sheets into sheet called Helpdesk Call Status.

Either I want a better way of collecting the output from the above 2 forms into one location or I want a way of combining the data from the two Google sheets.

Thanks,

Mark.

Hi Mark,

Unfortunately, it's not possible right now to have two forms to update one Google spreadsheet. Although, you are right that you can do this by using the importrange function, you can also check about it here: https://support.google.com/docs/answer/3093340?rd=1. 

If you are looking to merge/combine submissions, you can try the following suggestions:

1. Combine Submissions App: You can take advantage of this app which will allow you to combine the submissions of multiple forms in one csv file. Please take a look at the following URL :  http://apps.jotform.com/app/combine_submissions

2. Report: You can create HTML Table listing or grid listing report. You can open these reports and copy the submission records to manually merge them. The following guides should help you create reports:

http://www.jotform.com/help/209-How-to-create-an-HTML-Table-Listing-Report

http://www.jotform.com/help/105-How-to-create-a-Grid-Listing-report

These are the options that I found out. There is no automated way to merge the submission records right now.

I hope this gives you an idea.

Thank you.

Thanks for the response. Unfortunately, none of these work for me.

The IMPORTRANGE function works but doesn't automatically update when receiving a submission, it only updates if you manually change or manually update a field in the spreadsheet.

The Combine Submissions App only works if you manually run it and even then, put's all the date in a not very user friendly way. But the main problem here is I want a report to be automatically updated upon a new submission coming through.

Likewise, the HTML method is all very manual so not appropriate.

If I could just find out why the IMPORTRANGE doesn't update on it's own, it would solve my problem. Would be good if at some point, Jotform also provided the functionality to feed into a tab into an existing spreadsheet. It's a great service in general.

Mark.

Hi Mark,

Thanks for the update. I tried it on my end and I think I see what you were mentioning. The master sheet or the form that uses import seems to not update the cell when an actual filling out of the cell on the origin form has not been made.

I'll try looking for a work around on this, although this is more of a functionality of the Google Spreadsheet rather than JotForm, but I'll let you need if I come up with a working resolution later this day.

Thank you.

Hi,

Your absolutely right, the fact that IMPORTRANGE doesn't work very well is wholly a Google thing, not Jotform. I just hoped that as Jotform cannot feed two forms into one sheet or into two tabs into the one sheet, then others may have used the IMPORTRANGE workaround and found a way of getting it to work effectively.

Kind regards,

Mark.

You can try workarounds from the following http://webapps.stackexchange.com thread:

How do I get linked Google spreadsheets to auto-update when 'I am not looking'

Alternatively to our Google Spreadsheets integration, it might be possible to use Zapier integration on forms to update a single Google Spreadsheet from different forms.

Thank you.

what if we create many forms with their own SS response pages. Now we can attach a simple Google Script to each of them. The code will execute another script that is in our main SS. Now the tricky part is, the script can also tell the main script - from what form to borrow the response (simply transfer the name of the subform into a string that look from where to read the information). I am a noob, so I want to implement this myself I just need to know how to run a script from another script. I think it's possible since script can simply sits on Google Drive by itself.

Hi ruslan,

Thanks for sharing your inputs here. I'm not that familiar with scripts on Google Drive, unless you are referring to running functions and scripts on Google Spreadsheet, that one is possible where you can import multiple spreadsheets to your main spreadsheet with scripts. Although, I'm not that familiar with Spreadsheet scripts but you can find more about it here: Google Spreadsheet Functions and App scripts.

We would also like to advise that you open your own thread here in the forum when you hare questions or concerns so that we can better assist you.

Kind regards.