I have seen this request many times over the years but all I see are complicated methods. Is there an easy way to export Board members to a report yet?
Since subscription cost depends on how many Boards a member is on, this information should be easily accessible.
The number of cards someone is on within a Board is irrelevant to our use of Trello. Though this would still be nice to export to a spreadsheet rather than view avatars.
Another development, if not yet available, would be for the admin to be able to assign members to Boards. It is an extra step for members to request access. We are all volunteers, so the faster people are seeing the right information the better
You can create a report of cards members are assigned to using automations. Create the report card with this description (add a blank line at the end):
Username,Card Name, Date/Time Assigned
This creates a header with 3 columns. If you want more, you'll have to add them with the quotes and comma the same way. They must all appear on one line.
Create an automation that finds the report card and adds
\n{carddescription}"{matchedusername}","{triggercardname}","{date}{time}"
When you copy the contents of this card, it will be in the CSV file format, which excel can read. Just paste it into a notepad and save the file as a CSV file.
You can do further automations to add a line when the user is unassigned from a card (you can add a column for that and add it a similar way. You could do further automations to create a new report card every week or whatever timeframe you see fit.
This is how I achieve exactly what you're looking for there.
The others I'm not sure about at this time.
Oh, and if you want the report card to be retroactive, you would need a button that looks for all cards with assigned members and add them. That's just a tiny bit more complex, and you'll lose your accurate timestamp (it essentially will be when you clicked the button), but the above automation will fix that going forward.
If you need more information or want to implement it with those extra steps, I'm happy to help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.