Тёмный

How to Add Geographical Info (Geocode: Longitude/Latitude) to Google Forms 

Khizer Mehmood
Подписаться 515
Просмотров 123 тыс.
50% 1

Опубликовано:

 

30 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 421   
@marielbehnke2037
@marielbehnke2037 7 месяцев назад
Thank you Khizer! You've saved a small non-profit a lot of time and money - this was so easy once I actually opened the documents. Love the kitten background.
@halalexpressions
@halalexpressions 2 года назад
You are revealing a lot of personal information in this tutorial including your email and home address
@hannychristine1647
@hannychristine1647 4 года назад
It was done well but when I submitted the form, there weren't geostamp, geocode and geoaddress in my google sheet. Could you help? Thank you
@deepakmaurya489
@deepakmaurya489 3 месяца назад
its only for two questions, not for more questions.
@holcimsales3435
@holcimsales3435 Год назад
Hi Dear , I was able to collect the geolocation for the first input only , the other inputs arrives to the google sheet without addresses , why please ?
@sergiorocha5379
@sergiorocha5379 Год назад
After several attempts I discovered the reasons why Master Khizer's codes apparently didn't work. I was copying them directly from the Drive file in the Browser. This added expressions to the code, which made it buggy. You need to OPEN the code for editing, and then COPY the code. Congratulations Khizer!
@andchanel5543
@andchanel5543 3 года назад
me TypeError: Cannot read property '0' of undefined (line 12, file "code") can someone help me please!
@datamanagementexecutive1359
@datamanagementexecutive1359 3 года назад
Dear, after submitting the link "Form Submitted Successfully" is not coming even after changing from "Geo Code Entered". But still isn't working. Please help.
@sheldonbrown438
@sheldonbrown438 Месяц назад
am getting this error Exception: No HTML file named Index was found. (line 2, file "Code")
@wanderingmaus
@wanderingmaus 4 года назад
I keep getting error that the script can't run. Is there a html file code that can be copy and pasted from something other than the Lumin pdf add on from google?
@nataliaeliceiri5560
@nataliaeliceiri5560 9 месяцев назад
Hola! Me tira un error: Exception: No se ha encontrado el archivo HTML denominado Index. (línea 2, archivo "Codigo GS") Me podras ayudar?
@omerbingolbali1266
@omerbingolbali1266 Месяц назад
Thanks Khizer, but this process did not work on the latest versions of Apple phones. Can you help me?
@THOMASBALAN
@THOMASBALAN 2 года назад
i try then this message appear. why? Exception: No HTML file named Index was found. (line 2, file "GEOCODE")
@anastasiagkargkavouzi5379
@anastasiagkargkavouzi5379 4 месяца назад
Hi! Can you help me? when clicking on the link, it says "Exception: No HTML file named Index was found. (line 2, file "Code")". What am I doing wrong?
@javierparedesu96paredes35
@javierparedesu96paredes35 Год назад
thanks for your cooperation./ resumes mi trabajo enormemente maestro/ thank you man/ from Peru
@Fatmaalzhraa-mu5ex
@Fatmaalzhraa-mu5ex 5 месяцев назад
Thank You really! but I'm facing an issue that some people their location doesn't appear in the form despite turning on location
@fernandoteransangerman8654
@fernandoteransangerman8654 4 года назад
Excellent tutorial, thanks for sharing, it cost a lot of work but as at 10 attempts everything was perfect. Cheers.
@maulikgangani5491
@maulikgangani5491 4 года назад
I want to make one google form which can capture the location of the respondent. I was searching that how making this feature in google forms & I found this video. As I am not an expert in coding, but I need this coding so that I can make a form which can collect the current location of the respondent. If somebody can help me, I will be thankful for them. Can I have this coding, which is mentioned in this video?
@ayushjindal6908
@ayushjindal6908 3 года назад
@@maulikgangani5491 You don't need to know coding, just copy paste the code from the links.
@khizermehmood3187
@khizermehmood3187 3 года назад
Thanks. kindly support me on Patreon : www.patreon.com/khizermehmood97
@anneanetor9952
@anneanetor9952 2 года назад
@@ayushjindal6908 what links please? I am currently doing same and need help getting the code.
@salidahuerta8667
@salidahuerta8667 2 года назад
I am having trouble and I do not think I have all of the code and index scripts down to make it work properly.
@rajavamshafan8271
@rajavamshafan8271 Год назад
Bro, When we submit this Google form from Mobile Phone its not capturing the Geo location, but its taking from System Please help
@helloworld1164
@helloworld1164 4 года назад
Why some geo location inserted in google sheet in red instead of black?
@michelemery4986
@michelemery4986 4 года назад
Super ! Just curious, can this script collect geo locations when not in cell or wifi range (ex in the field)? using the internal GPS of your phone.
@cecillejustinbayonito8871
@cecillejustinbayonito8871 Год назад
hi, i tested to run the finished form on the phone. I have one problem tho... the geocode demo project didn't run as smoothly as it was tested on a desktop chrome. I need help running the geocode demo via phone. thank you
@daggubatisagarbabu4787
@daggubatisagarbabu4787 2 года назад
ReferenceError: functiondoGet is not defined (line 1, file "Code") occured what to do
@indsatindicedesatisfacao2535
If I send the fomr link to someone else, it gives an access denied error. Is there another way to add an activator instead of clicking on a link?
@โชติกาประภากุลธวัช-ศ8ศ
i can run this form on PC & ios but can't android? it's don't have allow to click. pls tell me, how this work?
@josephallend.devera2703
@josephallend.devera2703 2 года назад
Hi! At the end, I pushed the block location, how to undo? And make it turn back on again. Thank you!
@mahanimdzali7871
@mahanimdzali7871 3 года назад
Friends,, help meyhh,,"Exception: No HTML file named Index was found. (line 2, file "Code")"
@googlesheetautomation3573
@googlesheetautomation3573 Год назад
i am geeting this pop when i clicked on url GeoCode Entered but location is not come in the sheet please help
@vicentegonzalez5298
@vicentegonzalez5298 2 года назад
What lines need to be deleted to deactivate the time-stamp function? google forms automatically time-stamps submissions.
@mdpdme738
@mdpdme738 4 года назад
its not working in mobile phone, If I open Google form on mobile then after submission, Geocode does not work
@razakmd4859
@razakmd4859 2 года назад
The script is working in desktop.But it's not working in mobile (Android phone). It's through error like.. Sorry,Unable to open the file at this time. How can resolve this ?
@MultiDev143
@MultiDev143 4 года назад
Script function not found: doGet pls help me to resolved it
@gersonbenjamin6194
@gersonbenjamin6194 4 года назад
Yes, please, I have the same isue
@tapits5015
@tapits5015 4 года назад
me too
@carlosandrade4246
@carlosandrade4246 4 года назад
Do not ask me why, but I've just published again as NEW project version and it works!
@adityayona8611
@adityayona8611 4 года назад
it's not Functiondoget but Function doGET try to add a space, same way for function getLoc
@kelechiokoh6595
@kelechiokoh6595 Год назад
@khizer Thank you once again for this video. But seems like the code is no longer working. I have been using the code for tracking my team on field. But for a while now, after clicking on the link, it does not track the user's location and it does not displays "Sorry, unable to open the file at this time. Please check the address and try again'. Please help
@poclerk1413
@poclerk1413 Год назад
Its working
@biha2286
@biha2286 3 года назад
Hi, i have 2 forms in google form which need to use the location. Which part of coding should i change . because it only works for one form
@TestTest-uo4bx
@TestTest-uo4bx 3 года назад
Hi I am not able to deploy Syntax error: SyntaxError: Unexpected token '{' line: 1 file: Geo.gs this error msg displays
@josedavidabad812
@josedavidabad812 3 года назад
Gracias por tu valiosa contribución. Saludos desde Quito - Ecuador.
@dr1mezo
@dr1mezo 3 года назад
thanks for the most important things but it doesn't work for me & give me a message : Exception: لم يتم العثور على ملف HTML باسم Index. (السطر رقم 2، الملف "الرمز") what do you think 🤔
@vikzascribbler
@vikzascribbler 2 года назад
Hatts of for your teaching thanks a lot 🥰❤️ we will support you more and more.. ❤️ keep going.. ❤️
@jessicamariaquinterovilami8234
@jessicamariaquinterovilami8234 7 месяцев назад
i tryed everythings and it is not work, dont show any error and dont show nothing in the excel,
@kalairajst3696
@kalairajst3696 3 года назад
Am getting an error message at the time of submitting the form by the respondent saying At present, s not available despite i have gdrive account
@lovepreetsingh-ku9ot
@lovepreetsingh-ku9ot 2 года назад
Script function not found: doGet getting this error while submitting through link
@humanresourcemanager8527
@humanresourcemanager8527 2 года назад
10:29:04 AM Error TypeError: Cannot read property '0' of undefined Please assist to resolve this Error. This is in getLoc() function.
@vikashmishra9350
@vikashmishra9350 3 года назад
It is working fine but for some of the users, the geolocation we are getting, is not correct. What could be the reason and how can we resolve the same?
@cristhian5124
@cristhian5124 Год назад
Add some delay to the code to return a position successfully.
@melonsaus
@melonsaus 2 года назад
Hi i just tried to do this but when i went to deploy as a web app i got this error message Syntax error: SyntaxError: Unexpected token '&' line: 2 file: Code.gs - does anyone know how to fix that? Cheers Jo
@sdbdteamravati83
@sdbdteamravati83 3 года назад
ReferenceError: functiondoGet is not defined (line 1, file "Code")
@SIKOLOBULU-gr2oh
@SIKOLOBULU-gr2oh 4 года назад
Hi, I followed all the steps, but I get the following message: "Exception: Cannot find the HTML file named Index. (Line 2," Code "file)." What should I do? Thank you for the answer. Be blessed.
@khizermehmood3187
@khizermehmood3187 4 года назад
First of all, i'd like to thank you for following my tutorial,. You might be missing something while copy pasting or saving that code. Just go to your script editor and again copy the content of file named code.gs, while copying the content from the code.gs (downloaded file) just make sure that you've selected all the content till the end, there might be some chance that you are missing the parenthesis in the last, then while saving the file in script editor make sure the file name must be "code.gs" (.gs extension is must). If still the error retains, repeat the same process thoroughly for index.html. After all this, just let me know if your error gets resolved or not.
@milanm.mathew4889
@milanm.mathew4889 4 года назад
Tried but still having the same error
@ItsMy_Journey
@ItsMy_Journey 4 года назад
@@milanm.mathew4889 me too
@bnunez_18
@bnunez_18 4 года назад
@@milanm.mathew4889 Me too
@fernandoteransangerman8654
@fernandoteransangerman8654 4 года назад
return HtmlService.createHtmlOutputFromFile('Index'); In this line it tells us that the html file should be called Index and not index, the difference is i by I, check how you are naming it.
@kevinpham1188
@kevinpham1188 Год назад
Perfect. That's what I need now.
@s.imoynaclrc9083
@s.imoynaclrc9083 3 года назад
SyntaxError: Unexpected token '{' (line 1, file "Code.gs") error... found
@hardacomp
@hardacomp 3 года назад
IMHAVING THE SAME ERROR... ANY CLUE???
@lllegion6726
@lllegion6726 2 года назад
I just saw your video about geolocation because I'm looking for a way to find a lost cellphone with a geolocation script. do you have a script to find a cellphone that has been lost or stolen. because I have lost as many as 4 cellphones.
@hariadiusman9559
@hariadiusman9559 4 года назад
this is very good, I tried to fill in the google form through my laptop and it worked, but when I filled in via a smartphone, geo information was not recorded ,. is there a solution? thank you very much
@hariadiusman9559
@hariadiusman9559 4 года назад
Alhamdulillah, saya sudah berhasil menggunakan ini, terimakasih , Khizer Mehmood, tutorial anda sangat berguna
@ConsulthinkProgrammer
@ConsulthinkProgrammer 4 года назад
​@@hariadiusman9559 Sy memodifikasi beberapa hal utk mendapatkan data dg script geocode. Tp tampilannya msh sy develope :) script.google.com/macros/s/AKfycbx-nk6nuJD88FsI4ou_ExDtyqUvFLcVf9eQN6f_4EP_5ijMD8A/exec
@lavelldishmon
@lavelldishmon 4 года назад
Don't use the "Short Url" use the long original URL and it will work on mobile
@ConsulthinkProgrammer
@ConsulthinkProgrammer 4 года назад
Related video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-enUGXYMk6C8.html
@Behappyalways309
@Behappyalways309 Год назад
With this coding can we show the location of the office where they have to come ? Please reply.
@poojabhateley8048
@poojabhateley8048 4 года назад
The form is stopping at 'GeoCode Entered', and it is not moving forward. Any suggestions?
@nandu1595
@nandu1595 Год назад
Thanks for the video. It worked once and the entry was in RED color font. After that we tried submitting from different countries, but it is not capturing the geo coordinates. How can I fix it?
@jeffherz6848
@jeffherz6848 Год назад
Hi @khizermehmood3187, how would you send each new geoaddress to an email? is possible to email each time a new address is entered? is that possible?
@narpaal1196
@narpaal1196 4 года назад
Good work. How to handle in case the device like mobile is NOT Switched on Location / gprs services ??
@kittipongsessumpun2596
@kittipongsessumpun2596 2 года назад
Really Useful !!! some interface change - little adaptation but successfully done.
@gagah_sab8452
@gagah_sab8452 4 года назад
I have follow all step but i get a problem Exception: File HTML dengan nama Index tidak ditemukan. (baris 2, file "Kode")
@hariadiusman9559
@hariadiusman9559 4 года назад
huruf i di Index harus capital (Index)
@asambleacristiana6552
@asambleacristiana6552 3 года назад
hi, its possible do that but with a html form? and save data into sheet with geolocation too
@bhargavkaushik4712
@bhargavkaushik4712 3 года назад
It shows this message at the end of the form submission. "Script function not found: doGet"
@ssundaram2u
@ssundaram2u Год назад
Syntax error: SyntaxError: Unexpected token '&' line: 2 file: Code.gs can some one assist please
@Aarya2020
@Aarya2020 2 года назад
how its possible google form submit Geo location get . not a form submit to next step click this below link ?
@sarojdas-u5c
@sarojdas-u5c Год назад
best and better video to learn
@helmijunaidi2366
@helmijunaidi2366 2 года назад
hi, can we do exactly like this in microsoft form ? help me
@Bimotoroida
@Bimotoroida 3 года назад
it says, " Exception: File HTML dengan nama Index tidak ditemukan. (baris 2, file "Code") " , anyone know why ?
@maciel1591
@maciel1591 3 года назад
me too :(
@rizkipradipto5230
@rizkipradipto5230 3 года назад
boleh minta scriptnya? udah tidak tercantum
@idocityside5689
@idocityside5689 3 года назад
its only work if respondent fill google form from PC (Laptop or desktop) , if respondent fill form from mobile this technique fail to work khizer bhai
@mytripleal6846
@mytripleal6846 3 года назад
Thanks Brother this is very helpful for me ,
@lupeets23
@lupeets23 2 года назад
Coordinates aren't showing up on google sheets for me.
@bubberhandicrafts98
@bubberhandicrafts98 2 года назад
TypeError: Cannot read property 'getDestinationId' of null getLoc @ Geocode demo.gs:5 showing this error when running the getloc function
@egypurnama7244
@egypurnama7244 4 года назад
Thank you very much for the nice tutorial. But, I got some problems. When I access the form with my device, it works. But, when the other device want to access, it need permission to web app. I have tried to change the access setting, but it still same. Would you mind to fix it ? Big thanks
@simplyoption9472
@simplyoption9472 3 года назад
But when i am using the form in smartphone it is not recording the geo data plz reply
@natehoyt1026
@natehoyt1026 2 года назад
I keep getting error "Script function not found: doGet"
@wanderingmaus
@wanderingmaus 4 года назад
Actually got it to work with all the permissions. but i go to my responses spreadsheet and the columns for GeoStamp, GeoCode and GeoAddress are not appearing. did i copy the code.gs wrong?
@neelpatel097
@neelpatel097 3 года назад
Same Problem
@jayalathedirisinghe2630
@jayalathedirisinghe2630 4 года назад
I also get an error NO HTML file named Index was found (line2, file "Code") any way out..
@gabrielomar9774
@gabrielomar9774 3 года назад
How was the problem solved?
@temitaiwo2997
@temitaiwo2997 3 года назад
You probably named your html file "index" instead of "Index". The first letter should be a capital I not i.
@exceladvisor29
@exceladvisor29 3 года назад
Bro i keep getting this error >> " Exception: No HTML file named Index was found. (line 2, file "Code") Please guide bro really need your help
@ConsulthinkProgrammer
@ConsulthinkProgrammer 3 года назад
Build the whole form use google apps script and you will solve some problem at the same time in this project :)
@atulsharma4023
@atulsharma4023 3 года назад
Exception: No HTML file named Index was found. (line 2, file "Code") I am getting this error.. someone please help
@maciel1591
@maciel1591 3 года назад
Up
@MafiaOfficialYT
@MafiaOfficialYT 2 года назад
Yrr behtreen bogya larrke. ♥️
4 года назад
Hello, I carry out the steps but when publishing the html it is suspended, thinking ... where can the error be? Thanks a lot
@artmania4956
@artmania4956 4 года назад
Thanks bro, when i tried and filled up the form, following error message is showing: Exception: No HTML file named Index was found. (line 2, file "Code") please help!!
@narpaal1196
@narpaal1196 4 года назад
File name is case sensitive. Please check it once
@vipulkumarsingh6629
@vipulkumarsingh6629 4 года назад
@@narpaal1196 Please explain i am also getting the same error .
@VirtuallyThere88
@VirtuallyThere88 4 года назад
@@vipulkumarsingh6629 File created was likely named index but it needs to be Index (Capital I in index)
@knowledgetips32
@knowledgetips32 3 года назад
On Manage deployment, when i select Only my self its perfectly, but when i select anyone then it show error as below Sorry, unable to open the file at present. Please check the address and try again. Please guide.
@chanthonkounsombath3521
@chanthonkounsombath3521 4 года назад
The system is error ( Exception: No HTML file named Index was found. (line 2, file "Code") ), help me please
@fernandoteransangerman8654
@fernandoteransangerman8654 4 года назад
check that the html is called Index with capital letters
@Rod2lodTv
@Rod2lodTv 3 года назад
It works!! done Subscribed,Thank Man!
@khizermehmood3187
@khizermehmood3187 3 года назад
Thanks. kindly support me on Patreon : www.patreon.com/khizermehmood97
@anshulmishra2064
@anshulmishra2064 2 года назад
Sir is there any option to add some other column like Mobile Advertising IDs, Horizontal Accuracy, Timestamp, country codes etc..
@gaganpunjab8816
@gaganpunjab8816 3 года назад
It is creating problem with Mobile error is being displayed Sorry unable to open the link
@sly4293
@sly4293 6 месяцев назад
Thanks alot man amazin great video
@vikashjain9453
@vikashjain9453 2 года назад
location access permission dialog box not showing, Plz help
@dr1mezo
@dr1mezo 3 года назад
finally I got it! thanks again brother.. gr8 work.
@abhivid6625
@abhivid6625 2 года назад
dear where did you get word file where you copied t
@jegisrajalbalasubramaniamk9601
@jegisrajalbalasubramaniamk9601 4 года назад
It works , especially with hp... tq so much bro .
@khizermehmood3187
@khizermehmood3187 3 года назад
Thanks. kindly support me on Patreon : www.patreon.com/khizermehmood97
@komarsugering
@komarsugering 4 месяца назад
I try it, Run in PC Browser, but not work wile access with mobile Device (Android ) with Chrome Browser. Any suggestion to Fix it ? Thanks
@AbhishekKumar-cq9rc
@AbhishekKumar-cq9rc 4 года назад
Hello Khizer, is there any way i can hide my location if i want to fill a google form ? Thank you
@harshavardhanranshevre2751
@harshavardhanranshevre2751 2 года назад
Crazy hack, you are brilliant!
@winningabe
@winningabe 4 года назад
The location is not precise when I use my laptop. It shows another location outside my city, but when I use my smartphone it is precise. Is my laptop hacked?
@khizermehmood3187
@khizermehmood3187 4 года назад
That might be an error in your GPS sensor.
@digitsdocs7704
@digitsdocs7704 3 года назад
Good work man! We'll try now thanks...
@rickeywillemse
@rickeywillemse 4 года назад
Hi. Thanks for the code. My computer gives the message: Script function not found: doGet. Can you help.
@rickeywillemse
@rickeywillemse 4 года назад
My email address is: hmwillemse@yahoo.com. Can you please mail me the code. Much appreciated.
@khizermehmood3187
@khizermehmood3187 4 года назад
@@rickeywillemse link to download the code is already given in description. thanks
@dharshiniravi708
@dharshiniravi708 11 месяцев назад
Thank you so much sir!
@maulikgangani5491
@maulikgangani5491 4 года назад
I want to make one google form which can capture the location of the respondent. I was searching that how making this feature in google forms & I found this video. As I am not an expert in coding, but I need this coding so that I can make a form which can collect the current location of the respondent. If somebody can help me, I will be thankful for them. Can I have this coding, which is mentioned in this video?
@kohcm1
@kohcm1 4 года назад
Click the show more above under the author name
@afrahccc8446
@afrahccc8446 4 года назад
ReferenceError: navigator is not defined (line 7, file "index" . please help me I keep receiving this message. Jazak Allah Kahair
@binod2065
@binod2065 4 года назад
change the html file name Index (I capital) and re deployee
@bestpropertygrp4593
@bestpropertygrp4593 2 года назад
Seems to work but isnt logging location or adding new columns to spreadsheet...any ideas?
@mnr367
@mnr367 2 года назад
Same for me ...the script get excuted perfectly,.... its not adding the geolocation details to spreadsheet...
@bestpropertygrp4593
@bestpropertygrp4593 2 года назад
@@mnr367 got mine too work, make sure you open script editor from the form not the spread sheet. Now I wish I could make it write the data to a sheet that's not first in the workbook
@mnr367
@mnr367 2 года назад
@@bestpropertygrp4593 i opened it from the form... i will try it again...hope OP comes to help
@mnr367
@mnr367 2 года назад
@@bestpropertygrp4593 Many thanks... i have found the problem.. the form i was trying to get the code working was actually was not under my ownership. I have changed the ownership of the form to mine and geo detais start appearing in the excel
@biplabbiswas8877
@biplabbiswas8877 4 года назад
ReferenceError: document is not defined (line 1, file "Code"), can you plese comment on this error. Thanks
@khizermehmood3187
@khizermehmood3187 4 года назад
Double check the spelling of file name 'Code', spelling (case sensitive) must be identical in both file name (name of the file which you downloaded) and as well as in the script editor
@QaesarNazeer
@QaesarNazeer 2 года назад
Its not picking Geo coding from Mobile ! Can someone guide ?
@incacleaningllc8021
@incacleaningllc8021 2 года назад
Hello. Thank you for your video! I was able to do this to my form and it worked! BUT only for the 1st 2 entries. Is there something that can go wrong? How can I fix it? Please help.
@SiddharthYadav56
@SiddharthYadav56 4 года назад
TypeError: Cannot read property '0' of undefined (line 12, file "Code") Error is showing, var c=value[0]; Showing error When I access the form with my device, it works. But, when the other device want to access, it need permission to web app. I have tried to change the access setting, but it still same. Would you mind to fix it ?
@khizermehmood3187
@khizermehmood3187 4 года назад
Change the access settings for all devices and publish the web app with newer version, then using that new version try accessing the form with different devices...
@SiddharthYadav56
@SiddharthYadav56 4 года назад
Ok done..but some users location not capturing. And when another's location is captureed , same location filled above whose location not captured. Please help me out. I don't want to fill previous row whose geo data missing
Далее
Встреча в Лифте 😂
00:43
Просмотров 244 тыс.
Don’t Use Google Forms Without These FREE Add-Ons!
16:03
How to Add Google Geolocation Autofill to your Forms
3:14