Is there a way to display a card's most recent comment in email reports?

[Michael Hills]

I would like to have my email reports show the most recent comment added to a card. I cant find a variable to do so.  Is this possible?

[Iain Dooley]

@Michael Hills nope, the only variables available in reports are card variables and there's no card variable like {cardmostrecentcomment}

This Trellinator function would do it:

https://gist.github.com/iaindooley/2d0c017146c963206b2b902c1d92acb2

You can read about how to set up Trellinator here, although it's pretty complicated:

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

I'm developing a standalone "hosted trellinator" product called BenkoBot, you could try this report function live if you wanted! Although you can't do scheduled commands with it yet, here's the code:

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

Just authenticate here then copy and paste that code in and run it :)

https://app.benkobot.com/

[Iain Dooley]

@milynnus you might like to try this v0.01 of BenkoBot --^

[milynnus]

@Iain Dooley did I not say you inspired me. I built my own "as a service" based on Wayscript using its form and 1 python module. 

Will be release soon....

This the sample code used to generate the :

client.add_board(board_name = 'My Superheros', default_lists=False)

for board in client.list_boards():
if board.name == "My Superheros":
board_list = board.add_list(name='Superman', pos='bottom')
trello_card = board_list.add_card(name = 'He is Clark Kent the reporter from Daily Planet' , desc='Created by Trello Superhero')
trello_card.create_label(name='SuperPowerUp', color = 'red')
friends = ['Spiderman', 'Wonder Woman', "Batman"]
trello_card.add_checklist(title = 'My Superhero friends', items = friends)
trello_card.attach(name = 'My Self in Super Attire', url = "https://unsplash.com/photos/8I-ht65iRww")
trello_card.attach(name = 'My favourite Trailer', url = "https://www.youtube.com/watch?v=3Pksim-YVWE")

[Iain Dooley]

@milynnus that looks awesome! Well done :)

[milynnus]

Surprisingly to turn text into a python module dynamically was much easier than I had thought. Again...thanks. The power of Wayscript with Trello is more in automation assembling chunks of codes behind triggers, function calls, timers, some logic etc. 

[milynnus]

@Michael Hills No expert in Butler here but if you need to watch a specific card for comments or even other events including accidental delete, which you cannot recover in trello ,and informs you immediately via a smtp it can be done. 

[Michael Hills]

Looking to have the comments combined with a bunch of other card info in the email reports to see whats going on at a glance rather than the separately emailed each time they are added.  It's to get an overview of every card all at once.  The last comment added would help to show where each card was left off. Thanks for the info though.  I might need that feature too.

[milynnus]

@Michael Hills while there is a place for reports my mentor on successful enterprise project manager says it is better to be able to sense the pulse of the business. For this reason, having trigger mechanisms that watch over your board would be useful. Trello automatically builds a activity list and it the background you can tap on these for better timely decision. There are 7 keys would watch. Watching over comments with a AI and able to classify using NL would be interesting. Time to build a feed to app.