Profile cover photo
Profile photo
Barrie Roberts
145 followers
145 followers
About
Barrie's posts

Post has shared content
Multiple FILE maker - Learn how to quickly make multiple copies of files on Drive with Apps Script
Multiple FILE maker - Learn how to quickly make multiple copies of files on Google Drive with Apps Script
This includes:
*Checking for user mistakes
*Match & regular expressions - to extract the file ID from the file URL
*Alerts
*makeCopy
*DriveApp class
https://bazroberts.wordpress.com/2017/02/24/multiple-file-maker/


Post has shared content
Multiple FILE maker - Learn how to quickly make multiple copies of files on Drive with Apps Script
Multiple FILE maker - Learn how to quickly make multiple copies of files on Google Drive with Apps Script
This includes:
*Checking for user mistakes
*Match & regular expressions - to extract the file ID from the file URL
*Alerts
*makeCopy
*DriveApp class
https://bazroberts.wordpress.com/2017/02/24/multiple-file-maker/


Post has shared content
Multiple FILE maker - Learn how to quickly make multiple copies of files on Drive with Apps Script
Multiple FILE maker - Learn how to quickly make multiple copies of files on Google Drive with Apps Script
This includes:
*Checking for user mistakes
*Match & regular expressions - to extract the file ID from the file URL
*Alerts
*makeCopy
*DriveApp class
https://bazroberts.wordpress.com/2017/02/24/multiple-file-maker/


Post has attachment
Multiple FILE maker - Learn how to quickly make multiple copies of files on Google Drive with Apps Script
This includes:
*Checking for user mistakes
*Match & regular expressions - to extract the file ID from the file URL
*Alerts
*makeCopy
*DriveApp class
https://bazroberts.wordpress.com/2017/02/24/multiple-file-maker/


Post has shared content

Post has shared content
Pimp up your Sheets!
Formatting your Google Sheets with Apps Script
Pimp up your Sheets!
Learn how to format your Google Sheets using Apps Script. This includes a whole range of formatting methods:
*setBorder
*setFontSize
*setWrap
*setHorizontalAlignment
*setVerticalAlignment
*setNumberFormat
*setFontWeight
*setBackground
*getMaxColumns / getMaxRows
*deleteColumns / deleteRows
*autoResizeColumn
*setColumnWidth
*hideColumn / hideRow
*unhideColumn / unhideRow

This is a great place to start if you're taking your first steps into the wonderful world of Apps Script!

As a bonus, I've also included the hexadecimal colour references for the default colours in the colour palette.

https://bazroberts.wordpress.com/2017/02/20/pimp-up-your-sheet-programmatically/

Post has shared content
Here's a useful sheet with the hexadecimal references for the default colours in the colour palette:
Here's a useful sheet with the hexadecimal references for the default colours in the colour palette:
https://docs.google.com/spreadsheets/d/1I3FCoIW5qdMoOq0lT-OKm6b0y5bwU7vu5fdX_x4iR34/copy

Plus, here's a link to Google's colour design guidelines, which contains a full range of colour swatches
https://material.io/guidelines/style/color.html#color-color-palette

Post has attachment
Here's a useful sheet with the hexadecimal references for the default colours in the colour palette:
https://docs.google.com/spreadsheets/d/1I3FCoIW5qdMoOq0lT-OKm6b0y5bwU7vu5fdX_x4iR34/copy

Plus, here's a link to Google's colour design guidelines, which contains a full range of colour swatches
https://material.io/guidelines/style/color.html#color-color-palette

Post has attachment
Pimp up your Sheets!
Learn how to format your Google Sheets using Apps Script. This includes a whole range of formatting methods:
*setBorder
*setFontSize
*setWrap
*setHorizontalAlignment
*setVerticalAlignment
*setNumberFormat
*setFontWeight
*setBackground
*getMaxColumns / getMaxRows
*deleteColumns / deleteRows
*autoResizeColumn
*setColumnWidth
*hideColumn / hideRow
*unhideColumn / unhideRow

This is a great place to start if you're taking your first steps into the wonderful world of Apps Script!

As a bonus, I've also included the hexadecimal colour references for the default colours in the colour palette.

https://bazroberts.wordpress.com/2017/02/20/pimp-up-your-sheet-programmatically/

Post has attachment
Pimp up your Sheets!
Learn how to format your Google Sheets using Apps Script. This includes a whole range of formatting methods:
*setBorder
*setFontSize
*setWrap
*setHorizontalAlignment
*setVerticalAlignment
*setNumberFormat
*setFontWeight
*setBackground
*getMaxColumns / getMaxRows
*deleteColumns / deleteRows
*autoResizeColumn
*setColumnWidth
*hideColumn / hideRow
*unhideColumn / unhideRow

This is a great place to start if you're taking your first steps into the wonderful world of Apps Script!

As a bonus, I've also included the hexadecimal colour references for the default colours in the colour palette.

https://bazroberts.wordpress.com/2017/02/20/pimp-up-your-sheet-programmatically/
Wait while more posts are being loaded