Idealistically Caspan

Some Crazy Ideas From MrCaspan's Head!

Menu

Skip to content
  • Home
  • Contact
    • Send Me A Message
    • Buy Me A Beer
  • About
  • Other Caspan Sites

Google App Script

Google App Script – What Loop is Faster for Iterating Over an {Object}?

While on a Google Apps Script Discord Server a great question came up as to what loop was faster when iterating over an object. If you are curious about Array loops please see this post. After some poking around the net we found lots of answers but every answer was specific to their platform or…

October 22, 2021 in Google App Script.

Google App Script – What Loop is Faster for Iterating Over an [Array]?

While on a Google Apps Script Discord Server a great question came up as to what loop was faster when iterating over an array. If you are curious about Object loops please see this post. After some poking around the net we found lots of answers but every answer was specific to their platform or…

October 22, 2021 in Google App Script.

Google App Script – Set Gmail Signature On Org Users Using A Company Template

When we first moved to Google Workspaces (Gsuite at the time) from our Exchange Server one of the basic necessities that we needed was the ability to set a company wide template for Gmail users. We found work arounds like using GAM and Windows PowerShell to set each users signature, it worked but it felt…

October 14, 2021 in Google App Script.

Google App Script – Get The Last Response from a Google Form

I was tasked recently to create an In and Out Google App Script so users could set their status so that others can see who was in or out of the office using a Google Calendar. Currently users message reception and then they create an event in the Ins & Outs calendar. I have started…

October 9, 2021 in Google App Script.

Google Apps Script – Get Headers and Row Values

I Thought I would share with you a small function that I made for Google App Scripts. This function will take 3 passed values sheet – A sheet object from Google Sheets headerRow – The row number of the header values row – The row number that contains that values you want to pull If…

November 16, 2020 in Google App Script.