Skip to content

Instantly share code, notes, and snippets.

@iaindooley

iaindooley/gist:731f770a0f3740c5b0e2fbb76769bd2d

Created August 17, 2020 01:08
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/731f770a0f3740c5b0e2fbb76769bd2d to your computer and use it in GitHub Desktop.
Save iaindooley/731f770a0f3740c5b0e2fbb76769bd2d to your computer and use it in GitHub Desktop.
Download ZIP
Import rows to cards
Raw
gistfile1.txt
function importRowsToCards()
{
var values = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Invoices").getDataRange().getValues();
var target = Board.findOrCreate("Weekly Invoices").findOrCreateList("Invoices This Week");
for(var i = 0;i < values.length;i++)
{
Card.create(target,values[i][0]+" Staff Member 1","top");
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment