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
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
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!
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.
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?
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).??
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
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
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?
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.
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
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
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-g7xOwulfwK0.html
@@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.
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.
Hi! First of all, nice tutorial 🙂 I have tried the first method. I found all the Element names for each data entry, and I input my data the way you did on the notepad, and compiled them into a single URL. Although, when I pasted it on the browser, an error appeared “There was an error submitting your response. TRY AGAIN” When I pressed try again, it worked and sent mu response. Is there a workaround to not encounter that error, and directly send my response? Thank you
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.
Put the booes as comm seperated in the spreadsheet for eg Sports,Reading Some prograaming would be needed to split each hobby and then must be put in the url
@@AutomationMadeEasy Thank you! In addition to that question, may I know how do u give a random string in the "Others" for listitems? Ive found two separate name values, one with other_option_response and the other with numbers. Tried passing in value to other option response but no luck ie A B C Others: ___
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 ??
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:
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
Have never tried file uploads with this approach but you can use an alternate UI based approach explained in below tutorial: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-7a8IofqBNo4.html
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 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
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
The approach explained in the tutorial is applicable for google forms only. For generic auto data entry you may refer below tutorial: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AEp0Yeis9AM.html
Hi, the var Final URL seemed to have an issue for me... It says SyntaxError: Unexpected token 'var' (line 30, file "Code.gs"). Do you have any ways to solve it?
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?
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
Hello sir, I've watched your videos on RU-vid. 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.
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?
Hi! Great Video! I just have a question: When I write the form response URL (which I edited and later added on the address bar) it automatically sends me to the view form url. How can I fix this?
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?
Hey bro, good explanation and attention to detail! I tried finding the name entry for "email address" but really not able to find. Tried your dropdown method by filling in the data and then looking for it in developer mode but not able to find it any way. Can you help?
@@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?