Thanks for this video, my job requires me to submit a google form 50-60 times per day. Which have 14 entries in total. I have been doing this filling manually for the last 2 years. I am going to create this script today and I will come back to give feedback.
Thank you. Very helpful tutorial, it works perfectly well. For anyone who wants the script, here you go: function autoEntry() { var wrkBk = SpreadsheetApp.getActiveSpreadsheet(); var wrkSht= wrkBk.getSheetByName("SheetName"); var formURL = ""; var formData = ""; var question1 = ""; var question2 = ""; var question3 = ""; var question4 = ""; var question5 = ""; var question6 = ""; var question7 = ""; var question8 = ""; let noOfRows = 50;
VERY VERY THANKS TO YOU MAN! I HAVE DONE THIS CODE FOR GIVING MY ATTENDENCE IN GOOGLE FORM FOR SCHOOL. ALL THE TIME THE FORM IS CLOSED BY OUR TEACHER AND A PERTICULAR TIME OUR TEACHER OPENS IT AND TOLD US TO GIVE ATTENDENCE. I WANT TO EXCECUTE THE PROCESS ALWAYS 24/7 BUT IT DONT NEED MY COMPUTER TO BE TURNED ON AND THE PROCESS WILL STOP FOR SOME HOURS AFTER IT GOT A SUCCESSFUL SUBMITION AS MY TEACHER WILL CLOSE THE FORM AFTER SOME TIME, SO AFTERFEW HOURS IT SHOULD START AGAIN. SO, HOW TO DO THESE PLZ CAN YOU MAKE A VIDEO OR EXPLAIN?
thanks a lot @Automation Made Easy this is the only video tutorial that i found which works on multiple form section keep teaching us thank you once agin
Awesome tutorial bro, I have good experience in Excel macros, but really never before imagined this will happen in Google sheet too. this video and obviously gonna grow very fast. And Bro your teaching skills are awesome. thank you for this video. best of luck!
If anyone got "Invalid Arguments" try to check which line that contain the invalid arguments. If its pointing to the UrlFetch, put this in your script: var finalURL = formURL + formData var urlEncoded = encodeURI(finalURL) var options = { "method" : "post" }; UrlFetchApp.fetch(urlEncoded, options);
Thanks broth for your answer, I did that but now I have this error exception: request failed return code 401. Truncated server response. Do you have any Suggestion?
@@subhankhan9563 Thanks broth for your answer, I did that but now I have this error exception: request failed return code 401. Truncated server response. Do you have any Suggestion?
very helpful video sir keep posting such amazing stuff Excellent and well done What if we have dynamic UI elements which means is time field values shuffle and after every refresh name value is also change. Please help me with this problem.
It's not working with me every time I tried to rerun the script this message pops up Exception: Request failed for docs.google.com returned code 404. Truncated server response:
Hello sir, I've watched your videos on RUclips. This is in regard to google forms. I have to enter a large amount of data in the google forms. Is there a possible way to do that. I do not have access to google forms settings it is protected. Waiting for your reply, sir.
Hi Thanx for this video, its very helpful, if possible please post a video on conditional branching google forms too...im not able to automate a google form having conditional branching on it
First of all I would like to thank you for that magnificent tutorial. It is a piece of Art. Secondly, I have a question and I hope you answer me "What should be written to select multiple values in the questions with check boxes answers ?"
@@AutomationMadeEasy Thank you. It works well but I faced another issue. In order to be 100% sure of the output, I created an identical copy of the google form that I am submitting the data on and tested the method on the version I created. It was found that "Response receipts" option is enabled and I get error "There was a problem submitting your response" when using the link although that error solved when "Response receipts" option disabled. Pleas help how can I solve this issue
Hellow sir, thankyou so much for the great video but I am facing an error.... The options that you showed in radio button were single word options. My options have space inbetween, how to deal with it please reply!!!! Options which have space are not accepting replies and rest are accepting... What to do sir??
i tried an alternative way, instead of finding for name manually , press control+f, a very small search box will open at the bottom or right (depending on where your inspect console is) and search for "entry." dont miss the . at the end, you will get a list of all questions together, its in the order of questions u have in the sheet. also if u input any data in the form, the result will come in front of these numbers, im sure this will resolve any issue
i prepared all script bt when i am trying to run that script its giving me error saying ""Exception: Request failed for docs.google.com returned code 400. Truncated server response:
@@AutomationMadeEasy Thank you for ur reply nd i am sorry to bother u again now my script is running and form also receiving responses but no data is filling in form.. blank form is submitting
here if any mobile number got auto submission (eg:9923882843) but in form it showing as (9.13E+09), inspiteof declaring that variable as (var)key word,what keyword should i use for mobile number ??
Thank you for the great video. At 12:39, you have multiple options, but later in the video, all the values from the spreadsheet are shown as a single choice at 19:43. How do you upload the multiple choices into the form?
@@AutomationMadeEasy not able to find name property even after using the trick from dropdown section. I tried searching for the word "entry" also, and there is just one search which has "_sentinel". Can you please guide?
Thanks a lot 🙏 for such a awesome video. I have one another request that is How to write script for uploading photo. Because sometimes we have to upload photos.
I have one scenario where in sheet i have two columns - one is containing Id and other is containing Name . So I select ID in one field then wanted name in next field automatically and in disabled mode
nice video, but what if you dont want to submit it, like what would you do if you just wanted to fill out one form, and then you can manually check it and then submit it on your own, how would you do that?
i don't know why all the responses are null (no response with empty) tried the same as per the video please help me it helps me lot since i have to enter the question wise marks of each and every student in the google form (i have to fill the same form for 60 times)
How can I split a column with text separated by commas and automatically have it duplicate into rows. For instance: Lot #1,Lot#2, Lot#3 (I want to make each Lot into its own row while keeping or copying data in all other columns).??
Rabdom questions are genrally based on answers to previous questions so it needs to be programmed based on the different scenarios with advanced programming logic
Hi! This is nice tutorial, saved my lots of time. I have a query regarding "other:" option in multiple choice or checkbox. how to script it? we need to describe in "other" space
I am a teacher. In a question paper,there are 2 sections partA & partB. In partA,35 questions given & all questions attempted. In partB, 15 questions given only 10 questions must be answered. Therefore overall 45 questions need to be attempted. Each questions carries 4 marks hence total marks 180. Which add on should I use. Please suggest
hello, need your help to create a dependent dropdown in *google form* in 1 single section,using data or dependent dropdown menus from a google sheet. please guide me or if possible make a video on it. P.S : Don't want to use logic based section shuffle or *form ranger* or *cascade formatting*. thanks in advance
I'm unable to find the entry id. When I write something in text field and then look up to inspect I only get this : here Rahul is the text I've written Please help
@@swapnilthorat6624 If you created that form, you can get a pre fill link so generate a pre fill link and the entryid is given in that generated pre fill url.
@@AutomationMadeEasy I hate to come with an issue, but i've tried everything I know and it still seems to be occurring. I keep getting the error: TypeError: Cannot read property 'getRange' of null (The error is the line for the first info inside of the for loop. Would be line 22 for your code.) I've retyped everything, made sure the spreadsheets have the information in the correct spots, and it still happens. Any ideas? Thanks! Update: okay so when I comment out var wrkSht and change the rest to use wrkBk it works fine, I might have messed up there.
Hi, this is wonderful tutorial. I have a web page that requires multiple entries. I have the requisite data in an excel sheet. However, I do not want to submit the data in one go(after submit i dont get to edit it). There is a save draft option next to the submit button which i would like to use for trying the code before submitting. Is there a similar function from MS Excel to web pages and not just google forms.
@@AutomationMadeEasy sir i have tried like this too... Sir please check once and reply sir... You are my god... I want this project please sir... Can you please provide your mail address plz
My friend, can you try to develop the same thing to office forms? I'm trying to automate data entry to office form, but it works different, thank you for your attention.
I have an error stating [Saved Progress It looks like there's a more recent draft of your response. Update to your latest draft to pick up where you left off. ] May I know how I resolve this?
Hi. Very good explanation style. Your articulation is beyond good. Had a QQ - What is the script if I have to choose more than one option in the check boxes.
Okay. But lets say I have sports in one column and music in another column in sheets, then how do I create the script for 2 different columns which has the values belonging to the checkbox options.
Have never tried file uploads with this approach but you can use an alternate UI based approach explained in below tutorial: ruclips.net/video/7a8IofqBNo4/видео.html
Such a nice and easy to understand video. I have some other requirements like dependent dropdown from google sheets to google form with a huge data Can you help me please?
@@AutomationMadeEasy I have to prepare a google form for collection of information against some pre-filled values which are to be linked from a google sheet with drop down menu. For example : Section-1 1. Block Name (14 blocks to be linked with google sheets -drop down) 2. GP Name (240 GPs to be linked with google sheet. the concerned GPs should be shown against the Block Name- drop down) 3. School Name ( 2526 Schools to be linked with google sheet. The concerned schools should be shown against the concerned GP- drop down) Section -2 4. Enrollment (blank column, to be filled up by the concerned school HM) 5. Teacher position (blank column, to be filled up by the concerned school HM) 6. Other information as and when required If you would like , i will send a excel file to understand better
Thanks for this video, my job requires me to submit a google form 50-60 times per day. Which have 14 entries in total. I have been doing this filling manually for the last 2 years. I am going to create this script today and I will come back to give feedback.
does it work bro
Thank you. Very helpful tutorial, it works perfectly well. For anyone who wants the script, here you go:
function autoEntry() {
var wrkBk = SpreadsheetApp.getActiveSpreadsheet();
var wrkSht= wrkBk.getSheetByName("SheetName");
var formURL = "";
var formData = "";
var question1 = "";
var question2 = "";
var question3 = "";
var question4 = "";
var question5 = "";
var question6 = "";
var question7 = "";
var question8 = "";
let noOfRows = 50;
for(let i=2; i
thnx
@@AutomationMadeEasy please pin the comment so that people can find the script easily and copy it.. 😊
Fabulous! You anticipated my questions before I could ask them. Very well done. Thank you!
Happy to help!
Excellent Hacks to get the requried ids, saved me time and effort :) appreciate the video!
VERY VERY THANKS TO YOU MAN! I HAVE DONE THIS CODE FOR GIVING MY ATTENDENCE IN GOOGLE FORM FOR SCHOOL. ALL THE TIME THE FORM IS CLOSED BY OUR TEACHER AND A PERTICULAR TIME OUR TEACHER OPENS IT AND TOLD US TO GIVE ATTENDENCE. I WANT TO EXCECUTE THE PROCESS ALWAYS 24/7 BUT IT DONT NEED MY COMPUTER TO BE TURNED ON AND THE PROCESS WILL STOP FOR SOME HOURS AFTER IT GOT A SUCCESSFUL SUBMITION AS MY TEACHER WILL CLOSE THE FORM AFTER SOME TIME, SO AFTERFEW HOURS IT SHOULD START AGAIN. SO, HOW TO DO THESE PLZ CAN YOU MAKE A VIDEO OR EXPLAIN?
thanks a lot @Automation Made Easy this is the only video tutorial that i found which works on multiple form section keep teaching us thank you once agin
Glad it helped!
Fantastic video, I love this tutorial. You saved me so much time from manually filling in Google forms. Thank you!
Glad it helped!
Thank you, you inspired me to learn programming.
That's great!
Awesome tutorial bro, I have good experience in Excel macros, but really never before imagined this will happen in Google sheet too. this video and obviously gonna grow very fast. And Bro your teaching skills are awesome. thank you for this video. best of luck!
Glad you liked it
If anyone got "Invalid Arguments" try to check which line that contain the invalid arguments. If its pointing to the UrlFetch, put this in your script:
var finalURL = formURL + formData
var urlEncoded = encodeURI(finalURL)
var options = {
"method" : "post"
};
UrlFetchApp.fetch(urlEncoded, options);
I'm getting
ReferenceError: encodeURL is not defined
What can be done?
Thanks broth for your answer, I did that but now I have this error exception: request failed return code 401. Truncated server response. Do you have any Suggestion?
@@subhankhan9563 Thanks broth for your answer, I did that but now I have this error exception: request failed return code 401. Truncated server response. Do you have any Suggestion?
bro u are god of google forms. no other way was that easy as this one. chapeau bas!
thnk u
very helpful video sir
keep posting such amazing stuff
Exellent and well done
So nice of you
Great video, can you add the code to description to avoid typo..
very helpful video sir keep posting such amazing stuff Excellent and well done
What if we have dynamic UI elements which means is time field values shuffle and after every refresh name value is also change.
Please help me with this problem.
It's not working with me every time I tried to rerun the script this message pops up
Exception: Request failed for docs.google.com returned code 404. Truncated server response:
Format all data as plain text and try
Same problem
@@AutomationMadeEasy same problems
@@A7XGaming share your form url, script and google sheet
@@A7XGaming + is missing before tempatL
Format all the data as plain text and re try
👍 Awesome! The only thing that would be better is you having all the code downloadable. (hint, hint)
Hello sir,
I've watched your videos on RUclips. This is in regard to google forms. I have to enter a large amount of data in the google forms. Is there a possible way to do that.
I do not have access to google forms settings it is protected.
Waiting for your reply, sir.
i need to see the form to suggest a solution
@@AutomationMadeEasy how do I send you all the details, sir ?
After column g your formula is not working so how we work upto O column
Hi Thanx for this video, its very helpful, if possible please post a video on conditional branching google forms too...im not able to automate a google form having conditional branching on it
Thank you very much for creating this wonderful video 🙏
Glad you liked it!
it helps at minute 8:10, when I put inspect I don't get "name =" entry "
same
First of all I would like to thank you for that magnificent tutorial. It is a piece of Art.
Secondly, I have a question and I hope you answer me "What should be written to select multiple values in the questions with check boxes answers ?"
Thanks, you have to just keep appending the name property with the value:
name.654646=Reading&name.654646=Writing
@@AutomationMadeEasy Thank you. It works well but I faced another issue.
In order to be 100% sure of the output, I created an identical copy of the google form that I am submitting the data on and tested the method on the version I created.
It was found that "Response receipts" option is enabled and I get error "There was a problem submitting your response" when using the link although that error solved when "Response receipts" option disabled. Pleas help how can I solve this issue
@@gabrwy1990 show your code here, I also faced same problem, try to correct where is "pageHistory"
@@yashmayekar_MIS same happening with me - response receipts enabled so method doesn't work. Any solutions?
did you figure it out? same thing happening with me
How to write code for checkbox questions?? Like you did it for hobbies... what if someone has 2 hobbies?
Hellow sir, thankyou so much for the great video but I am facing an error.... The options that you showed in radio button were single word options. My options have space inbetween, how to deal with it please reply!!!! Options which have space are not accepting replies and rest are accepting... What to do sir??
I can't find that "name=" part in the code. 8:35
Same here
i tried an alternative way, instead of finding for name manually , press control+f, a very small search box will open at the bottom or right (depending on where your inspect console is) and search for "entry." dont miss the . at the end, you will get a list of all questions together, its in the order of questions u have in the sheet.
also if u input any data in the form, the result will come in front of these numbers, im sure this will resolve any issue
@@swarnasurya3853 refer to my reply below
@@pizzagarden1025 don't find it
Same
thank you so much . EXCELLENT TUTORIAL .
Glad you enjoyed it!
Really Really fantastic
thnx
i faced problem
Error Exception: Limit Exceeded: URLFetch URL Length.
how to solve this error
100 entries i have .
Thank you for video and also support for creating my sheet.
No problem
Hi sir Can you help me pleae?
I work this code but shows this error Exception: Request failed for returned code 404. Truncated server response:
there could be multiple reasons behind the error. Incorrect data format could be one of the reasons. Format all data as plain text and try
@@AutomationMadeEasy i did all this
can i send urls google form and sheet for you and solve it please
@@AutomationMadeEasy 👏
ok share
i prepared all script bt when i am trying to run that script its giving me error saying ""Exception: Request failed for docs.google.com returned code 400. Truncated server response:
Format all the data in the sheet as Plain text and try
@@AutomationMadeEasy Thank you for ur reply nd i am sorry to bother u again now my script is running and form also receiving responses but no data is filling in form.. blank form is submitting
Need to see ur form and code.
@@AutomationMadeEasy plz share me your email id i ll share you form and sheet .. you can charge me whatever your fee is
I fixed it, you add formurl="[your link google form]/formResponse?pageHistory=0" and done
here if any mobile number got auto submission (eg:9923882843) but in form it showing as (9.13E+09),
inspiteof declaring that variable as (var)key word,what keyword should i use for mobile number ??
Any way you can put the code in the description of the video
Hi i try this at another site and doesnt work. Is it only for Google forms? can i use it at any site with froms with a submit button?
When I paste URL i get this error: "Sorry, unable to open the file at this time."
Anyone knows why or how to fix? Thank you for the video
I need help with this also
Thank you sir !
Most welcome!
Thank you for the great video. At 12:39, you have multiple options, but later in the video, all the values from the spreadsheet are shown as a single choice at 19:43. How do you upload the multiple choices into the form?
you have just keep appending with the value which needs to be selected: name6464612=Sports&Name98879=Reading
clear explanation, thank you so much
You are welcome!
Sorry, I can't find the name="entry.xxxxxxxxx" in the inspect when i inspect the text box.. maybe google form was hidden that thing?
refer to the section where dropdown is explained. Apply same logic for text boxes. You will find name property
@@AutomationMadeEasy not able to find name property even after using the trick from dropdown section. I tried searching for the word "entry" also, and there is just one search which has "_sentinel". Can you please guide?
Thanks a lot 🙏 for such a awesome video. I have one another request that is How to write script for uploading photo. Because sometimes we have to upload photos.
not feasible using this technique but you can use alternate approach explained in below tutorial:
ruclips.net/video/g7xOwulfwK0/видео.html
I was wondering if you had any advice on finding the name property for a time entry?
Enter the time in the field (example 10:19)
and serach for 19 in the developer window you will find the name property.
Thank you very much sir
Great video, thank you so much!!!
Glad it was helpful!
Thank you so much you're a lifesaver!!
Glad it helped!
I have one scenario where in sheet i have two columns - one is containing Id and other is containing Name . So I select ID in one field then wanted name in next field automatically and in disabled mode
how to find the entry number of multiple choice, like Facebook, RUclips, TikTok and you should choice only one
Very nice tutorial
Thank you! Cheers!
Best tutorial man! Thank you =) {Subscribed}
Glad it helped!
Thank you man! Appreciate it.
Glad it helped!
nice tutorial however I have an error in UrlFetchApp.fetch(finalURL, options);
whats the error description?
Is it an open form or you need to login to access it?
Good one. Everything is clear. Just one quick question. How will the code look if select 02 options of checkbox ?
You have to just keep appending
entry.895674=Sports&entry.895674=Music
goog video small suggestion.. u can avoid noting all name id just by using pre filled link also can u share script
hello
there is a google form that opens for a limited time. is there any way to prefill that thru excel so that I can fill that form.
Hello, good vid bro.
thanks
nice video, but what if you dont want to submit it, like what would you do if you just wanted to fill out one form, and then you can manually check it and then submit it on your own, how would you do that?
not sure about that, but we could implement a number of checks before the form is submitted to ensure correct submission
How to set time through this sir..i can set AM and PM please help
Hi, Nice tutorial
but I cant find my each data entry my element is
manually input some data in the text field and search the same data in the developer window, you will find the element id
thank you brother, i have question. How about if that input type is a file ? how to do auto entry file ?
i don't know why all the responses are null (no response with empty)
tried the same as per the video
please help me
it helps me lot since i have to enter the question wise marks of each and every student in the google form (i have to fill the same form for 60 times)
got it error in last line...
UrlFetchApp.fetch(finalURL,options);
great.. hope it saves your time :)
Will it work for forms which requires email authentication?
no. only open forms
Thank you very helpful! how do we also automate file upload in the same form ?
Not possible
if the data in excel sheet has % symbol it will throw error , its not taking data from that, help me out
Form submission needs data to be in plain text format. You can put the percentage formula in the script instead of spreadsheet cell
How can I split a column with text separated by commas and automatically have it duplicate into rows. For instance: Lot #1,Lot#2, Lot#3 (I want to make each Lot into its own row while keeping or copying data in all other columns).??
How do you upload the multiple choices into the form, if the answers are of more than 3 words?
when the forms generates random questions or random slots???
please?
Rabdom questions are genrally based on answers to previous questions so it needs to be programmed based on the different scenarios with advanced programming logic
Hi! This is nice tutorial, saved my lots of time. I have a query regarding "other:" option in multiple choice or checkbox. how to script it? we need to describe in "other" space
Thanks, you have to just keep appending the name property with the value:
name.654646=Reading&name.654646=Other
@@AutomationMadeEasy I Get it , thank you, you made it too easy for non coder!!
glad you found it helpful
Hello, the codes can't recognize ">" and " 40 years" text. Can you help me explain please? Thx
Hi,
I am not able to see the entry number as it is showing "Required dir="auto" in place of "name""entry.142" in your example?
type some text in any field and search for the same in the developer window you will find the id
Thank you
You're welcome
the resulting URL is too long for URLfetch to use, and i don't know how to fix it, can you help?
I am a teacher. In a question paper,there are 2 sections partA & partB. In partA,35 questions given & all questions attempted. In partB, 15 questions given only 10 questions must be answered. Therefore overall 45 questions need to be attempted. Each questions carries 4 marks hence total marks 180. Which add on should I use. Please suggest
You are great bro!!!
thanks
@@AutomationMadeEasy Brother Can you teach me things like this? I am a working guy and I can pay you.
@@AutomationMadeEasy it's says cannot read property getrange of bull line 18
It seems Google have hide the "name" tag from the form. How can I get it back or what's the next method?. Good job
in the same tutorial refer the section where dates,dropdowns and radiobuttons are handled you will get the field id
Bro but my Google forms are not in one ascending order they are changing after one submission will it work on that also pls reply?
hello,
need your help to create a dependent dropdown in *google form* in 1 single section,using data or dependent dropdown menus from a google sheet. please guide me or if possible make a video on it.
P.S : Don't want to use logic based section shuffle or *form ranger* or *cascade formatting*.
thanks in advance
HELP ME Brother. my question until nine pages. why my response just one page? explain me brother
Good day, it is very helpful however I can't find the name then entry when I click the inspect. Hope you will respond to my question sir.
populate any text field in the form and search the text you populated in developer window you will find the field id
I'm unable to find the entry id.
When I write something in text field and then look up to inspect I only get this :
here Rahul is the text I've written
Please help
Same happen with me.
@@swapnilthorat6624 I got the solution for it.
@@sharafmehdi6285 please share
@@swapnilthorat6624 If you created that form, you can get a pre fill link so generate a pre fill link and the entryid is given in that generated pre fill url.
@@sharafmehdi6285 lot of
thank you bro...
How to input # in form?for example abcd#1234. It only shows abcd, value disappear after #
Great tutorial!
Thank you!
@@AutomationMadeEasy I hate to come with an issue, but i've tried everything I know and it still seems to be occurring. I keep getting the error:
TypeError: Cannot read property 'getRange' of null (The error is the line for the first info inside of the for loop. Would be line 22 for your code.)
I've retyped everything, made sure the spreadsheets have the information in the correct spots, and it still happens. Any ideas? Thanks!
Update: okay so when I comment out var wrkSht and change the rest to use wrkBk it works fine, I might have messed up there.
Share your code.
Thanks for such helpful video Sir. How do we print 6% in answer .
i have last option in form option for image upload how to setup?
Hi, this is wonderful tutorial.
I have a web page that requires multiple entries. I have the requisite data in an excel sheet. However, I do not want to submit the data in one go(after submit i dont get to edit it). There is a save draft option next to the submit button which i would like to use for trying the code before submitting. Is there a similar function from MS Excel to web pages and not just google forms.
you can take the approach explained in below tutorial:
ruclips.net/video/-GUw22ecRwI/видео.html
Sir please help me from last 3 month i cant get form field name by inspecting that is like entry.1245564 not found
Enter some value in the form field and search the same value in the developer window you will find the entry name
@@AutomationMadeEasy sir i have tried like this too... Sir please check once and reply sir... You are my god... I want this project please sir... Can you please provide your mail address plz
info@automationandagile.com
my script is running to completion but nothings happening
My friend, can you try to develop the same thing to office forms? I'm trying to automate data entry to office form, but it works different, thank you for your attention.
What if we want to add a new row and not give a specific row number in var code, instead it should get updated when we add new row with new data.
use while loop. Check if the Column A data is blank or not. assume column A data is represented by variable fname
while (fname != "")
{
//code
}
Hello sir,In my form all the entries are having same value so how to distinguish while creating code?
Thanks for the amazing video, is it possible to edit or update any field as well? example update a person's age
How can I reach you urgently?
write into info@automationandagile.com
I have an error stating
[Saved Progress It looks like there's a more recent draft of your response. Update to your latest draft to pick up where you left off. ]
May I know how I resolve this?
- Click update
- Find and click on clear form
- Retry
It worked for me when I was doing one.
I am getting a page not found error .. can you please help ?
Sir Any video tutorials for autofilling a webform by uploading data in excel..?
Hey there. Thanks for the insight. What if I have a dynamic row? say for example if I add data till row 17, how to auto update? Thanks in advance
I am not able to see "name property" in my google form. I can only find the values as (aria-describedby="i2 i3"). can you please help me here.
enter some value in the field and search for the entered value in developer window you will find name property
i cant find name attribute in the inspect element
i am unable to find name entry for linear scales
Thanks so much! How do i display multiple say 100 records in each page and do pagenation like this comments or any e-commerce site.
Hi. Very good explanation style. Your articulation is beyond good. Had a QQ - What is the script if I have to choose more than one option in the check boxes.
just keep on appending entry.754654=Sports& entry.754654=Music
Okay. But lets say I have sports in one column and music in another column in sheets, then how do I create the script for 2 different columns which has the values belonging to the checkbox options.
Put it in one column and seperate them with commas or any other delimeter.
Thank you for the video! It really helped! But I still have a doubt, I need to attach a file to each answer. It's possible? How can I automate this?
Have never tried file uploads with this approach but you can use an alternate UI based approach explained in below tutorial:
ruclips.net/video/7a8IofqBNo4/видео.html
Such a nice and easy to understand video.
I have some other requirements like dependent dropdown from google sheets to google form with a huge data
Can you help me please?
Thanks . How can I help you?
@@AutomationMadeEasy
I have to prepare a google form for collection of information against some pre-filled values which are to be linked from a google sheet with drop down menu.
For example :
Section-1
1. Block Name (14 blocks to be linked with google sheets -drop down)
2. GP Name (240 GPs to be linked with google sheet. the concerned GPs should be shown against the Block Name- drop down)
3. School Name ( 2526 Schools to be linked with google sheet. The concerned schools should be shown against the concerned GP- drop down)
Section -2
4. Enrollment (blank column, to be filled up by the concerned school HM)
5. Teacher position (blank column, to be filled up by the concerned school HM)
6. Other information as and when required
If you would like , i will send a excel file to understand better