Skip to content

Instantly share code, notes, and snippets.

@iaindooley
Created March 27, 2020 23:36
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/8e0b962ff1a3a1ea599df8db7ccee5bd to your computer and use it in GitHub Desktop.
Save iaindooley/8e0b962ff1a3a1ea599df8db7ccee5bd to your computer and use it in GitHub Desktop.
Days in list report
function daysInListReport(params,signature,original_time)
{
var out = [];
new Board(params)
.lists()
.each(function(list)
{
var listout = [];
list
.cards()
.each(function(card)
{
var diffdays = Math.round((Trellinator.now() - card.movedToList())/(1000*60*60*24));
listout[] = "["+card.name()+"]("+card.link()+") - Days in list: "+diffdays;
Utilities.sleep(1000);
});
out[] = listout.join("\n\n");
});
MailApp.send("user@example.org","Your report",out.join("\n\n"));
ExecutionQueuel.push("daysInListReport",params,signature,original_time.addDays(1));
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment