Reports from the 'Card Size' field.

[Evanthe Dunn]

Hi Community!

I am looking to customize some reports from a workflow board.

Is anyone aware of a power up, or other method to automate a weekly report that pulls the numbers from the 'Card Size' field, and which lists they are sitting in? 

The other report I would like to run, is from the 'Time in list' power-up. 

I've had a good search around, but cant quite seem to find the right solution!

Evie

[Iain Dooley · Accepted solution]

@Evanthe Dunn The API does have the ability to fetch information from other power ups on a card:

https://developer.atlassian.com/cloud/trello/rest/#api-cards-id-pluginData-get

I've not experimented with it, but you could use Trellinator to execute the report weekly like this:

https://gist.github.com/iaindooley/1d1a386b644c9eb715e63b230a1bd7ea

You can read more about Trellinator here:

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

[Evanthe Dunn]

Hi Iain,

Thanks so much for your reply. Much appreciated :)

Evie

[jjacallen]

You can use Butler to generate reports and even formulate them in CSV so you could easily make them into a spreadsheet. But when I try to use the Card Size field, nothing comes out in the report. Maybe that's because I have the wrong name for the field in my Butler script. Since I couldn't find any documentation about the actual field names, I just guessed {cardsize} but like I said - that didn't work.

[Iain Dooley]

@jjacallen the format for custom field variables is {{%Field Name}}:

https://help.butlerfortrello.com/article/29-custom-field-variables

[jjacallen]

No dice, using "{{%Card Size}}" in the report pattern had the same result - no data displayed in the report.

[Iain Dooley]

@jjacallen hmm bummer this Trellinator function would print that out:

https://gist.github.com/iaindooley/bb1cc257ede60372905458f777e2f8a9

You can execute it in BenkoBot here:

http://app.benkobot.com/

You could save the snippet and execute it when required, or you could set up Trellinator to run in Google Apps Script and schedule it to recur:

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271