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
Highlighted

Designing a group profit chart

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 Mar 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

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 Mar 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 Community Leader Mar 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.

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
Community showcase
Published in Trello

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,484 views 12 4
Read article

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