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.
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 ?
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!
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.
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?
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?
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
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 ?
@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
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 🤔
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?
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
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.
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.
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.
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.
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 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
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?
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
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?
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!!
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.
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?
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?
@@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
@@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
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
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.
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 ?
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...
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
