[ 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

Beliebte Posts aus diesem Blog

[ TAG 38 ][29.05.2021] - Erfolgreich - Freelancer-Portale

[ TAG 747 ][07.04.2023] -Erfolgreich -BNKTRS -Google Code -Objekt und Methodenliste

[ TAG 52 ][12.06.2021] - Erfolgreich - IAP-20210601-20210609-2325