Properties and Cache Services

Поделиться
HTML-код
  • Опубликовано: 16 сен 2024
  • A different kind of video showing the Properties and Cache Services available for Google Apps Script.
    Important Notes:
    * The Properties and Cache Services are designed to hold data for use beyond a single run of a script.
    * The Legacy IDE had an option to see view and directly interact with the Script Properties. This is not available in the new IDE but the service still exists and can be interacted with via code.
    * The primary difference between the PropertiesService and CacheService is that key-value pairs in the Cache are automatically deleted after 25 minutes, while data in the PropertiesService persist until deleted via code (or manually from the Legacy IDE)
    Sheet (to copy)
    docs.google.co...
    Connect with me:
    • spencer.farris@gmail.com
    • spencerfarris.me
    • www.linkedin.com/in/spencer-farris/
    • Twitter @FarrisSpencer
    • Google Product Expert support.google.com/docs/profile/12305

Комментарии • 7

  • @hozyfaalsaleh6788
    @hozyfaalsaleh6788 3 года назад +2

    How do i disable a Google copy or download? By script

    • @SpencerFarris
      @SpencerFarris  3 года назад +1

      Just like using the UI interface that can be disabled for Viewers/Commentors but not for Editors. Here's a StackOverflow post describing it
      stackoverflow.com/questions/63664349/google-apps-script-get-rid-of-copy-download-option

    • @ArtAniStokuv
      @ArtAniStokuv 3 года назад

      @@SpencerFarris sounds interesting option to add too :D

  • @jmathew6988
    @jmathew6988 6 месяцев назад +1

    Wow! This really is a powerful feature I didn't know about until now

  • @ArtAniStokuv
    @ArtAniStokuv 3 года назад

    awesome work as always , any idea how we can create attendance system using google tools (docs , scripts)? for multiple places office and store ....etc

    • @SpencerFarris
      @SpencerFarris  3 года назад +1

      As written that's a really general ask without enough specifics to point in the right direction. As with most questions of "can this be done in Google" the answer is probably "yes," but a lot more details are needed to really flesh it out. Want to shoot me an email?
      spencer.farris@gmail.com

    • @ArtAniStokuv
      @ArtAniStokuv 3 года назад

      @@SpencerFarris Thanks a lot :D