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…
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…
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…
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…
So you are a Google Workspace admin and have found out that some of your users have unmanaged Google accounts that are using your managed Google Workspace domain name. This can happen for a few reasons: The user had a free Google account before you switched your domain over to Google Workspace. You have split…
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…
Like most organizations that use G Suite, templates are a huge help when making sure people stay consistent with their paper work. Things like Expense Reports, Name Change Requests, Travel Requests, and even TPS reports with the NEW cover sheet! With the new Google Drive system, it seems that Google has removed a feature that…
I have always been the type of person to try and make my life easier. That would mean adding things like a keypad to my house dead bolt lock so I don’t have to carry as many keys, adding a magnetic mount for my device so I just pop my phone on and off any where I am,…
So in the past few months I decided to start adding devices to my BlackBerry collection. My collection as it stood was old BlackBerry devices that I had used throughout the years since my first 7100r that got me hooked on BlackBerry. Living in Kitchener/Waterloo area I figured this should be easy! I started to…
So last week I decided to undertake the job of upgrading server rack 4 in our IT room. I knew the old server rack was doing its job just fine but we were running out of space quickly in the half rack. I ran into a few issues like forgetting to measure the space properly…
