• #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/