Thank you for this video. I created my first basic app and I couldn't use it in Weebly (used in Google sites instead) until you explained this concept. Keep up the good work!!!
I have a case when I need to run 100 different web apps in one master And the Crud is top solution to achieve this goal. Great videos I am always spend at least 1-2 hours per week to watch your ideas ❤
Your videos have helped me SOOO much!!! I have 2 outstanding issues with my form I have developed using your tutorials and I hope you will be able to help! (My apologies if these questions have already been asked...maybe you should start a blog with FAQs and include that in your video descriptions!). 1 - I need to include and upload input item and have the document save to a folder in my Google drive. 2 - I need to redirect to another html page after successfully completing the form (after "Submit"). Thanks in advance!!!
Great series! Extremely well explained and clear. I was wondering if you have a github profile with this work in some repositorie. Thanks for this content!
very helpful thank you! you should make a video on creating a login and logout functionality video with a member's area after they login. so then they can use the web app after they login. I know wordpress uses php so Idk if this is possible with js and appsscript or not but would be pretty cool to have them register and login to see web app while keeping all login info and web app form info in google sheets :)
5 ปีที่แล้ว +4
Great Tutorials. Maybe can you consider "how to use Google Drive Picker" to load file as tutorial ??
Hello! have followed all the videos, really really helpful! 6:32 I have deployed my web app with: - Execute the app as: Me - Who has acces to the app: Anyone, even anonymous Using the web app URL in an incognito window, I was hoping to be able to see my webapp. Instead I am seeing a blank page with the message at the top: "This application was created by another user, not by Google. Terms of Service" Have I missed something?
This is very helpful. But when I tried to go back to ADD RECORD from RUN IT in the google site, it does not go back. On hover, RUN IT button shows the correct URL, but the frame becomes blank. Any suggestions? Thanks
Thank you very much for your great tutorials. It helped me a lot! :) This solution however only seems to work with the "exec" version of the web app, right? So I can not use the "dev"-page anymore as that link gives me the "refused to connect" message again. Also: Even when setting the height in css to 100% my screen gets split in two parts at around a fourth of the screen. I would really appreciate a reply from you if you'd be so kind. :) Thank you very much.
Great application, I wonder if I can somehow protect so that my form wont be used in a third party webpage, i. e., make the permission to embed restricted to a specific set of domains.
Can't thank you enough. Hats off...!!! I have created a survey web app with user's location feature. The web works fine on it's own. But when embed the web app link in googlesite, it gives the geolocation permission error. Can you please please please help me on this?
Thanks a lot.. i watched your full series.. very helpfull but i can see lot of limitation for number of requests in google sheets for different types of computing. can we use it for production in medium traffic website?
Sir, this is awesome. Can you show us also how to search for data from Spreadsheet via entering data on the web page? Let's say I want to find Linda Doe by entering her First Name on the web page and populate all of her data on the web page because I made a mistake and want to change/update her ZipCode without entering new row to database. Or just find and view all people from the same ZipCode and make some changes without me or others entering the spreadsheet itself? Can't wait for new videos. Thanks.
Best worksheets TH-cam channel! It helped me so many times, man. Thanks a lot. I'd like to suggest a subject for a new video: how can I a Google Worksheet in my web app removing all headers, menus and toolbar, keeping only the navigations tabs on the bottom and cells fully editable? I'm using syntax on my page but even using the "widget=false" and "chrome=false" parameters as Google documentation explains, the frame still displays the entire top of the spreadsheet. And with headers, menus and toolbar, users are messing out my sheets and I'd like to keep only columns and lines (cells) and tabs visible, to avoid that. Thanks in advance. You're the guy! :)
Thanks for the informative videos. I had few queries around the webapp publication. So as per your instructions if we change the return HTML ofbject with XFrame options and in the respective HTML set , the problem I see is within the HTML we earlier added href="?v=form" and with this my observation is when in the same page lets say I have multiple href embedded say in respective buttons, the first button whichever is clicked renders the page within frame, however if in the rendered page you again have a button with a href it gives error "Load denied by X-Frame-Options: does not permit cross-site framing". Any solution. do you see any issues with it.
5 ปีที่แล้ว
I have the same problem (only when I useNew Google Site). If y want go back with another boton (to go bak to the main page) it gives me the same error.
Thanks for sharing your feedback : I've the same issue on the second click, white page. The problem is when my GAS is embeded in New Google site but also when it is in Iframe through apache Web server. Same behavior than Ranjan : first ok, the second doesn't work, but I don't have the error "Load denied by X-Frame-Options". When I inspect the page, I can see than the second link opens an other SandboxFrame. So I've 2 SandboxFrames and the second page is not rendered.
I have found these videos extremely helpful as well, and they've helped me develop a webapp that helps me keep track of some local inventory. However, I've come up against precisely the problem listed above. I wonder if anyone has found a solution to this problem? I'm not sure how to proceed.
Unfortunately I really needed to find a solution to this problem, because I found that accessing my Webapp from its original location (instead of putting its content into an ) meant that it displayed poorly on mobile devices: fonts were left too small when they weren't in an . I created a fairly clunky workaround, where I set up a dummy page on my local server for each of the "view" options that is an that points to the corresponding view option on the Webapp. On the Webapp side, my links to various "views" point to the dummy pages on my local server, but with the target set to "_top". (So the process looks like this: my local server sets up an and displays one of the views from the Webapp; when I click on a link in the Webapp, it then makes a call to my local server's dummy page for that view, which creates a new that displays the relevant Webapp view.) It's not perfect, but it at least displays correctly now.
same problem. i can't go back to home. i looked at the console and it gives this error: "Failed to execute 'postMessage' on 'DOMWindow': The target origin provided ('n-2an4yhlvtcotqhyf6uc4xzjly432beqjkdcvw4y-0lu-script.googleusercontent.com') does not match the recipient window's origin ('script.google.com'). exec"
When testing your WebApp prior to publishing, app runs in a 'sandbox' . When publishing, web app is contained in user-defined or Google sites via embed feature. Changing to breaks the testing/development mode of the web app. The 'sandbox' " Refused to display '/dev?v=form' in a frame because it set 'X-Frame-Options' to 'sameorigin'". How do you get the same HTML to work in both development and published environments?
@@ExcelGoogleSheets Thanks. it is unclear why is causing the "refused to display" error, since the url is the same origin as the original url. Even if I remove the "?v=form" parameter, it still gives the same error. Any idea why? The second part of the error is "in a frame because it set 'X-Frame-Options' to 'sameorigin'."
Squarespace Question. When i add the app via in my dashboard it works fine. but when i visit my site url it displays the "Sorry, unable to open the file at this time. Please check the address and try again." error. why would it show perfect in my web editor then not display when i visit the site. makes no sense to me. any help is appreciated *note, im only using this to display the table on a squarespace page.*
This is a really cool video ! THanks for everything. Can you make a video about publishing these web app in a way it can be read on smartphones ? I tried everything, my smartphone doesn't load the webapp...
Hi, To refresh the page, I have to open it in a new tab. I use window.open('link', '_blank'). But it doesn't respect the and opens with the google's message. Any idea how to avoid this? Thanks
This is cool! holy damn! Is it also possible to edit the data from excel in a "form" like this. So lets say i use a search function and not a add function?
Hi, I love to much all your videos, I learn a lot with your explanations but, with this one I have a problem: I followed it step by step and works but I can not publish the web App without authentication: I need the form published could be used for anonymous users. Please could you explain How can do that? Thanks!!!
Same issue with me. All the tutorial show the who can run this as "Only myself" . It works as long as I'm logged into my Google account even if I set this to "Anyone, even anonymous" . It does say "You need to authorize the script before distributing the URL." I have authorized it while running it myself but how do I authorize it for anyone?
*First of all, thanks a lot, I learned a lot* I can see the first page correctly, but on the form page I get a message "The script is complete but the returned value is not a supported return value." What to do?
Thanks for the tutorial. All is working for me except, only for me, when I'm logged into my Google Account. All the tutorials, including yours, show the who can run this as "Only myself" . What additional steps are needed beside setting it to "Anyone, even anonymous" . It does say "You need to authorize the script before distributing the URL." I have authorized it while running it myself but how do I authorize it for everyone else that visits the webpage?
@@ExcelGoogleSheets I think my issue is I'm using a file picker in my HTML and the part of my code to save files to the Google Drive is the problem as the message says something about requesting permission to access the Drive. So those extra permissions are required. I'm still working on figuring out how to allow that access to the public. I do realize that that could be risky.
Its really cool!!! That's great. By the way, would you mind to make another tutorial on how to correct some cells in google sheet via app script/HTML page?
It was a great expression. While Google site is working with , it works with target = '_ self' but has trouble returning to the homepage. Save does not return from the form page to the Home page. Why? I would be glad if you could help.
@@ExcelGoogleSheets Yes.. All pages target base _self... Google Script works on returns without IFRAME. But it doesn't work on Google sites within IFRAME...
Is there a solution to this. Im stuck and can't proceed with my Web App knowing that I can't go back using Browser Back button. Getting a blank page. Please help
Hello Sir, I have one issue to discuss! I have managed to do all things here to publish webapp through google sites embadding. But, So it successfully appeares the login page which is the first page of my web app. after login, user landing page shows up. But after that when I click for any button, next page should be a form to fill by user, it just simply doesn't shows up. only blank/white screen appeares. Could you please help me with this.?
let tmp = HtmlService.createTemplateFromFile(file); return tmp.evaluate() .addMetaTag('viewport', 'width=device-width, initial-scale=1'); // It is very important tag for Responsive;
@@ExcelGoogleSheets I am using a JSON file from google drive to generate a dynamic dependent dropdown. Upon embedding the web app in google site, the dynamic dropdown works only when I am logged in with the same user with which I developed the web app. Otherwise, the dropdown won't work but the rest of the elements have no issue in rendering. Details at stackoverflow.com/questions/61825292/issue-with-dynamic-dependent-drop-down-in-a-web-app-built-with-appscript-embedde
Hi, Sir i have issue with the sheet, the app script fuction running only with me althought i shared my sheet with my friends, but with thier acc app script is not running even they have full access of the sheets, Please help me to sort out this problem.the issue is that last entry not going up automaatically with thier account.
Sir, I put geocode script to my apps script-webform and embed it to Google Sites, that's geocode work just fine with this link before I embed it: script.google.com/macros/s/AKfycbx-aIF9U49652svnCQjdhzUhZ71N9szaHz-EpZaFC2fD9Bpynk/exec But, when I try to embed it to google sites: sites.google.com/view/polidata3/halaman-muka it didn't work Sir.. Btw my particular geocode form was in this label "Apakah Anda bersedia membagikan lokasi?" (Latitude and Longitude) How to make that geocode keep work even I embed it to Google Sites? Thank's Sir...
Refused to display 'script.google.com/macros/s/AKfycbzdFQxUebj3obF6Qde6R-BqlPcFTAuyfZSWXjNR7X9I/dev?v=form' in a frame because it set 'X-Frame-Options' to 'sameorigin'.
If your goal is to just get rid of the Google disclaimer top bar message, I believe that if you are running the app on a G Suite account rather than a free Gmail Account, that message is not there by default.
Read my previous comment... A login system like this video th-cam.com/video/077NNHPAwc0/w-d-xo.html but instead of a for loop looping through variable in code it would loop through rows in a sheet looking for a match to log you in. Isn't this secure? That way after they login we can have an iffame with app come up like you did in this video but they only see the web app if they successfully login :)
Thank you for this video. I created my first basic app and I couldn't use it in Weebly (used in Google sites instead) until you explained this concept. Keep up the good work!!!
I have a case when I need to run 100 different web apps in one master
And the Crud is top solution to achieve this goal. Great videos I am always spend at least 1-2 hours per week to watch your ideas ❤
Your videos have helped me SOOO much!!! I have 2 outstanding issues with my form I have developed using your tutorials and I hope you will be able to help! (My apologies if these questions have already been asked...maybe you should start a blog with FAQs and include that in your video descriptions!). 1 - I need to include and upload input item and have the document save to a folder in my Google drive. 2 - I need to redirect to another html page after successfully completing the form (after "Submit"). Thanks in advance!!!
The best explanation about this, thank you so much
Gracias por dedicar tiempo al realizar estos videos. Me han servido mucho.
Great series! Extremely well explained and clear. I was wondering if you have a github profile with this work in some repositorie. Thanks for this content!
very helpful thank you! you should make a video on creating a login and logout functionality video with a member's area after they login. so then they can use the web app after they login. I know wordpress uses php so Idk if this is possible with js and appsscript or not but would be pretty cool to have them register and login to see web app while keeping all login info and web app form info in google sheets :)
Great Tutorials. Maybe can you consider "how to use Google Drive Picker" to load file as tutorial ??
Outstanding video! Thank you! Your content is A++
Hello! have followed all the videos, really really helpful!
6:32 I have deployed my web app with:
- Execute the app as: Me
- Who has acces to the app: Anyone, even anonymous
Using the web app URL in an incognito window, I was hoping to be able to see my webapp. Instead I am seeing a blank page with the message at the top:
"This application was created by another user, not by Google.
Terms of Service"
Have I missed something?
Did you deploy as a new version as you were making these changes?
@@ExcelGoogleSheets My hero! It works now! Cheers
You're my angel. thank you so much!!
As always, awesome!!!! That’s what we need! Thanks man.
This is very helpful. But when I tried to go back to ADD RECORD from RUN IT in the google site, it does not go back. On hover, RUN IT button shows the correct URL, but the frame becomes blank.
Any suggestions? Thanks
This is exactly what Im getting. When Pressing Back in the browser navigation, the becomes BLANK. All GAS html files have base=-self. Need Help please
@@gauravesondhi4548 Got same problem here. Have you found any possible solutions?
Thank you very much for your great tutorials. It helped me a lot! :)
This solution however only seems to work with the "exec" version of the web app, right? So I can not use the "dev"-page anymore as that link gives me the "refused to connect" message again.
Also: Even when setting the height in css to 100% my screen gets split in two parts at around a fourth of the screen.
I would really appreciate a reply from you if you'd be so kind. :)
Thank you very much.
Yes, it works with exec only. Setting height is a complicated subject. Setting to 100% will nor result in what you would expect.
try to add this to the tag: onload="this.width=screen.width;this.height=screen.height;"
Great application, I wonder if I can somehow protect so that my form wont be used in a third party webpage, i. e., make the permission to embed restricted to a specific set of domains.
Can't thank you enough. Hats off...!!! I have created a survey web app with user's location feature. The web works fine on it's own. But when embed the web app link in googlesite, it gives the geolocation permission error. Can you please please please help me on this?
Thank you for explaining this 🙌
Glad it was helpful!
Hi, do you know how I can use Google Analytics to track the web app? I tried embed the Google Analytics code in html, but it won't work. Thanks!
Tanks a lot! I LOVE YOU!
can you talk about loading files gradually into a web app while its running using promises or any similar technique?
Dude you are genius
Thanks a lot.. i watched your full series.. very helpfull
but i can see lot of limitation for number of requests in google sheets for different types of computing.
can we use it for production in medium traffic website?
Sir, this is awesome. Can you show us also how to search for data from Spreadsheet via entering data on the web page? Let's say I want to find Linda Doe by entering her First Name on the web page and populate all of her data on the web page because I made a mistake and want to change/update her ZipCode without entering new row to database. Or just find and view all people from the same ZipCode and make some changes without me or others entering the spreadsheet itself?
Can't wait for new videos. Thanks.
this concept you want.. is in video 5.. search a match! :)
me encanta eres una maquina bro
Great! thanks very much!
Best worksheets TH-cam channel! It helped me so many times, man. Thanks a lot.
I'd like to suggest a subject for a new video: how can I a Google Worksheet in my web app removing all headers, menus and toolbar, keeping only the navigations tabs on the bottom and cells fully editable?
I'm using syntax on my page but even using the "widget=false" and "chrome=false" parameters as Google documentation explains, the frame still displays the entire top of the spreadsheet.
And with headers, menus and toolbar, users are messing out my sheets and I'd like to keep only columns and lines (cells) and tabs visible, to avoid that.
Thanks in advance. You're the guy! :)
Hi, try to use this :
docs.google.com/spreadsheets/d/[your ss id]/edit?rm=minimal#gid=0
Thanks for the informative videos. I had few queries around the webapp publication. So as per your instructions if we change the return HTML ofbject with XFrame options and in the respective HTML set , the problem I see is within the HTML we earlier added href="?v=form" and with this my observation is when in the same page lets say I have multiple href embedded say in respective buttons, the first button whichever is clicked renders the page within frame, however if in the rendered page you again have a button with a href it gives error "Load denied by X-Frame-Options: does not permit cross-site framing". Any solution. do you see any issues with it.
I have the same problem (only when I useNew Google Site). If y want go back with another boton (to go bak to the main page) it gives me the same error.
Thanks for sharing your feedback : I've the same issue on the second click, white page. The problem is when my GAS is embeded in New Google site but also when it is in Iframe through apache Web server. Same behavior than Ranjan : first ok, the second doesn't work, but I don't have the error "Load denied by X-Frame-Options". When I inspect the page, I can see than the second link opens an other SandboxFrame. So I've 2 SandboxFrames and the second page is not rendered.
I have found these videos extremely helpful as well, and they've helped me develop a webapp that helps me keep track of some local inventory. However, I've come up against precisely the problem listed above. I wonder if anyone has found a solution to this problem? I'm not sure how to proceed.
Unfortunately I really needed to find a solution to this problem, because I found that accessing my Webapp from its original location (instead of putting its content into an ) meant that it displayed poorly on mobile devices: fonts were left too small when they weren't in an . I created a fairly clunky workaround, where I set up a dummy page on my local server for each of the "view" options that is an that points to the corresponding view option on the Webapp. On the Webapp side, my links to various "views" point to the dummy pages on my local server, but with the target set to "_top". (So the process looks like this: my local server sets up an and displays one of the views from the Webapp; when I click on a link in the Webapp, it then makes a call to my local server's dummy page for that view, which creates a new that displays the relevant Webapp view.) It's not perfect, but it at least displays correctly now.
same problem. i can't go back to home. i looked at the console and it gives this error: "Failed to execute 'postMessage' on 'DOMWindow': The target origin provided ('n-2an4yhlvtcotqhyf6uc4xzjly432beqjkdcvw4y-0lu-script.googleusercontent.com') does not match the recipient window's origin ('script.google.com'). exec"
Nice tutorial! But how do you pass url parameters once it's embedded on Google Sites? window.location.search doesn't work
I am also having the same problem
Is it possible to use the concept while embedding the script url in app web viewer? So that I cannot see the google message.
Someone knows how make the application responsive ? I tried to used it on my phone but the calendar doesnt work.
add meta tag to your HtmlService object developers.google.com/apps-script/reference/html/html-output-meta-tag
When testing your WebApp prior to publishing, app runs in a 'sandbox' . When publishing, web app is contained in user-defined or Google sites via embed feature. Changing to breaks the testing/development mode of the web app. The 'sandbox' " Refused to display '/dev?v=form' in a frame because it set 'X-Frame-Options' to 'sameorigin'". How do you get the same HTML to work in both development and published environments?
You could do an IF statement that would produce different base target depending on dev or exec version.
@@ExcelGoogleSheets Thanks. it is unclear why is causing the "refused to display" error, since the url is the same origin as the original url. Even if I remove the "?v=form" parameter, it still gives the same error. Any idea why? The second part of the error is "in a frame because it set 'X-Frame-Options' to 'sameorigin'."
Squarespace Question.
When i add the app via in my dashboard it works fine. but when i visit my site url it displays the "Sorry, unable to open the file at this time. Please check the address and try again." error.
why would it show perfect in my web editor then not display when i visit the site. makes no sense to me. any help is appreciated *note, im only using this to display the table on a squarespace page.*
now its just working now haha!! jeez giving me a panic attack
This is a really cool video ! THanks for everything.
Can you make a video about publishing these web app in a way it can be read on smartphones ? I tried everything, my smartphone doesn't load the webapp...
it to netlify, for an alternative.
@@ConsulthinkProgrammer I'll try it, thanks !
@@robinlioret7808 you're welcome. You could check my video about create website with apps script and netlify, maybe that will give you some clue.
Hi can u help me, i want to get the Url file from google script, but i don't know how to get value from the
in your code.gs, write:
var url= ScriptApp.getService().getUrl();
Hi,
To refresh the page, I have to open it in a new tab. I use window.open('link', '_blank'). But it doesn't respect the and opens with the google's message. Any idea how to avoid this? Thanks
really helpful , but what if the height of frame is not fixed?
Are there security vulnerabilities that come with the AllowAll method?
Setting XFrameOptionsMode.ALLOWALL will let any site to the page, so the developer should implement their own protection against clickjacking.
This is cool! holy damn! Is it also possible to edit the data from excel in a "form" like this. So lets say i use a search function and not a add function?
hey bro, your videos are amazing, but i need to know something, is there any way to offer to the client add this web app to the home screen??
Thank you so much!
God bless you
Hi,
I love to much all your videos, I learn a lot with your explanations but, with this one I have a problem: I followed it step by step and works but I can not publish the web App without authentication: I need the form published could be used for anonymous users. Please could you explain How can do that? Thanks!!!
Same issue with me. All the tutorial show the who can run this as "Only myself" . It works as long as I'm logged into my Google account even if I set this to "Anyone, even anonymous" . It does say "You need to authorize the script before distributing the URL." I have authorized it while running it myself but how do I authorize it for anyone?
*First of all, thanks a lot, I learned a lot*
I can see the first page correctly, but on the form page I get a message "The script is complete but the returned value is not a supported return value."
What to do?
I don't know, what's your script?
grat series thanks
Thanks for the tutorial. All is working for me except, only for me, when I'm logged into my Google Account. All the tutorials, including yours, show the who can run this as "Only myself" . What additional steps are needed beside setting it to "Anyone, even anonymous" . It does say "You need to authorize the script before distributing the URL." I have authorized it while running it myself but how do I authorize it for everyone else that visits the webpage?
You want to make sure you deploy it as a new version in addition to just changing "Anyone, even anonymous".
@@ExcelGoogleSheets I think my issue is I'm using a file picker in my HTML and the part of my code to save files to the Google Drive is the problem as the message says something about requesting permission to access the Drive. So those extra permissions are required. I'm still working on figuring out how to allow that access to the public. I do realize that that could be risky.
you mean this? developers.google.com/picker/
Thank you for the useful video. May I ask for the results of the Google Apps Script Web App. thank you for your kindness.
Yeahhhhhhhhhhhhh!!!!!! Thanks a lot !
Could you have also set the height to 100%? Just wondering why you chose to set it to 500px instead.
Height="100%" does not work in tag.
You can use css to set it to 100vb
Its really cool!!! That's great. By the way, would you mind to make another tutorial on how to correct some cells in google sheet via app script/HTML page?
Thanks
Upto this it is possible, but once google site connect custom domain ,it showing error message in online view "scrip refuses to connect "
Thank you
It was a great expression. While Google site is working with , it works with target = '_ self' but has trouble returning to the homepage. Save does not return from the form page to the Home page. Why? I would be glad if you could help.
Are you sure you have _self for all pages? You need to make sure you set the target for all pages, not just the main page.
@@ExcelGoogleSheets Yes.. All pages target base _self...
Google Script works on returns without IFRAME. But it doesn't work on Google sites within IFRAME...
@@gulmathuzunseven6561 same problem here.. whenever i click the go back button. the page is blank.
same problem
Is there a solution to this. Im stuck and can't proceed with my Web App knowing that I can't go back using Browser Back button. Getting a blank page. Please help
How do you switch between home.html and page.html in one script?
Hello Sir,
I have one issue to discuss!
I have managed to do all things here to publish webapp through google sites embadding. But, So it successfully appeares the login page which is the first page of my web app. after login, user landing page shows up. But after that when I click for any button, next page should be a form to fill by user, it just simply doesn't shows up. only blank/white screen appeares. Could you please help me with this.?
check your bases for each page and link target properties and adjust them accordingly.
i have followed example and created an html file but page is blank. What could be wrong?
I'd like to embed the code at google sites but with mobile responsiveness, how do i do it?
let tmp = HtmlService.createTemplateFromFile(file);
return tmp.evaluate()
.addMetaTag('viewport', 'width=device-width, initial-scale=1'); // It is very important tag for Responsive;
Cool, looks like you have the answer.
awesome
Hello, after embedding the working code in google site, my dynamic dependent dropdown stops working for unknown reasons. Have I missed anything here?
I can't guess, check your console log.
@@ExcelGoogleSheets I am using a JSON file from google drive to generate a dynamic dependent dropdown. Upon embedding the web app in google site, the dynamic dropdown works only when I am logged in with the same user with which I developed the web app. Otherwise, the dropdown won't work but the rest of the elements have no issue in rendering. Details at stackoverflow.com/questions/61825292/issue-with-dynamic-dependent-drop-down-in-a-web-app-built-with-appscript-embedde
@@faceoff7875 Well, how did you deploy the app as far as who can access it?
@@ExcelGoogleSheets Issue solved after changing the execution access from any user to the web app owner. Thank you for your help.
Working in JavaScript is more exciting than VBA
I have to agree. Especially when you need to work with arrays.
Hi, Sir i have issue with the sheet, the app script fuction running only with me althought i shared my sheet with my friends, but with thier acc app script is not running even they have full access of the sheets, Please help me to sort out this problem.the issue is that last entry not going up automaatically with thier account.
Make sure you deploy a new version under right permission and then share that link with them.
@@ExcelGoogleSheets Thanks boss
is it possible to create a login screen and password to enter the form?
Amazing
HELP ME! i can use only on Microsoft Edge, cant on Google Chrome
Thank !!!
Hello Sir Please can you give us Verification or command that if we finish sumit .then it will appear YOUR SUCCESSFULLY ADD RECORD Thanks in advance
Please share your script to make copy thanks in anticipation
this is not working on incognito mode right ?
Won't work if you deploy the app and require for the user to be logged in. Otherwise it should work fine.
Google sites seems to be gone now, I used netlify instead
sites.google.com
How to show a pop up once we click the button
M.toast({html: 'I am a toast!'})
Sir please create to submited name, email and number then redirect thank you page how to make sir please help me
Sir, I put geocode script to my apps script-webform and embed it to Google Sites, that's geocode work just fine with this link before I embed it:
script.google.com/macros/s/AKfycbx-aIF9U49652svnCQjdhzUhZ71N9szaHz-EpZaFC2fD9Bpynk/exec
But, when I try to embed it to google sites: sites.google.com/view/polidata3/halaman-muka
it didn't work Sir..
Btw my particular geocode form was in this label "Apakah Anda bersedia membagikan lokasi?" (Latitude and Longitude)
How to make that geocode keep work even I embed it to Google Sites? Thank's Sir...
it doesn't work.
Refused to display 'script.google.com/macros/s/AKfycbzdFQxUebj3obF6Qde6R-BqlPcFTAuyfZSWXjNR7X9I/dev?v=form' in a frame because it set 'X-Frame-Options' to 'sameorigin'.
did you do this?
developers.google.com/apps-script/reference/html/html-output.html#setXFrameOptionsMode(XFrameOptionsMode)
If your goal is to just get rid of the Google disclaimer top bar message, I believe that if you are running the app on a G Suite account rather than a free Gmail Account, that message is not there by default.
I believe that you still get that message on paid accounts. Maybe somebody with experience can confirm.
I can confirm, I am a GSuite user and still get that message
Read my previous comment... A login system like this video th-cam.com/video/077NNHPAwc0/w-d-xo.html but instead of a for loop looping through variable in code it would loop through rows in a sheet looking for a match to log you in. Isn't this secure? That way after they login we can have an iffame with app come up like you did in this video but they only see the web app if they successfully login :)
Creating a secure login system is not a simple task. You can make something like this that works but it will hardly be secure.
Gotcha thank you for the reply much appreciated 👍
i hope google wont block my form for this
Boss all of your videos are awesome. how does it show in by "?v=form"
God bless you