Google Sheets Userform - Server Side (Back-End) vs Front-End, google.script.run Apps Script
HTML-код
- Опубликовано: 5 окт 2024
- Code review. Server-Side (aka Back-End) vs Front-End.
How it all works and how we use google.script.run.
This tutorial is Part 9 from Google Sheets Userform - Level 2 series
• Google Sheets Userform...
#userform #form #serverside #frontend
We’ve been able to make so many awesome tools for our business and our industry. Love all the insights that I gain from your trainings with Google sheets
Tnank you for additional explanation server-client scheme.
Man this is amazing!!! I have been watching the serie and the content is very good!! THANK YOU SO MUCH :)!!!!!!!
By far my most interesting channel. Please keep on doing these great GAS lessons.
Also, more examples with bootstrap and JavaScript would be interesting.
Do you have patreon?
Thank You! Here is Patreon www.patreon.com/chicagocomputerclasses
Explaining theory is an awesome idea!
Though it was all clear before - this video is still priceless. Thanks for all the practical know how!
Please do some others explaining things like this of how interact functions
Thank you for the insightful explanation. Could you please do a lesson with a stand alone script accessing a Spreadsheet with SpreadsheetApp method (but without keying in the sheet id in the script)?
great series.. can u share the gs and html code so far?
Hi, I've been trying to use google.script.run to call my server-side functions but it always fails.
Under my executions type, every server function I've tried to run always has an "unknown" type and 0s execution time. Please Help!
Could you explain in one video, how is the logic to pass a var from one fx to other
Is difficult for me to understand this. Thank you, i love your videos
I want to thank you once again for your videos. I am waiting for the video you told me that you would make about how to delete a row in a google sheet. In my case, I use google form to create and add new rows to a google sheet, and I also edit rows of the google sheet by google form, in this case by a link that allows me to edit and update an specific row. What is missing for me is to delete a row. Thanks for your help.
It will be most likely published on the new channel once it's ready.
@@ExcelGoogleSheets great to hear that. Looking forward to it
WOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW
I just Love how you make everything so effortless. 10/10. Thank you sir
Thank you, very usefull to know how it work
How are you so underrated!
Thank You!
First of all, let me thank you a lot. Without your videos it wouldn't be possible for me to create this type of form.
I have a question. I am having a shared Spreadsheet. I am owner and others are editors. I have prepared a form. It runs good for me. When other editors try to run it once it asks for permission, then it should run, but it didn't run and shows some permission error in console "inspect" in Google Chrome.
How can we draw these permissions to clients side, so that they can access those errors or permissions directly without looking into console log. Please give some ideas.
I have question: How do i use Google sheet to create a rotating schedule. I have a team of 7 and each week we huddle. I am looking to creating sometime that sequentially picks the next person to lead based on the person who led last. Any ideas what approach to use on Google sheet? Thanks
Hi,
I just need to know how do I update a row in future.
Example: I have entered order details in a row, during materials' dispatch time, I have to add extra details to that existing row - like Bill number, dispatch details,etc
do you have a vid bout selecting multiple items and save the text or data in a single cell
Thank you !
Thanks a lot
Hey man, thanks for this a lot, I am curious. can we build a timer that tracks activity when a user act on the sheet? for example, if a user edits on the sheet it will record it and if not it will stop recording
or a stopwatch that calculates whenever the user is active on the sheet and typing or editing then when the user is inactive or not typing it stops recording, the point is building a productivity tool to measure the time the user was acting.
Within the Web App it should be possible. Within the spreadsheet it would be I suppose still possible but more complicated.
@@ExcelGoogleSheets can you please guide me through it?
This is really complicated if you're not already a programmer.
@@ExcelGoogleSheets i know the basics and can play around, just like I asked you for the built in translation and I made it. So i know how to create the timestamps and log it but i need to know the code of record the time spent on a cell
When do I use createHtmlOutputFromFile vs createTemplateFromFile?
if you want to use scriptlets then use createTemplateFromFile
More info here ruclips.net/video/f9dqsHDrQCc/видео.html
Maybe it's this one ruclips.net/video/1toLqGwMRVc/видео.html
instead of calling "getActiveSS" everytime wouldn't it be better to openByID and make it a global variable?
It will be moved in the last video.
@@ExcelGoogleSheets i see. Nice!
You are awesome! I have learned a lot from your videos and made a complex web application with apps script. Then, when many users use it at the same time, it shows many errors from server side; Get http:\\~~~ 500 error, uncaught error, we're sorry, a server error occurred. I assume that it's because I used too many google.script.run and make it run too many times. Can it be the right guess?
Is it better to use "google.script.run" as less as possible?
Then, I may make one big function in server side and make it run less times from front end.