How to link spreadsheets with Google Script Editor?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
0
I'm trying to link two different spreadsheets - by that, I mean to different Google Spreadsheet files with each other. I want to be able to get data from one spreadsheet and do different functions in another. I already know how to share data between sheets, just not spreadsheets. Would love some help on this. Here's my code below:
var app = SpreadsheetApp; // creates application
var r_volunteers = app.getActiveSpreadsheet().getActiveSheet(); // creates spreadsheet, then gets active sheet named "raw_values"
var housing_roster = app.getActiveSpreadsheet().getSheetByName("housing_roster"); // creates variable for housing roster sheet
var totalOfVolunteers = r_volunteers.getLastRow() - 1; // -1 due to row of headers
var sorting_range = r_volunteers.getRange(2, 2, totalOfVolunteers, 12); // declares sorting range, which is all form responses
function onFormSubmit()
/*** SIGNATURES ***/
var signature = Math.random().toString(36).substr(2, 9); // random string for signature
r_volunteers.getRange(totalOfVolunteers + 1, 2).setValue(signature); // assigns signature as text
r_volunteers.sort(6); // sorts all responses by hall (a-z)
I would love some help on this. I couldn't seem to find anything in the Google Script overview. Thanks in advance!
javascript function google-apps-script google-sheets
edited Nov 13 '18 at 23:13
Tanaike
24.1k21327
asked Nov 13 '18 at 21:03
rowlandevrowlandev
84
add a comment |
0
I'm trying to link two different spreadsheets - by that, I mean to different Google Spreadsheet files with each other. I want to be able to get data from one spreadsheet and do different functions in another. I already know how to share data between sheets, just not spreadsheets. Would love some help on this. Here's my code below:
var app = SpreadsheetApp; // creates application
var r_volunteers = app.getActiveSpreadsheet().getActiveSheet(); // creates spreadsheet, then gets active sheet named "raw_values"
var housing_roster = app.getActiveSpreadsheet().getSheetByName("housing_roster"); // creates variable for housing roster sheet
var totalOfVolunteers = r_volunteers.getLastRow() - 1; // -1 due to row of headers
var sorting_range = r_volunteers.getRange(2, 2, totalOfVolunteers, 12); // declares sorting range, which is all form responses
function onFormSubmit()
/*** SIGNATURES ***/
var signature = Math.random().toString(36).substr(2, 9); // random string for signature
r_volunteers.getRange(totalOfVolunteers + 1, 2).setValue(signature); // assigns signature as text
r_volunteers.sort(6); // sorts all responses by hall (a-z)
I would love some help on this. I couldn't seem to find anything in the Google Script overview. Thanks in advance!
javascript function google-apps-script google-sheets
edited Nov 13 '18 at 23:13
Tanaike
24.1k21327
asked Nov 13 '18 at 21:03
rowlandevrowlandev
84
I'm sorry for my poor English skill. Can I ask you about your question? 1. Can you provide the detail flow of what you want to do? 2. What is the difference between your script in your question andI want to be able to get data from one spreadsheet and do different functions in another.? 3. What is the issue of your current script?
– Tanaike
Nov 13 '18 at 23:11
1
SpreadsheetApp.openById()?
– TheMaster
Nov 14 '18 at 0:27
my current script works - I just need to know the code to work with multiple spreadsheets instead of just sheets.
– rowlandev
Nov 14 '18 at 16:38
add a comment |
0
0
0
I'm trying to link two different spreadsheets - by that, I mean to different Google Spreadsheet files with each other. I want to be able to get data from one spreadsheet and do different functions in another. I already know how to share data between sheets, just not spreadsheets. Would love some help on this. Here's my code below:
var app = SpreadsheetApp; // creates application
var r_volunteers = app.getActiveSpreadsheet().getActiveSheet(); // creates spreadsheet, then gets active sheet named "raw_values"
var housing_roster = app.getActiveSpreadsheet().getSheetByName("housing_roster"); // creates variable for housing roster sheet
var totalOfVolunteers = r_volunteers.getLastRow() - 1; // -1 due to row of headers
var sorting_range = r_volunteers.getRange(2, 2, totalOfVolunteers, 12); // declares sorting range, which is all form responses
function onFormSubmit()
/*** SIGNATURES ***/
var signature = Math.random().toString(36).substr(2, 9); // random string for signature
r_volunteers.getRange(totalOfVolunteers + 1, 2).setValue(signature); // assigns signature as text
r_volunteers.sort(6); // sorts all responses by hall (a-z)
I would love some help on this. I couldn't seem to find anything in the Google Script overview. Thanks in advance!
javascript function google-apps-script google-sheets
edited Nov 13 '18 at 23:13
Tanaike
24.1k21327
asked Nov 13 '18 at 21:03
rowlandevrowlandev
84
I'm trying to link two different spreadsheets - by that, I mean to different Google Spreadsheet files with each other. I want to be able to get data from one spreadsheet and do different functions in another. I already know how to share data between sheets, just not spreadsheets. Would love some help on this. Here's my code below:
var app = SpreadsheetApp; // creates application
var r_volunteers = app.getActiveSpreadsheet().getActiveSheet(); // creates spreadsheet, then gets active sheet named "raw_values"
var housing_roster = app.getActiveSpreadsheet().getSheetByName("housing_roster"); // creates variable for housing roster sheet
var totalOfVolunteers = r_volunteers.getLastRow() - 1; // -1 due to row of headers
var sorting_range = r_volunteers.getRange(2, 2, totalOfVolunteers, 12); // declares sorting range, which is all form responses
function onFormSubmit()
/*** SIGNATURES ***/
var signature = Math.random().toString(36).substr(2, 9); // random string for signature
r_volunteers.getRange(totalOfVolunteers + 1, 2).setValue(signature); // assigns signature as text
r_volunteers.sort(6); // sorts all responses by hall (a-z)
I would love some help on this. I couldn't seem to find anything in the Google Script overview. Thanks in advance!
javascript function google-apps-script google-sheets
javascript function google-apps-script google-sheets
edited Nov 13 '18 at 23:13
Tanaike
24.1k21327
asked Nov 13 '18 at 21:03
rowlandevrowlandev
84
edited Nov 13 '18 at 23:13
Tanaike
24.1k21327
asked Nov 13 '18 at 21:03
rowlandevrowlandev
84
edited Nov 13 '18 at 23:13
Tanaike
24.1k21327
edited Nov 13 '18 at 23:13
Tanaike
24.1k21327
edited Nov 13 '18 at 23:13
Tanaike
24.1k21327
24.1k21327
asked Nov 13 '18 at 21:03
rowlandevrowlandev
84
asked Nov 13 '18 at 21:03
rowlandevrowlandev
84
asked Nov 13 '18 at 21:03
rowlandevrowlandev
84
84
I'm sorry for my poor English skill. Can I ask you about your question? 1. Can you provide the detail flow of what you want to do? 2. What is the difference between your script in your question andI want to be able to get data from one spreadsheet and do different functions in another.? 3. What is the issue of your current script?
– Tanaike
Nov 13 '18 at 23:11
1
SpreadsheetApp.openById()?
– TheMaster
Nov 14 '18 at 0:27
my current script works - I just need to know the code to work with multiple spreadsheets instead of just sheets.
– rowlandev
Nov 14 '18 at 16:38
add a comment |
I'm sorry for my poor English skill. Can I ask you about your question? 1. Can you provide the detail flow of what you want to do? 2. What is the difference between your script in your question andI want to be able to get data from one spreadsheet and do different functions in another.? 3. What is the issue of your current script?
– Tanaike
Nov 13 '18 at 23:11
1
SpreadsheetApp.openById()?
– TheMaster
Nov 14 '18 at 0:27
my current script works - I just need to know the code to work with multiple spreadsheets instead of just sheets.
– rowlandev
Nov 14 '18 at 16:38
I'm sorry for my poor English skill. Can I ask you about your question? 1. Can you provide the detail flow of what you want to do? 2. What is the difference between your script in your question and
I want to be able to get data from one spreadsheet and do different functions in another.? 3. What is the issue of your current script?– Tanaike
Nov 13 '18 at 23:11
I'm sorry for my poor English skill. Can I ask you about your question? 1. Can you provide the detail flow of what you want to do? 2. What is the difference between your script in your question and
I want to be able to get data from one spreadsheet and do different functions in another.? 3. What is the issue of your current script?– Tanaike
Nov 13 '18 at 23:11
1
1
SpreadsheetApp.openById()?– TheMaster
Nov 14 '18 at 0:27
SpreadsheetApp.openById()?– TheMaster
Nov 14 '18 at 0:27
my current script works - I just need to know the code to work with multiple spreadsheets instead of just sheets.
– rowlandev
Nov 14 '18 at 16:38
my current script works - I just need to know the code to work with multiple spreadsheets instead of just sheets.
– rowlandev
Nov 14 '18 at 16:38
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53289462%2fhow-to-link-spreadsheets-with-google-script-editor%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53289462%2fhow-to-link-spreadsheets-with-google-script-editor%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I'm sorry for my poor English skill. Can I ask you about your question? 1. Can you provide the detail flow of what you want to do? 2. What is the difference between your script in your question and
I want to be able to get data from one spreadsheet and do different functions in another.? 3. What is the issue of your current script?– Tanaike
Nov 13 '18 at 23:11
1
SpreadsheetApp.openById()?– TheMaster
Nov 14 '18 at 0:27
my current script works - I just need to know the code to work with multiple spreadsheets instead of just sheets.
– rowlandev
Nov 14 '18 at 16:38