Happy Thursday! How are we liking the new format? Also we’ve just crossed the 1k subscribers milestone! 🎉 What should we do to celebrate??
Send me your ideas, but for now, let’s jump into Trello:
🌮 Getting weather data in your Trello cards
🗞️ Reviewing the top Power-Ups of 2023
🛎️ Bookmark saved filters in Trello
⚡[PREMIUM] Complete checklist items when a card is moved to done
💯 [PREMIUM] Rate my Trello setup
🌮 Dear Taco
This is a section where readers can submit their Trello questions, and each week I’ll pick one and answer it! It’s like “Dear Abby” but make it trello. Have a question you want to submit? Share it here.
Dear Taco,
I am looking for a way to put the current daily weather forecast on the cards that we are using for business. I found you on youtube and very impressed with Trello and all your videos! I got your book and currently reading that to get up to speed everything Trello. We are looking to use Trello for daily logs for a construction company. We would like to be able to add the weather forecast in order to show the clients why there might be a delay or why certain items were not delivered to the job site. Any help is appreciated. Thank you.
Oooh this is a fun one! So this is possible, but a bit advanced, so stick with me.
Also disclaimer: I can’t actually get this to work at the moment, but it really should. I’ve filed a ticket with the Trello team to track down the answer to this, and if you’re like YES THIS IS THE SOLUTION FOR ME, reply back and let me know and I’ll let you know what I find out.
So, there’s no Power-Ups that do this, but there’s a hidden escape hatch in the Trello automation actions that will let you interact with other tools. Pick any of the triggers (in your case it might be “every day”, or it could be a card button that you click), and go to the “Content” group and look at the very bottom.
That “get” url field lets you make an API request to fetch data, and then use the response from that API to do other actions, like post a comment!
I just looked at https://openweathermap.org/ and they have an API you can use to fetch data about the weather. You can read their docs to learn more about what all you can get from them.
So let’s say you have custom fields on cards called Lat and Lon that hold those values, you can paste something like this in that [URL] field on the action to reference a card’s custom fields and get a response with the weather.
https://api.openweathermap.org/data/3.0/onecall?lat={{%Lat}}&lon={{%Lon}}&appid={YOUR-APP-ID}
Then, you’d add another action for posting a comment (or wherever else you’d like it) with the weather. With this specific API, you might do something like:
Temp: {httpresponse.current.temp}
I created a button on a card called “Get Weather” to do this, so whenever I click it, it gets the values from Lat and Lon and then pings the API and posts a comment with info from the response!
A bit technical, but unfortunately about the best I can offer 😭 But that is a great idea for a Power-Up!
Want to submit your question? Maybe it’ll be featured next week!
🗞 New(s) and Links
Livestream next week featuring Robin Warren from Blue Cat! Every year Robin analyzes the data and makes a report of the top growing Power-Ups of the year, and this year we’re going to go through the report together - live!
Join us on Monday morning at 9 am CST/10 am EST to watch us chat through the Power-Ups, demo a few, and speculate about their growth!
You can watch on YouTube or LinkedIn!
🛎️ Trello Tip of the Week
This is a new section! I’m going to share a super simple and quick Trello tip. It might be a keyboard shortcut, it might be a hidden feature, or it might just be an idea. But it will help you with your day-to-day Trello activities!
Wish you could save filters in Trello boards? You kinda can. When you add filters, notice the url changes. You can bookmark that url and come back to it anytime to see the same filters applied.
Special shoutout to my premium sponsors!
Thanks to:
Mike Day -
🎉 New Website 🎉
Trello Consulting done differently
Gmail by Cardbox
Integrate Gmail and Trello Effortlessly with Cardbox – The Ultimate Email Management & Collaboration ToolTurn Trello into a business hub with robust Power-Ups for recruitment, customer support, employee directory, knowledge base and more.
The best all in one power-up for planning, tracking and managing work across boards. Use extended board, dashboard and Gantt views and setup card mirrors across boards
Unito
Connect Trello to other tools through Unito's deep two-way integrations and build powerful workflows. Keeping work tools in sync shouldn't require dozens of Zaps. Build one Unito flow instead.Make the review and approval process an absolute breeze with Approvals for Trello, and say goodbye to never-ending email chains and having to chase your teammates for feedback.
Email in Trello
Organize & automate your Email in Trello. Connect any Trello board with Gmail, Outlook, Yahoo & more.
The following content is only available for Premium Subscribers. Upgrade to a monthly or annual subscription for Trello goodness!
Keep reading with a 7-day free trial
Subscribe to How I Trello to keep reading this post and get 7 days of free access to the full post archives.