Тёмный

Google Sheets Web App Deployment Process - Apps Script V8 

Learn Google Sheets & Excel Spreadsheets
Подписаться 278 тыс.
Просмотров 30 тыс.
50% 1

Опубликовано:

 

22 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 54   
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
Watch Full Web App Series ru-vid.com/group/PLv9Pf9aNgemt82hBENyneRyHnD-zORB3l Google Sheets Userform Wep App Level 2 ru-vid.com/group/PLv9Pf9aNgemuzTNWeHd8HziGVNzSlWACh CRUD Web App Series ru-vid.com/group/PLv9Pf9aNgemvM36efLpaHxbkZTGp2pfhx
@trappedcat3615
@trappedcat3615 2 года назад
There is so much one can do with apps script. It's a hidden gem. I use it as an API service.
@ighsight
@ighsight 2 года назад
It's so good you wonder why Google hasn't killed it yet.
@leeedwards8071
@leeedwards8071 2 года назад
I really enjoy your videos on web apps, especially the ones where you show how to connect web apps to google sheets, data transfer both ways. Brilliant.
@avantiya
@avantiya 2 года назад
Very good informative. Please add a video to publish a sheet editor add-on on Google Workspace, and the whole process of preparing a project on Google Workspace and then to publish it public.
@NeerajKumar-hn1pn
@NeerajKumar-hn1pn 2 года назад
Thanks for this video sir. It helps me a lot
@DanielK432
@DanielK432 2 года назад
Thankyou. It was real help for me to new script editor deploy management system.
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
👍
@xtie4
@xtie4 2 года назад
Great explanation. Very useful and needed. Many thanks.
@emmanuellangufor6862
@emmanuellangufor6862 9 месяцев назад
Thank you so much for the well explained video. Please after deploying my appscript, I has a slow loading and does not load at all. i have done a lot of research to fix the issue but with no success .please can you help me even with a documentation. how to view my contents after deploying google appscript? thank you
@celiz-y6w
@celiz-y6w Год назад
Clear explanations. Thank you
@temyraverdana6421
@temyraverdana6421 2 года назад
Today a high content video. Very interesting. Thanks
@CesarPeron
@CesarPeron Год назад
I use deployments to connect 2 Google App Script files, but the archiving function doesn't appear to work because they are always available and functional. Can’t we delete the old Deployments?
@feng1014
@feng1014 2 года назад
I should watch your video bef to update my apps, but now too late. My learned lessons when i saw this.new deploment method. I deployed new one, and archived the previous one, then realised users lost access with old URL which was saved in favorite. Then i re-deployed the old version from achieve, still not able to solve it as a mew URL generated. At last, i have to inform all users with new URL, and finally learned the difference of versions and deployment. Quite painful as lost users.
@Sulaimangalib
@Sulaimangalib 2 года назад
Excellent upgrade.
@CesarPeron
@CesarPeron Год назад
At this time, the "Use legacy editor" feature is not available. Have we lost the code history function? 🤔🤔
@ExcelGoogleSheets
@ExcelGoogleSheets Год назад
It appears we did.
@ExcelGoogleSheets
@ExcelGoogleSheets Год назад
Try something like this chrome.google.com/webstore/detail/google-apps-script-github/lfjcgcmkmjjlieihflfhjopckgpelofo?hl=en
@perrysantos
@perrysantos 2 года назад
i actually clapped at this video. thanks a lot
@ThomasFranksomt
@ThomasFranksomt 2 года назад
Do you have a video for creating a sheets template or library deployment?
@NGAJINGODING
@NGAJINGODING 2 года назад
can u explain about attr target="_top" is there any option or what happen if we remove it?
@fergonzalezpy
@fergonzalezpy 2 года назад
This is really usefull👌🏻 thanks
@treehann
@treehann Год назад
I was hoping to find a video explaining how to use Apps Script to create custom functions and use in Google Sheets. I feel somewhat misled by "Google Sheets" being in the title of the video when it is not used here.
@ExcelGoogleSheets
@ExcelGoogleSheets Год назад
Here you go ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-SUs74nwFMFY.html
@mrmido314
@mrmido314 2 года назад
Hi sir, First, i want to thank you for making these tutos .. 🙂 I would like to know if it's free to use and deploy google sheet to a web app ? Thanks in advance
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
It is free for personal use.
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
Or you need a workspace account.
@mrmido314
@mrmido314 2 года назад
@@ExcelGoogleSheets good, thank you 🙂
@notme1972
@notme1972 2 года назад
I have been trying to make web app mobile-friendly. Even modified my html codes for it to be aesthetically good on phones. However, I can't seem to make it work. Not sure if I can make it work now since there are changes to IDE.
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
Add viewport meta tag via script developers.google.com/apps-script/reference/html/html-output#addMetaTag(String,String)
@kbye6865
@kbye6865 2 года назад
does re-deploying an archived version also bring the code back? and if not, how can one re-open a previous version of the code?
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
developers.google.com/apps-script/api/reference/rest/v1/projects/getContent I suggest using git or something like this chrome.google.com/webstore/detail/google-apps-script-github/lfjcgcmkmjjlieihflfhjopckgpelofo?hl=en to track your source code changes in the future.
@kartickchakraborty9135
@kartickchakraborty9135 2 года назад
How are you Sir? Sir would you kindly make a video on how to use "file or folder picker dialogue box" inside a UserForm in Excel VBA?
@maheshve6152
@maheshve6152 2 года назад
Hi sir can please I need a apps script in Google sheet date means - when data complete just we will cilck one button automatically go to another sheet in Google sheet use as apps script can please prepare like
@Mr_YaYa43
@Mr_YaYa43 2 года назад
Hello, i want to create a button, which when i click the button i go to whatsapp web. can u show how to create the button and some appscript to make the button functioning. tqvm. subscriber from malaysia.
@Sami-fm3zg
@Sami-fm3zg 2 года назад
I don't get how to OAuth verify a simple App Script Custom functions add-on. The process is VERY unclear, how one should have a consent screen displayed ?
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
Consent screen should be displayed automatically by Google based on scopes you define in your manifest JSON file and consent screen setup in your Google Developer Console.
@ravindrachorage9029
@ravindrachorage9029 2 года назад
I.can't see google formula syntex so can you help me to get back my formula syntex?
@espeditodelgaudio6718
@espeditodelgaudio6718 2 года назад
There is a way to create a CRUD application connected to a MYSQL database?
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
Sure, but why not just create a web application hosted elsewhere without all crazy apps script limitations at that point?
@espeditodelgaudio6718
@espeditodelgaudio6718 2 года назад
@@ExcelGoogleSheets and so what you suggest me?
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
@@espeditodelgaudio6718 Depends, there are so many options. If you want something custom, maybe try Django.
@espeditodelgaudio6718
@espeditodelgaudio6718 2 года назад
@@ExcelGoogleSheets ok. And so there is no Google option…
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
I'm confused, isn't using MYSQL database already "no Google"?
@ohmyads3d
@ohmyads3d 2 года назад
Your video title looks misleading, where is the part on Google sheet?
@ВладанРадојевић
@ВладанРадојевић 2 года назад
Dear Sir I know that you receive hundreds or thousands of messages daily and I don't know if this message will reach you. If it does. I hope it finds you well. I would like to express my deepest gratitude for all the videos you made. I admire your coding skills, teaching capabilities and most of all your enthusiasm, energy, dedication and professionalism you have shown. Thank you very much indeed. You didn't just help me and dozens of others coding beginners, but you inspired us to grow from zero to hero. And in my opinion that is the greatest value of your work. Thank you very much. As I said , I know that you are being overloaded with a lot of messages from people like me, people who are seeking help. Also I know that your time is very precious. But I really wouldn't bother you if I am not desperate to solve an issue. I have been struggling for weeks to solve one problem. I read lots of documentation, articles and books in order to find a solution, but unfortunately without success. I am developing a web application with Google Apps Script in order to automate some working processes in the school I am employed in. The app is for internal (in domain) use only. It’s not commercial. I am trying to find out is there any way that I can set up the app execution so the web application could: 1)access the data ( gmail, calendar) of user who is running the app, 2)access the data of the app's owner / deployer but only throughout the app (For example I don’t want to give access to spreadsheet data outside the app i.e. I don’t want to share the spreadsheet with an user accessing the app), 3)be installed by super admin for all domain users so the users will not be prompted for a consent screen in order to authorise use of the app. I understand if you wouldn't have no time to answer me. Thank you very much for reading this. I wish you all the best in your professional and personal life.
@ExcelGoogleSheets
@ExcelGoogleSheets 2 года назад
1. will require using OAUTH2 API developers.google.com/identity/protocols/oauth2 which means your users WILL be prompted for a consent screen in order to authorize the use of the app.
@ВладанРадојевић
@ВладанРадојевић 2 года назад
@@ExcelGoogleSheets Thanks a lot. Wish you very best!
Далее
How to Create an Internal Google Sheets Add on
21:16
Просмотров 2,2 тыс.
Борщ в стиле высокой кухни!
00:57
Turn Your Spreadsheet into an App
6:58
Просмотров 76 тыс.
Deploy Google Sheet Add-on
15:09
Просмотров 36 тыс.
Google Sheets - Userform
35:51
Просмотров 161 тыс.
Google Apps Script Tutorial for Beginners
23:54
Просмотров 383 тыс.
How to publish to the Google Workspace Marketplace
8:11