• #cache • #calendar • #common • #common_ui • #docs • #Docs advanced service • #extra • #js • #malware • #news • #Protection • #sheets • #Sheets advanced service • #SpreadsheetApp • #this • #webapp •
-
snippets/sheets/join_rich-text-values/
The snippet demonstrates how to join/concatenation of RichTextValues in Google Sheets. -
snippets/sheets/split_data_to_two_array_by_condition/
-
snippets/common_ui/open-dialog-from-sidebar/
The snippet demonstrates how to open additional UI elements in Google Sheets. -
snippets/extra/xml-js_demo/
Using xml-js for Apps Script -
snippets/cache/chunky-cache/
Using the Google Apps Script Cache Service for objects/files above 100KB. -
snippets/common_js/2darray_to_collection/
Simple conversion of an array into a collection is a common task. There is not always a desire to use wrappers or proxies. -
snippets/docs/uncheck-checklist/
Check/uncheck the entire checklist in Google Documents. -
snippets/sheets/delete_move_rows_by_conditional/
Removes or moves rows within Google Sheets by conditions -
snippets/sheets/reset_sheet_data/
Resets the sheet/sheets data to its original state. Cleans the sheet(s) -
snippets/webapp/responsive-meta/
Using responsive meta tags for an apps script webapp -
snippets/calendar/delete-one-of-series/
Checking and deleting only specific events via CalendarApp -
snippets/common_js/sheet_datetime/
Converts date-time to Sheets format. -
snippets/common_js/date-range-iterator/
Gets an iterator of dates for the specified range. -
snippets/sheets/unlink_urls/
Using the RichTextValues for clearing a specific range -
snippets/addons/minimal-workspace-drive-addon/
Loops through all events and removes them. Demonstrates differences in event types. -
snippets/apps/file-upload-to-drive/
Loops through all events and removes them. Demonstrates differences in event types. -
snippets/calendar/clear-all-events/
Loops through all events and removes them. Demonstrates differences in event types. -
snippets/sheets/toc_generator/
Generates a table of contents for a specific Spreadsheet -
snippets/common_js/get_id_from_url/
Shows how to get file ID from url -
snippets/sheets/protection_multiple_sheets/
Protects the list of sheets -
snippets/common_ui/open_url_in_browser/
-
snippets/common_js/column_names_and_numbers/
Shows how to convert base 26 alphabet numbers and base 10 decimal numbers -
snippets/docs/find_and_replace_bulk/
Sample article showcasing basic Markdown syntax and formatting for HTML elements. -
snippets/docs/create_footnote/
Shows how to create new footnotes -
snippets/apps/importxml-scrapper/
-
snippets/external/external_smartlabru/
-
snippets/customfunctions/customfunction_jaro-winker-distance/