Skip to content

Instantly share code, notes, and snippets.

@iaindooley
Created September 29, 2019 01:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save iaindooley/3a51bced1b1ae6d83ab6d4f7199954c6 to your computer and use it in GitHub Desktop.
Save iaindooley/3a51bced1b1ae6d83ab6d4f7199954c6 to your computer and use it in GitHub Desktop.
Custom fields to spreadsheet
function customFieldsToSpreadsheet()
{
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("My Database");
if(!sheet)
{
sheet = ss.insertSheet("My Database");
}
new Trellinator().board("My Board").cards().each(function(card)
{
var current_row = [];
current_row.push(card.name());
current_row.push(card.link());
card.customFields().each(function(field)
{
current_row.push(card.customFieldValue(field.name));
});
sheet.appendRow(current_row);
});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment