AppsScriptPulse

Category: Solutions

DriveSolutions

Change Google Drive Folder color with Apps Script – Stéphane Giron – Medium

Tags: ,
| | 0 Comments |

In Apps Script you can use the DriveApp service to manage your files and folders, but the methods getColor and setColor do not exist. You can use the drive advanced service to query the API directly but with recent change you will have to activate the Drive API in GCP and will need a GCP project. To have a smooth integration and skip the Google Cloud project creation here is a function to manage Folder color in Apps Script. These functions queries the API directly with UrlFetchApp() service.

Source: Change Google Drive Folder color with Apps Script – Stéphane Giron – Medium

App MakerSolutions

Getting Started with Google App Maker 3: Turn your spreadsheet to an app with no code at all – Cleo Espiritu

Tags:
| | 0 Comments |

Is there a Sheets or Excel file you and your team have been using that you find is not very user friendly and is very tedious to maintain? If so, learn how you can start managing the same data in App Maker by building your first simple app!

Source: Getting Started with Google App Maker 3: Turn your spreadsheet to an app with no code at all – Cleo Espiritu

SheetsSolutions

Google Apps Script Patterns: Writing custom formulas/functions and handling single and range inputs – MASHe

Tags:
| | 0 Comments |

Custom functions have been in Google Apps Script since it’s public launch in 2009. These let you extend Google Sheets function list allowing you to create and share your own spreadsheet formula. This post provides some guidance on writing custom Google Sheet functions that can handle both single and range inputs

Source: Google Apps Script Patterns: Writing custom formulas/functions and handling single and range inputs – MASHe

DriveSolutions

How to deal with Google Drive API for Team Drive + some Apps Script code, now use the new Drives resource collection

Tags: ,
| | 0 Comments |

How to use Google Drive API for Team Drive in Apps Script with specific focus for Administrator of G Suite domain to list Team Drive, view Sharing Settings and more

Source: How to deal with Google Drive API for Team Drive + some Apps Script code, now use the new Drives resource collection

SheetsSolutions

Using Slack Slash Commands to Send Data from Slack into Google Sheets

Tags:
| | 0 Comments |

Since I work from home, most of my daily work interactions happen through Slack. It’s my equivalent to the water cooler. A place to hang out and discuss ideas with friends. I’m part of a book recommendations channel. People share books all the time, but they disappear quickly, lost in a sea of messages. I […]

Source: Using Slack Slash Commands to Send Data from Slack into Google Sheets