Automatic redirect for a Google Form cascade2019 Community Moderator ElectionGoogle spreadsheet script function callHow does google know which onsubmit trigger to execute when a form is submitted if you have multiple forms sending responses to a single spreadsheetValidating a Google Apps Form with JavascriptUpload files to Google Drive from a Google FormAutomatically delete temporary files in Google Drive submitted by Google FormGoogle script to automatically add predetermined file paths to Google form responseHow to automatically authenticate Google Drive through Docusign APIAutomatic Google Sheets Back Up without Copying the Forms attached to the SheetsGet url of the google form every time after submission is done
What do *foreign films* mean for an American?
Are all players supposed to be able to see each others' character sheets?
How exactly does an Ethernet collision happen in the cable, since nodes use different circuits for Tx and Rx?
Street obstacles in New Zealand
Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?
Giving a career talk in my old university, how prominently should I tell students my salary?
PTIJ: Why does only a Shor Tam ask at the Seder, and not a Shor Mu'ad?
Signed and unsigned numbers
How can I manipulate the output of Information?
Can't make sense of a paragraph from Lovecraft
Is it a Cyclops number? "Nobody" knows!
Are small insurances worth it?
Should I take out a loan for a friend to invest on my behalf?
Does Christianity allow for believing on someone else's behalf?
Can the alpha, lambda values of a glmnet object output determine whether ridge or Lasso?
What materials can be used to make a humanoid skin warm?
What ability score modifier does a javelin's damage use?
How do we create new idioms and use them in a novel?
Trig Subsitution When There's No Square Root
Is it possible to avoid unpacking when merging Association?
Is it possible that a question has only two answers?
Is this Paypal Github SDK reference really a dangerous site?
MySQL importing CSV files really slow
Outlet with 3 sets of wires
Automatic redirect for a Google Form cascade
2019 Community Moderator ElectionGoogle spreadsheet script function callHow does google know which onsubmit trigger to execute when a form is submitted if you have multiple forms sending responses to a single spreadsheetValidating a Google Apps Form with JavascriptUpload files to Google Drive from a Google FormAutomatically delete temporary files in Google Drive submitted by Google FormGoogle script to automatically add predetermined file paths to Google form responseHow to automatically authenticate Google Drive through Docusign APIAutomatic Google Sheets Back Up without Copying the Forms attached to the SheetsGet url of the google form every time after submission is done
A Google Form lets pick the title of a Google Document, among many, and select a branch. Once this form is filled, a GAS script, triggered on response submit, creates a 2nd form with the list of people (i.e. folder' names) of the selected branch (which is a Drive folder itself with as many childs as people in the branch).
By 2nd form, a person is choiced and, triggered on form submit, a script duplicates, renames and deposits a copy of the document (picked in the 1st form) into the Drive folder of the selected person.
The only solution my goodwill found (and it works) is to send the link/URL of the 2nd form by e-mail, using the confirmation message (link/URL is always the same, since the 2nd form is modified by "set" methods).
But I suspect it is not so smart and more can be automatically done, but I am very newby and did not find herein a solution.
My dream: I would like to automatically redirect users to the 2nd form URL, once the 1st form is submitted and the script which creates the 2nd form is over.
forms google-apps-script
asked Mar 6 at 14:23
GabrieleGabriele
11
add a comment |
A Google Form lets pick the title of a Google Document, among many, and select a branch. Once this form is filled, a GAS script, triggered on response submit, creates a 2nd form with the list of people (i.e. folder' names) of the selected branch (which is a Drive folder itself with as many childs as people in the branch).
By 2nd form, a person is choiced and, triggered on form submit, a script duplicates, renames and deposits a copy of the document (picked in the 1st form) into the Drive folder of the selected person.
The only solution my goodwill found (and it works) is to send the link/URL of the 2nd form by e-mail, using the confirmation message (link/URL is always the same, since the 2nd form is modified by "set" methods).
But I suspect it is not so smart and more can be automatically done, but I am very newby and did not find herein a solution.
My dream: I would like to automatically redirect users to the 2nd form URL, once the 1st form is submitted and the script which creates the 2nd form is over.
forms google-apps-script
asked Mar 6 at 14:23
GabrieleGabriele
11
And Many Thanks.
– Gabriele
Mar 6 at 14:30
add a comment |
A Google Form lets pick the title of a Google Document, among many, and select a branch. Once this form is filled, a GAS script, triggered on response submit, creates a 2nd form with the list of people (i.e. folder' names) of the selected branch (which is a Drive folder itself with as many childs as people in the branch).
By 2nd form, a person is choiced and, triggered on form submit, a script duplicates, renames and deposits a copy of the document (picked in the 1st form) into the Drive folder of the selected person.
The only solution my goodwill found (and it works) is to send the link/URL of the 2nd form by e-mail, using the confirmation message (link/URL is always the same, since the 2nd form is modified by "set" methods).
But I suspect it is not so smart and more can be automatically done, but I am very newby and did not find herein a solution.
My dream: I would like to automatically redirect users to the 2nd form URL, once the 1st form is submitted and the script which creates the 2nd form is over.
forms google-apps-script
asked Mar 6 at 14:23
GabrieleGabriele
11
A Google Form lets pick the title of a Google Document, among many, and select a branch. Once this form is filled, a GAS script, triggered on response submit, creates a 2nd form with the list of people (i.e. folder' names) of the selected branch (which is a Drive folder itself with as many childs as people in the branch).
By 2nd form, a person is choiced and, triggered on form submit, a script duplicates, renames and deposits a copy of the document (picked in the 1st form) into the Drive folder of the selected person.
The only solution my goodwill found (and it works) is to send the link/URL of the 2nd form by e-mail, using the confirmation message (link/URL is always the same, since the 2nd form is modified by "set" methods).
But I suspect it is not so smart and more can be automatically done, but I am very newby and did not find herein a solution.
My dream: I would like to automatically redirect users to the 2nd form URL, once the 1st form is submitted and the script which creates the 2nd form is over.
forms google-apps-script
forms google-apps-script
asked Mar 6 at 14:23
GabrieleGabriele
11
asked Mar 6 at 14:23
GabrieleGabriele
11
edited Mar 7 at 8:20
Gabriele
asked Mar 6 at 14:23
GabrieleGabriele
11
asked Mar 6 at 14:23
GabrieleGabriele
11
asked Mar 6 at 14:23
GabrieleGabriele
11
11
And Many Thanks.
– Gabriele
Mar 6 at 14:30
add a comment |
And Many Thanks.
– Gabriele
Mar 6 at 14:30
And Many Thanks.
– Gabriele
Mar 6 at 14:30
And Many Thanks.
– Gabriele
Mar 6 at 14:30
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
);
);
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%2f55025354%2fautomatic-redirect-for-a-google-form-cascade%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
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.
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%2f55025354%2fautomatic-redirect-for-a-google-form-cascade%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
And Many Thanks.
– Gabriele
Mar 6 at 14:30