AppsScriptPulse

Solutions, Sheets

Google Apps Script: Create a Select All Checkbox to Tick Checkboxes in Any Desired Range in Google Sheets – Yagisanatode

Tags:
| | 0 Comments |

Have you ever created a Google Sheet projects where you could really use a select all checkbox (they call them ‘Tick-boxes’ in Google Sheets)? Sure you can copy a range of … Continue reading

Great post not only showing you how to make a ‘select all’ checkbox but you also get an in depth explanation of how this works. Once you fishish this post you might want to read this other Yagisanatode on How to check if there is a Tick Box (Check Box) in a cell or range

Source: Google Apps Script: Create a Select All Checkbox to Tick Checkboxes in Any Desired Range in Google Sheets – Yagisanatode

Solutions, Calendar

Google Apps Script: How force subscribe Google Group Members to a Google Calendar for G Suite – Yagisanatode

Tags:
| | 0 Comments |

Use Google Apps Script to get all the emails addresses of the members in a G Suite group, compare that against all the current members in the Calendar and add anyone who is missing

Google Apps Script, G Suite Admins, Google Calendar, Calendar API,  AdminDirectory, GroupsApp  Note! This article is for G Suite users and admins. You won’t be able to apply the same code to Consumer accounts.  Google Groups in  G Suite can be a really convenient and clean way to share users to drive folders and file locations, … Continue reading “Google Apps Script: How force subscribe Google Group Members to a Google Calendar for G Suite”

 

Source: Google Apps Script: How force subscribe Google Group Members to a Google Calendar for G Suite – Yagisanatode

Solutions, Docs, Forms, Sheets, Slides

Google Apps Script: Google Standard Color Palette Picker for Sidebar and Dialog Boxes in Google Sheets, Google Docs and Google Slides – Yagisanatode

Tags:
| | 0 Comments |

 

I wanted to update one of my free Google Add-on apps that works with colour. What I had is just the standard HTML color input element where the user selects from the palette and that hexadecimal colour code … had always wanted to create a tool for a sidebar or dialogue box that would allow the user to easily access the standard colours or use the custom palette provided by the HTML color input”

Continue reading this post to find out how you can implement your own copy of the colour picker

Source: Google Apps Script: Google Standard Color Palette Picker for Sidebar and Dialog Boxes in Google Sheets, Google Docs and Google Slides – Yagisanatode