Advertisement
Guest User

Untitled

a guest
Oct 17th, 2019
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. function customFieldsToSpreadsheet()
  2. {
  3. var ss = SpreadsheetApp.getActiveSpreadsheet();
  4. var sheet = ss.getSheetByName("My Database");
  5.  
  6. if(!sheet)
  7. {
  8. sheet = ss.insertSheet("My Database");
  9. }
  10.  
  11. new Trellinator().board("My Board").cards().each(function(card)
  12. {
  13. var current_row = [];
  14. current_row.push(card.name());
  15. current_row.push(card.link());
  16.  
  17. card.customFields().each(function(field)
  18. {
  19. current_row.push(card.customFieldValue(field.name));
  20. });
  21.  
  22. sheet.appendRow(current_row);
  23. });
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement