I am brand new to the Atlassian Community, but have been working in Trello for a few months. I work with a volunteer group who uses Trello to organize our tasks. Individual volunteers can log in and join a card any time they are free.
We're noticing quite a bit of user bloat. That is, we have a number of people who have signed up to volunteer but never joined a card or completed tasks on a card. We'd like to be able to run a report showing something relating to user activity that **includes** inactive users.
A few potential examples of what we have in mind:
We are open to using a powerup, though I haven't been able to find one that would give us an off the shelf fix. It seems like this *might* be possible in the future when we are able to upgrade to a paid account and use the expanded Butler features, but I don't see a clear pathway to exporting the data we're looking for.
Any help is greatly appreciated. Our org is hosting a fundraising event this weekend and we expect to have access to funds for a solution shortly.
Thanks very much! JNS
@Jordan Stoeger This Trellinator function will give you a list of members who are not a member of any card in the board that was edited in the last month:
You can run it by copying and pasting the code into BenkoBot here:
Just update the board name up the top, then run the code. You can save a link to that snippet to re-run it once per month or whenever you like in order to see a list of people who haven't been joining any cards on which there was activity this month.
There's more you could do with the code obviously, the documentation for Trellinator is here although only a subset of the total functionality is executable inside BenkoBot currently:
Thank you so much @Iain Dooley !
This is exceptional!! I do have a few questions:
How is "this month" defined? If it's run today, 9/24, does it look back to 8/24? Or does it check the past days in the current month (9/1 to 9/24) or... something different altogether?
Benko took a few minutes to run, and afterward, it says, "You have used up 4 of your 600 free minutes" -- I went to benkoworks.com but there doesn't seem to be a place where I can learn more about the pricing structure. As a budding non-profit, we have to be very careful about which tools we become dependent on. Obviously, we could go a good long while on 600 minutes at this rate! But I'd still like to be able to tell the team what we can expect going into the future.
Many thanks! JNS
@Jordan Stoeger glad it helps, the "edited:month" is just Trello's standard search modifier, it will look back one month from today, so if it's the 14th of October, edited:month will return cards that have been changed since the 14th of September. You can also do something like "edited:30" for the previous 30 days:
It's actually 10 free minutes that you get with BenkoBot, there's a bug in the interface that prints the number of seconds but calls it minutes :)
We have developed pricing for it but haven't published it yet. It's also going to be extended to allow things like notification handling and scheduled functions, as well as a "library" that would operate similar to board buttons to save your functions/snippets.
There will be an "ad-hoc" plan where you can execute one off code only (as you did above) which will cost USD$10 for 1,000 minutes with a 12 month expiry. Other plans then allow you to have notification triggers/scheduled commands and so on.
You can also run Trellinator functions in Google Apps Script which means you can host it in a Google user account, so for example if you already use G-Suite you can just setup a Trellinator instance in your own user account and it won't cost you anything. You can read more about this version of Trellinator here:
Trellinator is actually an open source project I developed, and BenkoBot is the commercial hosting version of it, and Google Apps Script is like the free "community" edition.
The Google Apps Script version already has notification handling and scheduled commands, it's just much trickier to setup.
None of this is presented with anything approaching any clarity on the website yet :)
Feel free to email email@example.com if you need any further information.
Hi @Iain Dooley --
I am having problems with the BenkoBot API today. Every time I try to authenticate it gives me this error:
Failed to fetch undefined
I tried going into my Trello account's settings to revoke and re-authenticate, but it gives the same error (although when I go to settings, it is clear that it was authorized).
Can you help me get it working again?
I seem to be late in this topic, but maybe it helps other latecomers. We had the same requirements at UBit and implemented our own solution that we are now offering to the community. Trial version is free. Good comments will be rewarded with a free licence!
the user events mentioned in your post are recorded as Trello actions on a card(except login). The access to these events where you need an immediate response is usually with Butler or other automation tools. But if you are looking to some analysis using reports, then you have to fetch these actions via API, combining through the board for member and card statuses. Here’s an example that uses a combination of Butler, the API etc for an unassigned member on the board.
Note also to report on checklist item assignment and due dates (not entire checklist) is still a challenge within Trello but doable ... read the discussion here https://community.atlassian.com/t5/Trello-questions/Create-an-email-report-including-checklist-items-assigned-to-me/qaq-p/1484216
Let me know should you have more questions.
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...
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