JavaScript – SP Hacks

Export HTML Table as XLSX File

Sam Perrow / September 27, 2019August 23, 2021

Contrary to some opinions floating around the Internet, it is in fact possible to export an HTML table as an .xlsx document (as well as .xls, .csv, and others), using only client side code, thanks to the useful Sheet JS library. The .xlsx file format is the one used by the most recent version of […]

Update Custom SharePoint Forms with JavaScript

Sam Perrow / March 15, 2019March 16, 2019

If you did not believe that custom SharePoint forms could be updated with client side code, guess again. The script below utilizes the SP.FileCreationInformation?object available in SP 2013 to write file content to whichever forms are specified by the user, to as many subsites as desired within a site collection. This script can be extremely […]

Send Emails After Note Board Comments

Sam Perrow / September 23, 2018August 22, 2019

The SharePoint web part Note Board is a very useful tool add to pages so users can post comments to the public. Unfortunately Note Board saves users’ comments in each users’ profile in MySites rather than a SharePoint list, so workflows cannot be triggered after a new comment. Problem There is no native SharePoint way […]

SP Calendar Pro

Sam Perrow / August 11, 2018March 16, 2019

I have created this JavaScript library in order to facilitate operations involving SharePoint calendars. I was inspired to create this because I have dealt with several calendar related projects at work that require collecting and filtering of calendars based on user provided datetimes. I realized how incredibly painstaking it was to collect calendar events from […]

Get Single and Recurring Calendar Events without jQuery

Sam Perrow / June 23, 2018February 2, 2020

When I first began working with SharePoint calendars, I quickly realized how difficult it was to work with recurring events. Unfortunately there is not a native way to collect the recurring events- only be done using the SharePoint web service via SOAP or REST. SharePoints’ own CSOM does not provide a mechanism to do so. […]

Load Multiple JavaScript Files Dynamically Without jQuery

Sam Perrow / June 4, 2018March 16, 2019

After combing the Internet and failing to find a simple method to dynamically load multiple JS files, (while guaranteeing the loading of each), I have put together one of my own. The advantage of the script below is that this allows you to: 1) Dynamically load multiple JS files using a single JS file, preventing […]