Designing a group profit chart

eric menges March 25, 2019

I have a landscape maintenance company with multiple crews. I am new to trello , I want to design a board to have crew leaders input date,estimated man hours ,worked hours and number of crew members .With this info daily I would like to use butler power up to do some of it but I would like to produce a production number and  graphs to show in consistency in there weeks numbers . I would like some help if there is any one out there to help .   

2 comments

Iain Dooley
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 25, 2019

@eric menges For collecting the data, the custom fields power up will be ideal. It's available on mobile, so your team can type their numbers into fields on various cards as required.

Butler would be useful for creating notifications that would put the required card "right in front" of the person, in particular my strategy for field staff is usually to have a "notification driven" interface approach.

That is, at the correct time each day, Butler can create a card (perhaps copied from a template) for the day's data collection and post a comment. If you post a comment with "@board" or "@card" everyone who is a member of the board or card will get a notification on their mobile so they can just tap it, get access to the card where they need to input their data and type it in.

Butler won't be useful for aggregating and reporting on the numbers, though. Really what you want to do is grab that information and chuck it in a spreadsheet.

This is a good primer on how to use Google Sheets for Trello reporting:

http://www.littlebluemonkey.com/blog/automated-trello-reporting-using-google-spreadsheets

That guy's work has been the basis for the Trellinator framework I created:

https://trello.com/integrations/#trellinator

The only issue is that his work long predates the custom fields power up... but if you wanted to take the approach of putting the days numbers into a spreadsheet based on custom fields you could do something like this in Trellinator:

https://gist.github.com/iaindooley/34b1dd8f48a3a087baeb62cac5ab6fdd

You can see how to set up Trellinator here:

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

eric menges March 26, 2019

Lain thank you that is alittle advanced for this landscaper lol . Is there a service cost for you or some one out there to design and implement some thing like this ?

Iain Dooley
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 26, 2019

@eric menges yes that's what I do :) I have a link in my profile. @Katrin Anger who commented below also does workflow design in trello 

Katrin Anger
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 26, 2019

@eric menges 

Hi Eric,

I do a lot of workflow designs with Butler for Trello, and I could certainly give you some input on designing a good workflow for you. Please find my contact details in my profile.

eric menges March 28, 2019

Lain please send our video chat link to eric@purescapes.net agian we have a 4:00 app I cant locate the link 

thanks Eric

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events