Hi, I'm from Brazil, and I'm learning spreadsheets, google app script (javascript) with you guy. I need to give you a huge thank you or "muito obrigado" (in portuguese). You've done an amazing job with these videos. Congratulations!
You're a savior, this playlist alone is enough for a beginner to know everything about Gsuite scripting. Big 👍Thumbs up!! 👍 Thanks from Hyderabad, India
Man, I really like spreadsheets. I use it a lot, specially for my expenses. But with the things that I’ve been learning from your videos makes me love spreadsheets even more!!!! It is amazing how we can do some things even better. Thanks for that!!!
And again, your video proved to be of great value! I didn't know about HTML templates and printing scriptlets. That's exactly what I was looking for. Thank you!
Could anyone help me with the part in 12:20? I'm having trouble with the javascript part. when I type into the a href tag, it doesn't seem to call the javascript, the actual text displays in red. When I click on the link from the web page, it directs me to an error page under Google Drive while the address bar displays the original url without the variable at the end. Been stuck here for 2 days...
A lot of people suggest to add within the html . Didn't 100% fix for me as part of my page uses the include() from previous videos for my navbar, its turning the URL into something odd, when I grabbed it and put it in the index page it works fine though
same here. the js does not work like in the video when Scriptapp is typed inside the href="". but when I typed it outside it, the appscript showing the suggestion like in the video. I got ReferenceError: Scriptapp is not defined when loaded the page. anyone solved this problem?
hello... Im having a problem with Forbidden Error 403, when i try access script url from a href clicable div , or href from navbar, or using .... how can i solve??? im made a simple page and works, but when i increase the code with a many div and images and navbar, this error appear, preview answer:Failed to load response data: No resource with given identifier found; payload receive correct parameter v, and Route code its correct. im trying find some answer in google, but, no luck.... PS: If i choose to open a new window, works fine, but in the same window i have this problem. PS 2: Worked with ---> target="_top"
Thank you for your great videos! Is there any option to create dynamic link based on user input? I tried to update href value but it doesn't work for some reason...
Hi @ExcelGoogleSheets ,great work and tutorial. I am having issues with my , is not giving me the desired result you have. i am getting a error of abnormal html. Please how can i fix it
Hi, Im useing this tutorialin 2024. Im getting an error says tells me I need permission when trying to open the link in the href anchor. I can't Think why. Any thoughts?
Thank you very much for your videos! I very much appreciate it. I have one question may be you can help with: Do you know a way to build template parts as Wordpress do in a google app like this. I tried to create several template parts - header.html, content1.html etc- and include it in a main "index.html" page as a single web app would do, but when I use - in all its variants - in the template part html page just prints the flat text. Ex: would print the same instead of the content of the list. Is there any option to include these scripts in the template parts in a way to be rendered in the main index page? Thanks again!
just one issue of script.google.com refused to connect, links not working how can I resolve this to toggle between pages I did the same thing u have her but am getting an error here
Hello. Does yours, when after click the button, goes to another link instead of supposed link? I ran into the same issue. Hopefully there's another way to solve the multiple pages linking.
Everything is OK but I am also getting Forbidden 403 error when I am clicking on the element but if we are manually putting the parameter in the address bar it is navigating to that page. Please help on this topic as I have worked a lot on my project and it is not completed only due to this navigating between views.
Great material, and you are very helpful sir! I have one more question: How to give-get access to developers to make the web app for the client (person). Is there a "developer access", that lets me as a dev into my client's account, so that i can work on their app, but I cannot access personal information like mails, etc. which is not related to the actual app.?Something like that exists in Google play. Thanks! Greg
thank you very much for you effort on this series i have a question how can i make conditional movement to another page for example in input==value go to some page and if not go to another i want to make login window please somebody help me
I'm also working with log in log out system with the Web App. Though I'm currently working on it, my current solution right now is using the localStorage to store the username and password of the person. If the person tries to short cut the log in system using the url. the program will first check if the localStorage parameters contain a user name or a password else it will redirect it to the log in system page.
Thanks for your helpful tutorials! I have used your framework in "Basic WebApp" and would like to add a "Cancel" button to each of my pages to allow user to abandon their entry. So far, I have been unsuccessful in "ending" the script. I have tried a simple return; as well as window.close(); In each case, the button is activated but the current page remains displayed and active. What I would like is essentially for the WebApp to "close". Is this possible?
Awesome.. and very clear.. however, need just one help😀how to open another html page after clicking on the button (example a page that displays a "thank you, OK") Thank you in advance for your help
Super awesome tutorials!!! You are doing a great job teaching really well how to build web applications. I am using the series of these videos to build a custom page where I wanted to make a "menu bar" which would redirect me to different pages. In order to make the menu bar same to all pages, I created a new html file where I have the html code of my menu and I include this page with your method on the top of each page. The menu bar displays correctly but the links do not work in this way. I get actually this error "The requested URL was not found on this server.". Is there something I am missing? Cheers,
@@ExcelGoogleSheets Hi there and many thanks for your quick response. I had already seen that video and I was thinking the same as a reason of this issue. I will explore more. Thanks again
Hi your tutorial is really great! I badly needed help though. I have been pulling hairs to make my render to call a new page after completing the validation. I wanted to keep my userInfo object to be rendered to another form where additional entry details may be asked from the user. I can't seem to make the webapp open a new page like "return render(table);" I have commented out my write array and put in there loadTable() or return render(table); but it seems I am stuck. I don't know how to incorporate additional function that will call table after "e.parameters.v=table". Any ideas please.
I used a HTML form to ask for a user input before redirecting to another page. but I couldn't add the '?v=form' part to the link. if i use action=link, the link return just "link?" -> still go to the same page. if I use href with the form, it'd just wouldnt work, itd redirect me to some other page. Can you help me fix the option using a form?
Hello! I got ReferenceError: Scriptapp is not defined. Is there something that I missed? I am skipping the previous video on Integrate google calendar.
Do you have a file upload video? Looking to upload a file to a specific folder in Google Drive, Name the file based on another input (such as first/last name), and get the url to the spreadsheet. I've seen a few other videos on how to do this but your videos are SOOOOOO much better!! Thanks for taking the time to do them!
@@ExcelGoogleSheets I hope this is coming soon!!!! I can do following this video (th-cam.com/video/OU2FAzC04fM/w-d-xo.html) but having trouble implementing to what I've created using your videos.
your videos are verymuch helpful. I am self thought by reading and watching videos like yours. However, I am having problem with my current project. Can you help me? I will really appreaciate that.
Hi, the code hasn’t worked for me. I’m getting by by just copy-pasting the link into my code, but it’s not ideal. Is there a reason the thing isn’t working? Thanks
@@ExcelGoogleSheets Hey, okay so I tried again with the spaces, this is what I get when I click the button: (I’m using ?v=game, also I didn’t implement your videos parts 3, 4, 5 or 6) accounts . google . com/ServiceLogin?service=wise&passive=1209600&continue=https%3A%2F%2Fn-23poltc2nbk36h6ehzfc6k4nr3orn5puj5i3zhy-0lu-script.googleusercontent.com%2F%253C%3F%3D%2BScriptApp.getService%2528%2529.getUrl%2528%2529%2B%253F%253E%253Fv%253Dgame&followup=https%3A%2F%2Fn-23poltc2nbk36h6ehzfc6k4nr3orn5puj5i3zhy-0lu-script.googleusercontent.com%2F%253C%3F%3D%2BScriptApp.getService%2528%2529.getUrl%2528%2529%2B%253F%253E%253Fv%253Dgame
Awesome.. and very clear.. however, need just one help.. once we embed this app to our own website, why browser back does not work the way it should.. it just returns blank page instead of returning the last page/view
well is it possible if someone directly put form link url then its render again to first page and ask for login something i mean i trying to do user authentication kind of stuff with apps script without login if someon put this form link wont be able to access i thing this is not possible in apps script right ???
Hi Sir When I'm trying to do this it gives me a 'FORBIDDEN 403 Error'... how can I solve that? when i paste the link on the browser it works, but when i paste it on the script href, it gives me that error
Is there a way to do this with out using internet. Like using google sheets off-line. I am trying to make a receipt per customer. I like to do off line
Theoretically you can build an application to cache the data in Google Sheets and use it offline and then sync with Google Sheets when connected. That being said, this will be very complicated application, so practically no unless you are a programmer with a lot of experience. Maybe use Excel with a User Form and get some addon that will sync it with Google Sheets when you're online.
Excellent Tutorial. I made a webApp following this. But now, when I create a new webApp , the link to load another page not working. it gives error. Forbidden Error 403. When I manually enter the parameter to url it works. Also when it is deployed as exec ,then also it works. But on Test deployment it gives error. Can any one Help?
dev version of web app seems to work (with and without get parameters) but the exec published version, will not load with or without parameters, I only get error page: The script completed but did not return anything. any ideas?
Does anybody know how to add event / script to close the chrome tab as the web page is generated by google script engine and the actual web page is placed inside an
Hey Thanks for yet another excellent tutorial.. However finding some difficulty in the logic when trying to embed the webapp in my website.. in spite of passing the right url (url+?v=form), the page loaded is blank.
Excellent tutorials, only adding the link to a view, ah I think google change some.....idk not working, working on a solution.....maybe someone knows ;)
@@ExcelGoogleSheets thank you it work after I move it to main page. previously I place it in header section and call the header with include function. again.. thank you.
Hola gracias por tus videos, he seguido el video paso a paso como ejercicio y a pesar de tener el mismo código no puedo hacer que el botón active el hiper vinculo, por que puede ser? agradezco la ayuda
Figured this out! Hallelujah!! Changed the line in the "addRecord" function to this: google.script.run.withSuccessHandler(fileUploaded).userClicked(userInfo); and created this function: function fileUploaded() { window.location = 'script.google.com/macros/s/####/exec?v=success'; } (replace #### above with your web app's ID and replace "success" with the name of your html page you would like to redirect to)
@@ExcelGoogleSheets yes sir I'm watching but my problem is make a form and name and email submite after redirect to thank you page and get to data in automatically google sheet but code not run
this is the error that appears to me, when from the home I navigate to "page": @@ExcelGoogleSheets userCodeAppPanel:1 Refused to display 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/dev?v=form' in a frame because it set 'X-Frame-Options' to 'sameorigin'.
thank you I had made the mistake of deleting the target = "_ top" tag, which works from Restrictions in IFRAME mode. Attached respective documentation: developers.google.com/apps-script/guides/html/restrictions
Hi sir! Good day! I tried to embed my multiple pages app in my google sites. But i got this error. Unsafe JavaScript attempt to initiate navigation for frame with origin 'sites.google.com' from frame with URL 'n-lh2mnltn4dks2vtzdsdqfhwwegdvhi6itgjcyli-0lu-script.googleusercontent.com/userCodeAppPanel'. The frame attempting navigation of the top-level window is sandboxed, but the flag of 'allow-top-navigation' or 'allow-top-navigation-by-user-activation' is not set. base target was set to _self. Thank you..
I used “ScriptApp.getService().getUrl(); …” in href to link to another page. After I click the button contain that link, the page show “Forbidden error 403”. So, how can I fix this TT.
Hi, I'm from Brazil, and I'm learning spreadsheets, google app script (javascript) with you guy. I need to give you a huge thank you or "muito obrigado" (in portuguese). You've done an amazing job with these videos. Congratulations!
You're a savior, this playlist alone is enough for a beginner to know everything about Gsuite scripting. Big 👍Thumbs up!! 👍 Thanks from Hyderabad, India
Man, I really like spreadsheets. I use it a lot, specially for my expenses. But with the things that I’ve been learning from your videos makes me love spreadsheets even more!!!! It is amazing how we can do some things even better. Thanks for that!!!
Absolute brilliant tutorials! It's really opening my mind.
Great job, please add more and more web app videos!
And again, your video proved to be of great value! I didn't know about HTML templates and printing scriptlets. That's exactly what I was looking for. Thank you!
Could anyone help me with the part in 12:20? I'm having trouble with the javascript part. when I type into the a href tag, it doesn't seem to call the javascript, the actual text displays in red. When I click on the link from the web page, it directs me to an error page under Google Drive while the address bar displays the original url without the variable at the end. Been stuck here for 2 days...
Same, I think something must have changes since this tutorial was made
A lot of people suggest to add within the html . Didn't 100% fix for me as part of my page uses the include() from previous videos for my navbar, its turning the URL into something odd, when I grabbed it and put it in the index page it works fine though
Seems you can't use skriptlets in any files you call using the include so guess that means I'm making many many nav bars
U need to set this in doGet(): return HtmlService.createTemplateFromFile('index').evaluate();
It is important to add .evaluate()
same here. the js does not work like in the video when Scriptapp is typed inside the href="". but when I typed it outside it, the appscript showing the suggestion like in the video. I got ReferenceError: Scriptapp is not defined when loaded the page. anyone solved this problem?
Muito bom!
Very...very good!
As always, I'm learning a lot!
Once again, great video. Thanks.
Thank you very much !!
excellent video
Awesome!!! Keep publishing😊
hello... Im having a problem with Forbidden
Error 403, when i try access script url from a href clicable div , or href from navbar, or using .... how can i solve??? im made a simple page and works, but when i increase the code with a many div and images and navbar, this error appear, preview answer:Failed to load response data: No resource with given identifier found; payload receive correct parameter v, and Route code its correct. im trying find some answer in google, but, no luck.... PS: If i choose to open a new window, works fine, but in the same window i have this problem.
PS 2: Worked with ---> target="_top"
thank you. Finally worked
I can’t thank you enough for this. Do you have a patreon where we can support you.
www.patreon.com/chicagocomputerclasses
Fantastic video. Thanks
I love you for making this
if we add another tage inside the form to return to home; what should we do? what "URL" should be used inside href.
You must be super teacher .
Thank you for your great videos!
Is there any option to create dynamic link based on user input? I tried to update href value but it doesn't work for some reason...
I have exactly the same question over here... Did you figure this out?
Hi @ExcelGoogleSheets ,great work and tutorial. I am having issues with my , is not giving me the desired result you have. i am getting a error of abnormal html. Please how can i fix it
Make sure you use CreateHtmlFromTemplate method.
didn't go to next "form" page what to do ? thks...
In case you haven't found an answer somewhere else, I got it to work by putting target="_top" on the link.
Thanks. It saved my nerves 👍
Hi, Im useing this tutorialin 2024. Im getting an error says tells me I need permission when trying to open the link in the href anchor. I can't Think why. Any thoughts?
Same here
put
target="_top" attribute
in the element
@@snwlms Thanks so much! I have been trying to solve this problem for hours and it worked instantly
Thank you very much for your videos! I very much appreciate it.
I have one question may be you can help with: Do you know a way to build template parts as Wordpress do in a google app like this. I tried to create several template parts - header.html, content1.html etc- and include it in a main "index.html" page as a single web app would do, but when I use - in all its variants - in the template part html page just prints the flat text. Ex: would print the same instead of the content of the list. Is there any option to include these scripts in the template parts in a way to be rendered in the main index page? Thanks again!
just one issue of script.google.com refused to connect, links not working how can I resolve this to toggle between pages I did the same thing u have her but am getting an error here
How can I connect to different worksheets depending on the parameter? I mean, for every parameter I want to connect to a different worksheet
Excuse me Sir, i followed this tutorial which are very helpul but the pages not linking why?
Hello. Does yours, when after click the button, goes to another link instead of supposed link? I ran into the same issue. Hopefully there's another way to solve the multiple pages linking.
Only the first page switch works. Lots of comments about this. Please tell us where the problem is.
dear sir, the following does not work. Please help.
I had the same problem and i added this and it well work
@@mohamedsaidani7621 Thanks a lot. ❤️❤️❤️
@@mohamedsaidani7621 sorry if im being a bit of an idiot here but where are you adding ?
@@mohamedsaidani7621 thank you! now it works
Everything is OK but I am also getting Forbidden 403 error when I am clicking on the element but if we are manually putting the parameter in the address bar it is navigating to that page. Please help on this topic as I have worked a lot on my project and it is not completed only due to this navigating between views.
Great material, and you are very helpful sir! I have one more question: How to give-get access to developers to make the web app for the client (person). Is there a "developer access", that lets me as a dev into my client's account, so that i can work on their app, but I cannot access personal information like mails, etc. which is not related to the actual app.?Something like that exists in Google play. Thanks! Greg
So say you login how do you code your way to the home page? Given a login button in a login page, how do I get the user to the other page????
thank you very much for you effort on this series
i have a question
how can i make conditional movement to another page
for example in input==value go to some page and if not go to another
i want to make login window
please somebody help me
I'm also working with log in log out system with the Web App. Though I'm currently working on it, my current solution right now is using the localStorage to store the username and password of the person. If the person tries to short cut the log in system using the url. the program will first check if the localStorage parameters contain a user name or a password else it will redirect it to the log in system page.
Thanks for your helpful tutorials! I have used your framework in "Basic WebApp" and would like to add a "Cancel" button to each of my pages to allow user to abandon their entry. So far, I have been unsuccessful in "ending" the script. I have tried a simple return; as well as window.close(); In each case, the button is activated but the current page remains displayed and active. What I would like is essentially for the WebApp to "close". Is this possible?
Awesome.. and very clear.. however, need just one help😀how to open another html page after clicking on the button (example a page that displays a "thank you, OK")
Thank you in advance for your help
For multipage/view setup check out CRUD tutorial series.
Thank you
i am using nav bar and i am not able to go back to the home page is there any way to go back
Super awesome tutorials!!! You are doing a great job teaching really well how to build web applications.
I am using the series of these videos to build a custom page where I wanted to make a "menu bar" which would redirect me to different pages. In order to make the menu bar same to all pages, I created a new html file where I have the html code of my menu and I include this page with your method on the top of each page. The menu bar displays correctly but the links do not work in this way. I get actually this error "The requested URL was not found on this server.". Is there something I am missing?
Cheers,
Watch the video where I cover how to deploy the app.
It probably has something to do with base target
@@ExcelGoogleSheets Hi there and many thanks for your quick response. I had already seen that video and I was thinking the same as a reason of this issue. I will explore more. Thanks again
@@erisi Hi Eris!! Did you find the solution? I have the same issues? Can you help me?
@@CesarAndreotti change to this: ""
Hi your tutorial is really great!
I badly needed help though. I have been pulling hairs to make my render to call a new page after completing the validation.
I wanted to keep my userInfo object to be rendered to another form where additional entry details may be asked from the user. I can't seem to make the webapp open a new page like "return render(table);"
I have commented out my write array and put in there loadTable() or return render(table); but it seems I am stuck.
I don't know how to incorporate additional function that will call table after "e.parameters.v=table".
Any ideas please.
I used a HTML form to ask for a user input before redirecting to another page. but I couldn't add the '?v=form' part to the link. if i use action=link, the link return just "link?" -> still go to the same page. if I use href with the form, it'd just wouldnt work, itd redirect me to some other page. Can you help me fix the option using a form?
Why if we use v === "form" it odes not load the form? But it works with ==. Why?
That's a good question. I would think that it would load with === as well.
Hello! I got ReferenceError: Scriptapp is not defined. Is there something that I missed? I am skipping the previous video on Integrate google calendar.
it's case sensitive.
@@ExcelGoogleSheets Thank you!!!
Thank you for your great videos!
Please create a login video by logging in first to this page.
Do you have a file upload video? Looking to upload a file to a specific folder in Google Drive, Name the file based on another input (such as first/last name), and get the url to the spreadsheet. I've seen a few other videos on how to do this but your videos are SOOOOOO much better!! Thanks for taking the time to do them!
Sorry, no file upload video.
@@ExcelGoogleSheets I hope this is coming soon!!!! I can do following this video (th-cam.com/video/OU2FAzC04fM/w-d-xo.html) but having trouble implementing to what I've created using your videos.
@@ExcelGoogleSheets Another question - how would I incorporate javascript to automatically scroll to top on button clicks?
@@ExcelGoogleSheets why everwhere is full of file upload. why not you make one
your videos are verymuch helpful. I am self thought by reading and watching videos like yours. However, I am having problem with my current project. Can you help me? I will really appreaciate that.
Hi, the code hasn’t worked for me. I’m getting by by just copy-pasting the link into my code, but it’s not ideal. Is there a reason the thing isn’t working?
Thanks
First make sure there is a space
There is a good chance your error is someplace else, but it's impossible to tell from your comment.
@@ExcelGoogleSheets Hey, okay so I tried again with the spaces, this is what I get when I click the button: (I’m using ?v=game, also I didn’t implement your videos parts 3, 4, 5 or 6)
accounts . google . com/ServiceLogin?service=wise&passive=1209600&continue=https%3A%2F%2Fn-23poltc2nbk36h6ehzfc6k4nr3orn5puj5i3zhy-0lu-script.googleusercontent.com%2F%253C%3F%3D%2BScriptApp.getService%2528%2529.getUrl%2528%2529%2B%253F%253E%253Fv%253Dgame&followup=https%3A%2F%2Fn-23poltc2nbk36h6ehzfc6k4nr3orn5puj5i3zhy-0lu-script.googleusercontent.com%2F%253C%3F%3D%2BScriptApp.getService%2528%2529.getUrl%2528%2529%2B%253F%253E%253Fv%253Dgame
@@ExcelGoogleSheets is there anything else I could tell you that would help?
This is the hyperlink code I’m using:
Did you deploy the app at any point?
Form doesn't open after pressing the "add record" button.
Wow. Now imagine tying multiple projects together via their Web App URLs...
Awesome.. and very clear.. however, need just one help.. once we embed this app to our own website, why browser back does not work the way it should.. it just returns blank page instead of returning the last page/view
I think its cos web app is in . You need to create back button in web app for this functionality.
well is it possible if someone directly put form link url then its render again to first page and ask for login something i mean i trying to do user authentication kind of stuff with apps script without login if someon put this form link wont be able to access i thing this is not possible in apps script right ???
Hi Sir
When I'm trying to do this it gives me a 'FORBIDDEN 403 Error'... how can I solve that?
when i paste the link on the browser it works, but when i paste it on the script href, it gives me that error
Is there a way to do this with out using internet. Like using google sheets off-line. I am trying to make a receipt per customer. I like to do off line
Theoretically you can build an application to cache the data in Google Sheets and use it offline and then sync with Google Sheets when connected. That being said, this will be very complicated application, so practically no unless you are a programmer with a lot of experience.
Maybe use Excel with a User Form and get some addon that will sync it with Google Sheets when you're online.
Im getting error 403 on loading the view :(
put this inside a href tag target="_top"
@@tennisfansfans thank you for this
Excellent Tutorial. I made a webApp following this. But now, when I create a new webApp , the link to load another page not working. it gives error. Forbidden Error 403. When I manually enter the parameter to url it works. Also when it is deployed as exec ,then also it works. But on Test deployment it gives error. Can any one Help?
I have the same problem
You're probably missing the
Tag in the head ...
dev version of web app seems to work (with and without get parameters) but the exec published version, will not load with or without parameters, I only get error page: The script completed but did not return anything. any ideas?
nvm.. was not publishing and saving a new version. duh
Is there a way to download spreadsheet and pull excel data to G-sheet? Thanks in advance!
The short answer is yes.
Please share any code sample or let me know if there is any dedicated video on this. My current organisation in need of it.
how to make the web app compatible with iphone screen
How to Show Popups and warning windows . like in sheet UI with html service
Does anybody know how to add event / script to close the chrome tab as the web page is generated by google script engine and the actual web page is placed inside an
How I can open page.html from javascript client side? any help ? Thanks
Watch this th-cam.com/play/PLv9Pf9aNgemvM36efLpaHxbkZTGp2pfhx.html
If I embed a solution similar than this one in new Sites, appears something like "Connection refused". What can It be?
Maybe check this th-cam.com/video/RJtaMJTlRhE/w-d-xo.html
Hey Thanks for yet another excellent tutorial.. However finding some difficulty in the logic when trying to embed the webapp in my website.. in spite of passing the right url (url+?v=form), the page loaded is blank.
Please watch the video how to deploy the app.
Also his video about setting was super helpful for me: th-cam.com/video/RJtaMJTlRhE/w-d-xo.html
Excellent tutorials, only adding the link to a view, ah I think google change some.....idk not working, working on a solution.....maybe someone knows ;)
. can u create a video update about this issue. thank you.
I've just used it yesterday, so it definitely works.
Make sure your HtmlService is using Template methods.
@@ExcelGoogleSheets thank you it work after I move it to main page. previously I place it in header section and call the header with include function. again.. thank you.
Não sei o que acontecesse que não abre, se colar o link ok, mas via click não funciona.
Hola gracias por tus videos, he seguido el video paso a paso como ejercicio y a pesar de tener el mismo código no puedo hacer que el botón active el hiper vinculo, por que puede ser? agradezco la ayuda
How to redirect a custom page (thank-you.html) after Google form submission?
use onSuccessHandler function to redirect.
@@ExcelGoogleSheets can you add this to your video list? I have tried implementing the onSuccessHandler function but to no avail.
Figured this out! Hallelujah!!
Changed the line in the "addRecord" function to this:
google.script.run.withSuccessHandler(fileUploaded).userClicked(userInfo);
and created this function:
function fileUploaded() {
window.location = 'script.google.com/macros/s/####/exec?v=success';
}
(replace #### above with your web app's ID and replace "success" with the name of your html page you would like to redirect to)
Well, spoke too soon...works in the script/dev view but not on view....back to drawing board.
Sir please create to submit after redirect to thank you page how to make using google apps script
Watch my CRUD series for an example.
@@ExcelGoogleSheets yes sir I'm watching but my problem is make a form and name and email submite after redirect to thank you page and get to data in automatically google sheet but code not run
Try to run it separately in a function first. You may need to grant permissions in order for it to work.
this is the error that appears to me, when from the home I navigate to "page": @@ExcelGoogleSheets userCodeAppPanel:1 Refused to display 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/dev?v=form' in a frame because it set 'X-Frame-Options' to 'sameorigin'.
thank you I had made the mistake of deleting the target = "_ top" tag, which works from Restrictions in IFRAME mode. Attached respective documentation: developers.google.com/apps-script/guides/html/restrictions
Great!
@@ExcelGoogleSheets How do you go about running separately in a function? I keep getting "sorry, unable to to open the file at this time" error.
Hi sir! Good day! I tried to embed my multiple pages app in my google sites. But i got this error.
Unsafe JavaScript attempt to initiate navigation for frame with origin 'sites.google.com' from frame with URL 'n-lh2mnltn4dks2vtzdsdqfhwwegdvhi6itgjcyli-0lu-script.googleusercontent.com/userCodeAppPanel'. The frame attempting navigation of the top-level window is sandboxed, but the flag of 'allow-top-navigation' or 'allow-top-navigation-by-user-activation' is not set.
base target was set to _self. Thank you..
Base target should be _top if you're not iframing it.
@@ExcelGoogleSheets Hi Sir. It worked. But only for once. After i clicked another link, the parameter will change but the page will not.
complete opacity sorry idiocy that you did not share your script file to be copied.
I used “ScriptApp.getService().getUrl(); …” in href to link to another page. After I click the button contain that link, the page show “Forbidden error 403”.
So, how can I fix this TT.
put this inside a href tag target="_top"
Is there a repository for the basic web app?