Apps Script Codes

Apps Script

• Apps Script equivalent of Google Sheets functions
• Console.log VS Logger.log
• Ternary operator

Arrays

• Sort numbers in ascending or descending order

Cells

• Check if a cell is within a cell range
• Freeze the values of a cell range
• Get the address of a cell and compare 2 cells by their address

Dates and Times

• Dates and times with Apps Script

Interface

• Add a custom menu
• Create a custom dialog box
• Create a custom sidebar
• Display a dialog box (alert)
• Display a dialog box (prompt)
• Display a notification (toast)
• Insert an image in base64

Miscellaneous

• Open a link in a new tab

Numbers and Generators

• Calculate the power or root of a number
• Generate a random number
• Generate a random string
• Round a number

Sheets and Documents

• Access a sheet by its GID
• Authorize scripts in a Google Sheets application
• Copy a file
• Delete unused rows (at the bottom of the sheet)
• Refresh a filter
• Show or hide a sheet

Text and Formatting

• Convert to uppercase or lowercase

Custom Functions

• Add a custom function usable in sheet formulas
• COLUMN_VALUES function: returns non-empty values as an array (in column)
• DUPLICATES function: returns the unique list of duplicates as an array
• HTML_BODY function: returns the content of a web page
• HTML_PAGE function: returns the complete HTML code of a web page
• ROW_VALUES function: returns non-empty values as an array (in row)
• TABLE function: returns a table in HTML format

Examples of Complete Codes

• DatePicker in sidebar
• Fifteen puzzle