-
luxuryhomemagazinedcAsked on April 9, 2014 at 5:48 PM
-
Elton Support Team LeadReplied on April 9, 2014 at 6:32 PM
Hi,
That's not possible with the integration as of the moment.
The workaround is to import submissions from different google spreadsheets into a single spreadsheet using importRange function.
Here's how:
https://support.google.com/drive/answer/3093340?hl=en
Example:
Formula
IMPORTRANGE("0AgxqsUM6gnFjdDQ2OGV2U0ZUbTI3S3FfUEdfVWpnaFE", "Submissions!A1:C10")
0AgxqsUM6gnFjdDQ2OGV2U0ZUbTI3S3FfUEdfVWpnaFE - is the spreadsheet key taken from the source spreadsheet URL after key=, example:
https://docs.google.com/spreadsheet/ccc?key=0AgxqsUM6gnFjdDQ2OGV2U0ZUbTI3S3FfUEdfVWpnaFE&usp=drive_web
Video:
Hope this helps!