Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Reports from the 'Card Size' field.

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

2 answers

1 accepted

0 votes
Answer accepted
Iain Dooley Community Leader May 16, 2020

@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

Hi Iain,

Thanks so much for your reply. Much appreciated :)

Evie

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 Community Leader Sep 21, 2020

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

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

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

Iain Dooley Community Leader Oct 05, 2020

@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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Trello

Taco Tuesday: Your favorite Trello blog takeaway

Hello friends! From the community that brought you Welcome Wednesday, Throwback Thursday and Friday Fun, welcome to Taco Tuesday, a weekly discussion about all things Trello. The best part? One Tac...

373 views 14 12
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you