Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Aggregate numbers from Custom Fields
function aggregateNumbersDaily(board,signature,original_time)
//Create a new sheet in the document for today's date
var sheet = SpreadsheetApp.getActiveSpreadsheet().insertSheet(;
var board = new Board(board);
var fields = board.customFields();
//Loop through all the Site Diary cards for Location 1
board.list("Location 1 Site Diary").cards().each(function(card)
//Create a row that has card name, and the values of each custom field
var current_row = [];
//append the row to the sheet
//Run again at the same time tomorrow
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment