Hello. Great video. I would like to know if it is possible to have multiple GOOGLE FORMS populate data on 1 Google Sheet. I would like to have the first Google Form be completed and populate data in the first 4 columns and then GOOGLE FORM# 2 would populate the last 4 columns. This way I can make my GOOGLE DOC a 2 PART questionairre form that will add all the data to the same Google SHEET. Thanks..
I don't believe there's a way to get the URL of the page you're embedding your google form. However, I think you could do a workaround if you don't mind having something displayed to the user. Since you're embedding the url on a page, you should be able to pass through a url in the embedded source using a pre-filled URL where the webpage url is one of the parameters.
Hi, Thanks for the video! Is it possible for me to pass a variable from another site into this function? I want to pass a username from a site into the survey results without the user seeing.
HMMMMM Interesting question. You might be able to do that by using a pre-filled URL and have a script bound to that Google Form that pulls the url parameters out to use on the form submission. Another way would be to have something on the form (e.g. email) that makes a request to the other site (assuming you have an API of sorts) which can pull up the other data you want -- or you can set up a separate mapper somewhere that links an identifier from the google form to a bunch of meta data.
i want to have form with job code number (random) created post submit in back ground and using that job code to open the prelink form so that I can update the form of same job code. I don't want to show the job code in the form since i can not hide it. Whats is the best solution
Hi Pooja, thanks for reaching out! Just to make sure I understand the scenario you've outlined - are you saying that you have a separate system which generates a job code number to use in a google form? The hidden fields you can add to a google form without it being shown are values that can be handled after the initial form submission. If you can generate the job code after the initial form submission, then that is what I would suggest. However, if you're trying to use the google form as a UI to update an existing record somewhere, I would suggest using something other than a google form for that.
Yeah, that should be possible. When you get the Event Object back from the On Form Submit trigger, it'll come with a Range object. using that Range Object, you can call .getSheet() to see which sheet the form submission occurred on and then use that in your logic to make sure you're applying the default fields to the correct sheet.
I'm just slightly confused on the title here. This process is adding custom column values to Google Sheets based on Google Form submissions. But not really adding hidden field elements onto the Google Form, correct?
I send a link to google forms in telegram (this is done by google script). To do this, I use their telegram id in the script. Any idea how to save their id after filling out the form? Thank you
That's a tough one.. Google Forms makes it difficult to pull custom data from the user.. you could use a pre-filled question for the telegram_id and have it come through the response data. The only concern with that is that the user would see that question and would have the ability to edit it if they wanted (I don't think most folks would do that though) If you already have a mapping between the telegram_id and the user's email, you could set your form to collect email addresses and then fill in the telegram_id for each form response.
Hey, how do i get url's pre-filled data instead of the constant 'new' value?
Hello. Great video. I would like to know if it is possible to have multiple GOOGLE FORMS populate data on 1 Google Sheet. I would like to have the first Google Form be completed and populate data in the first 4 columns and then GOOGLE FORM# 2 would populate the last 4 columns. This way I can make my GOOGLE DOC a 2 PART questionairre form that will add all the data to the same Google SHEET. Thanks..
Thank you! It works great!
Glad it helped!
Very nice and simple guide. Thanks
Glad it was helpful!
Any way to embed the Page URL of where the form was filled out? I'm using the form on many inventory pages with dynamic URLs that change...
I don't believe there's a way to get the URL of the page you're embedding your google form. However, I think you could do a workaround if you don't mind having something displayed to the user. Since you're embedding the url on a page, you should be able to pass through a url in the embedded source using a pre-filled URL where the webpage url is one of the parameters.
Hi, Thanks for the video! Is it possible for me to pass a variable from another site into this function? I want to pass a username from a site into the survey results without the user seeing.
HMMMMM Interesting question. You might be able to do that by using a pre-filled URL and have a script bound to that Google Form that pulls the url parameters out to use on the form submission. Another way would be to have something on the form (e.g. email) that makes a request to the other site (assuming you have an API of sorts) which can pull up the other data you want -- or you can set up a separate mapper somewhere that links an identifier from the google form to a bunch of meta data.
i want to have form with job code number (random) created post submit in back ground and using that job code to open the prelink form so that I can update the form of same job code. I don't want to show the job code in the form since i can not hide it. Whats is the best solution
Hi Pooja, thanks for reaching out!
Just to make sure I understand the scenario you've outlined - are you saying that you have a separate system which generates a job code number to use in a google form? The hidden fields you can add to a google form without it being shown are values that can be handled after the initial form submission. If you can generate the job code after the initial form submission, then that is what I would suggest.
However, if you're trying to use the google form as a UI to update an existing record somewhere, I would suggest using something other than a google form for that.
How can you make this work for multiple forms that go to different sheets within a file?
Yeah, that should be possible. When you get the Event Object back from the On Form Submit trigger, it'll come with a Range object. using that Range Object, you can call .getSheet() to see which sheet the form submission occurred on and then use that in your logic to make sure you're applying the default fields to the correct sheet.
I'm just slightly confused on the title here. This process is adding custom column values to Google Sheets based on Google Form submissions. But not really adding hidden field elements onto the Google Form, correct?
I send a link to google forms in telegram (this is done by google script). To do this, I use their telegram id in the script. Any idea how to save their id after filling out the form? Thank you
That's a tough one.. Google Forms makes it difficult to pull custom data from the user.. you could use a pre-filled question for the telegram_id and have it come through the response data. The only concern with that is that the user would see that question and would have the ability to edit it if they wanted (I don't think most folks would do that though)
If you already have a mapping between the telegram_id and the user's email, you could set your form to collect email addresses and then fill in the telegram_id for each form response.
I am not seeing from spreadsheet in the trigger options
Make sure your script is a container bound script project.