Web App - Remove "This application was created by another user, not by Google." - Part 11

[@GC_Guy]

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!!!

[@reallyefficient]

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!!!

[@elricho72]

The best explanation about this, thank you so much

[@seobookpro]

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 ❤

[@facundopugliese9632]

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!

[@cfalcantara1]

Gracias por dedicar tiempo al realizar estos videos. Me han servido mucho.

Great Tutorials. Maybe can you consider "how to use Google Drive Picker" to load file as tutorial ??

[@daytodatainc.2520]

Outstanding video! Thank you! Your content is A++

[@csprgsio]

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 :)

[@rafaelwendel1400]

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.

[@SendInTheCriton]

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.

[@ExcelGoogleSheets]

Yes, it works with exec only. Setting height is a complicated subject. Setting to 100% will nor result in what you would expect.

[@samimohr6923]

try to add this to the tag: onload="this.width=screen.width;this.height=screen.height;"

[@fvgoya]

As always, awesome!!!! That’s what we need! Thanks man.

[@beomseokkim2065]

You're my angel. thank you so much!!

[@daredevilXIII]

can you talk about loading files gradually into a web app while its running using promises or any similar technique?

[@mangammakopalle7286]

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

[@gauravesondhi4548]

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

[@huangqiuyi9003]

@@gauravesondhi4548 Got same problem here. Have you found any possible solutions?

[@Inspiringeverydaymum]

Thank you for explaining this 🙌

[@ExcelGoogleSheets]

Glad it was helpful!

[@saderick52]

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!

[@blakedaetgibson]

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?

[@ExcelGoogleSheets]

Did you deploy as a new version as you were making these changes?

[@blakedaetgibson]

@@ExcelGoogleSheets My hero! It works now! Cheers

[@shravanshra23]

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?

[@MicheleItaloDAmato]

Nice tutorial! But how do you pass url parameters once it's embedded on Google Sites? window.location.search doesn't work

[@LoiNguyen-ji9ub]

I am also having the same problem

[@howardlee3394]

Tanks a lot! I LOVE YOU!

[@passangttamang416]

Is it possible to use the concept while embedding the script url in app web viewer? So that I cannot see the google message.

[@crismorec]

Someone knows how make the application responsive ? I tried to used it on my phone but the calendar doesnt work.

[@ExcelGoogleSheets]

add meta tag to your HtmlService object developers.google.com/apps-script/reference/html/html-output-meta-tag

[@ranjan25k]

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.

[@czmatlahouse]

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.

[@andrewschultz9]

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.

[@andrewschultz9]

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.

[@JediBrooker]

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"

[@usamanaeem8737]

Dude you are genius

[@mohdhassan2677]

really helpful , but what if the height of frame is not fixed?

[@uni8322]

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

[@hellodanooo]

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.*

[@hellodanooo]

now its just working now haha!! jeez giving me a panic attack

[@Irfan9191111]

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?

[@haihuynhthanh3078]

Great! thanks very much!

[@myEPublic]

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]

You could do an IF statement that would produce different base target depending on dev or exec version.

[@myEPublic]

@@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'."

[@ignaciopolo8321]

me encanta eres una maquina bro

[@bostjanbesednjak5710]

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.

[@paulominorinagakijunior9681]

this concept you want.. is in video 5.. search a match! :)

[@feroscyp8250]

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??

[@rahamanvalaja1039]

Upto this it is possible, but once google site connect custom domain ,it showing error message in online view "scrip refuses to connect "

[@revenramirez9715]

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

[@ConsulthinkProgrammer]

in your code.gs, write: var url= ScriptApp.getService().getUrl();

[@dpg6188]

Are there security vulnerabilities that come with the AllowAll method?

[@kensleylewis]

Setting XFrameOptionsMode.ALLOWALL will let any site to the page, so the developer should implement their own protection against clickjacking.

[@genrmx]

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?

[@gothamfury]

Could you have also set the height to 100%? Just wondering why you chose to set it to 500px instead.

[@netboy1102]

Height="100%" does not work in tag. You can use css to set it to 100vb

[@josepalemany4299]

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!!!

[@gbarnabic]

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?

[@gbarnabic]

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]

You want to make sure you deploy it as a new version in addition to just changing "Anyone, even anonymous".

[@gbarnabic]

@@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.

[@ExcelGoogleSheets]

you mean this? developers.google.com/picker/

[@gulmathuzunseven6561]

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]

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.

[@gulmathuzunseven6561]

@@ExcelGoogleSheets Yes.. All pages target base _self... Google Script works on returns without IFRAME. But it doesn't work on Google sites within IFRAME...

[@ilargelo]

@@gulmathuzunseven6561 same problem here.. whenever i click the go back button. the page is blank.

[@ismailkhurram]

same problem

[@gauravesondhi4548]

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

[@rachidbeggar711]

Thank you so much!

[@nunomarques6106]

i have followed example and created an html file but page is blank. What could be wrong?

[@joaopaulosoares1]

is it possible to create a login screen and password to enter the form?

[@jonas6799]

How do you switch between home.html and page.html in one script?

[@kamalam29]

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.?

[@ExcelGoogleSheets]

check your bases for each page and link target properties and adjust them accordingly.

[@marcosrs75]

Best worksheets KZbin 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! :)

[@efrianmh]

Hi, try to use this : docs.google.com/spreadsheets/d/[your ss id]/edit?rm=minimal#gid=0

[@themoshem]

*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?

[@ExcelGoogleSheets]

I don't know, what's your script?

[@hasan73996]

Thank you for the useful video. May I ask for the results of the Google Apps Script Web App. thank you for your kindness.

[@cuaran89]

Yeahhhhhhhhhhhhh!!!!!! Thanks a lot !

[@limbuscode]

I'd like to embed the code at google sites but with mobile responsiveness, how do i do it?

[@limbuscode]

let tmp = HtmlService.createTemplateFromFile(file); return tmp.evaluate() .addMetaTag('viewport', 'width=device-width, initial-scale=1'); // It is very important tag for Responsive;

[@ExcelGoogleSheets]

Cool, looks like you have the answer.

[@waqarahmad1651]

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.

[@ExcelGoogleSheets]

Make sure you deploy a new version under right permission and then share that link with them.

[@waqarahmad1651]

@@ExcelGoogleSheets Thanks boss

[@robinlioret7808]

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...

[@ConsulthinkProgrammer]

it to netlify, for an alternative.

[@robinlioret7808]

@@ConsulthinkProgrammer I'll try it, thanks !

[@ConsulthinkProgrammer]

@@robinlioret7808 you're welcome. You could check my video about create website with apps script and netlify, maybe that will give you some clue.

[@ABsazerNer]

Working in JavaScript is more exciting than VBA

[@ExcelGoogleSheets]

I have to agree. Especially when you need to work with arrays.

[@mrchoe7338]

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

[@faceoff7875]

Hello, after embedding the working code in google site, my dynamic dependent dropdown stops working for unknown reasons. Have I missed anything here?

[@ExcelGoogleSheets]

I can't guess, check your console log.

[@faceoff7875]

@@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

[@ExcelGoogleSheets]

@@faceoff7875 Well, how did you deploy the app as far as who can access it?

[@faceoff7875]

@@ExcelGoogleSheets Issue solved after changing the execution access from any user to the web app owner. Thank you for your help.

[@ignaciopolo8321]

HELP ME! i can use only on Microsoft Edge, cant on Google Chrome

[@pichit.raetai]

Thank you

[@hamhumtube]

Please share your script to make copy thanks in anticipation

[@Anzeljaeg]

grat series thanks

[@RedElectrik]

Google sites seems to be gone now, I used netlify instead

[@ExcelGoogleSheets]

sites.google.com

[@matusalemdamarin4060]

[@bitztrail4340]

How to show a pop up once we click the button

[@paulominorinagakijunior9681]

M.toast({html: 'I am a toast!'})

[@lararawf6100]

God bless you

[@proferodiana]

Thank !!!

[@mayursawant7992]

Sir please create to submited name, email and number then redirect thank you page how to make sir please help me

[@adityamundra3699]

Amazing

[@highlycurious]

Thanks

[@KuldeepSingh-pl7rv]

this is not working on incognito mode right ?

[@ExcelGoogleSheets]

Won't work if you deploy the app and require for the user to be logged in. Otherwise it should work fine.

[@ConsulthinkProgrammer]

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...

[@feroscyp8250]

awesome

[@aJayBoulder]

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.

[@ExcelGoogleSheets]

I believe that you still get that message on paid accounts. Maybe somebody with experience can confirm.

[@samdavies6458]

I can confirm, I am a GSuite user and still get that message

[@francismata4492]

it doesn't work.

[@tomstonede]

Refused to display 'script.google.com/macros/s/AKfycbzdFQxUebj3obF6Qde6R-BqlPcFTAuyfZSWXjNR7X9I/dev?v=form' in a frame because it set 'X-Frame-Options' to 'sameorigin'.

[@ExcelGoogleSheets]

did you do this? developers.google.com/apps-script/reference/html/html-output.html#setXFrameOptionsMode(XFrameOptionsMode)

[@jetanasomkamnueng1566]

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?

[@sycfiles6172]

i hope google wont block my form for this

[@csprgsio]

Read my previous comment... A login system like this video kzbin.info/www/bejne/Zmiaf4F-haaqmZI 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 :)

[@ExcelGoogleSheets]

Creating a secure login system is not a simple task. You can make something like this that works but it will hardly be secure.

[@csprgsio]

Gotcha thank you for the reply much appreciated 👍

[@rightangle1946]

Boss all of your videos are awesome. how does it show in by "?v=form"

[@lararawf6100]

God bless you