[ TAG 742 ][02.04.2023] -Erfolgreich -BNKTRS -Google Code -Objekt und Methodenliste
Ich beginne heute mit der Fortsetzung in die Einarbeitung der Google-Scripts.
- [ 20230226_155311.jpg ]
- [ 20230305_115113.jpg ]
- [ 20230305_132631.jpg ]
- [ 20230311_090236.jpg ]
- [ 20230325_155016.jpg ]
- [ 20230325_193911.jpg ]
- --------------------------
- [ DriveApp ]
- [ https://developers.google.com/apps-script/reference/drive/drive-app?hl=de ]
- [ Folder ]
- [ https://developers.google.com/apps-script/reference/drive/folder?hl=de ]
- [ FolderIterator ]
- [ https://developers.google.com/apps-script/reference/drive/folder-iterator?hl=de ]
- [ File ]
- [ https://developers.google.com/apps-script/reference/drive/file?hl=de ]
- [ FileIterator ]
- [ https://developers.google.com/apps-script/reference/drive/file-iterator?hl=de ]
- [ SpreadsheetApp ]
- [ https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app?hl=de ]
- [ Sheet ]
- [ https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=de ]
----------------------------------------------------------
YouTube - Beiträge zum Thema Google-Sheets.
- [ google.script.run Web App - withSuccessHandler & withFailureHandler Callbacks ]
- [ https://www.youtube.com/watch?v=ZRyxJZRlrWM ]
- [ google.script.run replaced with JavaScript Promise API, Async & Await in a Web App ]
- [ https://www.youtube.com/watch?v=x78cKSScFGY ]
- [ JavaScript Promise.all in an Apps Script Web App ]
- [ https://www.youtube.com/watch?v=sc7zYshj-mA ]
- [ Apps Script Web App - Passing Complex Data between Server & Front-end ]
- [ https://www.youtube.com/watch?v=4Nd4lEh3mdE ]
- [ Google Sheets Form for Data Entry - Apps Script ]
- [https://www.youtube.com/watch?v=ZKYvrD-3Ksc]
- [ Get __it Done! - YoutubeKanal]
- [ https://www.youtube.com/@get__itdone7958 ]
- [ google.script.run replaced with JavaScript Promise API, Async & Await in a Web App ]
- [https://www.youtube.com/watch?v=x78cKSScFGY]
- [ Apps Script Web App - Passing Complex Data between Server & Front-end ]
- [https://www.youtube.com/watch?v=4Nd4lEh3mdE]
- [ Google Sheets Self-Made JSON API Tutorial ]
- [ https://www.youtube.com/playlist?list=PLRmEk9smitaVGAAhgU0Pdc2sEs7yxDrEk ]
- ------------------------------------------------
- [Google Sheets - JSON API, Wep App - e.j1 p.1]
- [https://www.youtube.com/watch?v=VPI27L_fQC4&list=PLRmEk9smitaVGAAhgU0Pdc2sEs7yxDrEk&index=1]
- [Google Sheets JSON API, Read & Write Data, Wep App - e.j1 p.2]
- [ https://www.youtube.com/watch?v=yiPnkBEHqf0&list=PLRmEk9smitaVGAAhgU0Pdc2sEs7yxDrEk&index=2 ]
- [Google Sheets - JSON API, Testing with Postman, Wep App - e.j1 p.3]
- [https://www.youtube.com/watch?v=_U6WqGtGfOs&list=PLRmEk9smitaVGAAhgU0Pdc2sEs7yxDrEk&index=3]
- [Google Sheets - JSON API, Limit, Offset, Wep App - e.j1 p.4]
- [https://www.youtube.com/watch?v=uxRT9NupIH4&list=PLRmEk9smitaVGAAhgU0Pdc2sEs7yxDrEk&index=4]
- [HTML Form to Google Sheets using JSON API Web App - - e.j1 p.5]
- [https://www.youtube.com/watch?v=3UYGAAJQXEE&list=PLRmEk9smitaVGAAhgU0Pdc2sEs7yxDrEk&index=5]
- [ Web Apps on Google Sheets ] von [ Code With Curt ]
- [ https://www.youtube.com/playlist?list=PLa0SnLUuP_FcmfNCtm8Chtye0cl5LZlNn ]
- ---------------------------------------------------------
- [ Google Sheets Dynamic Apps Scripts using Named Ranges ]
- [ https://www.youtube.com/watch?v=GTwXhIzAeMw ]
- ---------------------------------------------------------
- [ Apps Script and JavaScript tutorials ]
- [ https://www.youtube.com/playlist?list=PLNwCcck1-mNgASuUVvHeK282pvHzgWP-6 ]
---------------------------------------------------------------
Ein weiteres wichtiges Thema sind die HTML-Vorlagen mit deren Scriptlets. Mit den HTML-Vorlagen können dynamische Web-Interfaces mit Serverseitig, Dynamischen Code generiert werden. Dafür wird ein neuer SKILL eröffnet.
Quellen:
- [ Using doGet(e) Function to start Web App on Google Apps Script ]
- [ https://www.youtube.com/watch?v=Btz0T-SmSwk ]
- [ Web-Apps ]
- [ https://developers.google.com/apps-script/guides/web?hl=de ]
- [ HTML-Dienst: HTML-Vorlagen ]
- [ https://developers.google.com/apps-script/guides/html/templates?hl=de ]
------------------------------------------------------------------
In der nächsten Worksession muss ich die Server-Client-Kommunikation ausarbeiten. Dazu habe ich folgende Links gefunden.
- [ Google Sheets Self-Made JSON API Tutorial ]
- [ https://www.youtube.com/playlist?list=PLRmEk9smitaVGAAhgU0Pdc2sEs7yxDrEk ]
- [ google.script.run Web App - withSuccessHandler & withFailureHandler Callbacks ]
- [ https://www.youtube.com/watch?v=ZRyxJZRlrWM ]
- [ google.script.run replaced with JavaScript Promise API, Async & Await in a Web App ]
- [ https://www.youtube.com/watch?v=x78cKSScFGY ]
- [ JavaScript Promise.all in an Apps Script Web App ]
- [ https://www.youtube.com/watch?v=sc7zYshj-mA ]
- [ Apps Script Web App - Passing Complex Data between Server & Front-end ]
- [ https://www.youtube.com/watch?v=4Nd4lEh3mdE ]
Kommentare
Kommentar veröffentlichen