Skip to content

Instantly share code, notes, and snippets.

@iaindooley

iaindooley/gist:3b6e08acf049479640600f4504b0eea9

Created March 27, 2019 23:18
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/3b6e08acf049479640600f4504b0eea9 to your computer and use it in GitHub Desktop.
Save iaindooley/3b6e08acf049479640600f4504b0eea9 to your computer and use it in GitHub Desktop.
Download ZIP
Cards due in 24 hours or no due date
Raw
gistfile1.txt
function cardsDueIn24HoursOrNoDueDate()
{
var sheet = SpreadsheetApp.getActiveSpreadsheet().insertSheet("Due Soon or Not Due");
new IterableCollection(TrelloApi
.searchCardsInBoards(new Trellinator().board("My Board"),"-due:incomplete is:open")
.cards()
.asArray()
.concat(
TrelloApi
.searchCardsInBoards(new Trellinator().board("My Board"),"due:day is:open")
.cards()
.asArray()
)).each(function(card)
{
sheet.appendRow([card.link(),card.due(),card.name()]);
});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment