You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
We use Trello daily for our Focus Room and Top Actions. We also use it for new hires, and we manage their first 90 days with checklists of actions to get accomplished. I'm looking for a way to create a list (Excel seems like the easiest) of actions, dates and members then dump those into a checklist and have it create the individual items in the list.
I can do this for checklists without dates and assigned members, but I need to do this with the dates. The issue is we have 30-40 actions. They start on day 1 of the new hire onboarding, and I would prefer not to have to go item by item to add dates and owners. Is this possible? I can't find anything to help.
I have worked with advanced checklist in several projects. The most recently is MirrorSync that supports advanced checklist.
I cannot recall a power up or services that does it. It is definitely achievable with code. Creating it on a existing card would be more challenging vs create a new card with the checklist.
One of the requirements is to ensure there is a proper translation of the assigned member to the idMember and a properly structured date.
I will insert here a service I built to created new cards with existing custom fields. The same concept can be applied to creating a checklist.
I have another project that turned numbered list into a checklist via an email. I would imagine that it can be enhanced to inspect each item for @username %date before creating the checklist on the card.
While I'm not as robust a user in Trello, I have some experience with different applications and automation? Where would I start to learn to use code to accomplish this on my own?
So far, I'm trying Zapier. I can use Excel to add items to the checklist, but I can't find a way to assign due dates to those actions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In Zapier you would probably be looping through an array to create the checklist. You will need to insert some code after the built, if possible, to update the items with idMember and the due date. I just checked Trello API for checklist, I am not 100% that has has the ability to update the idMember and due on an item. I am using a python wrapper but in Zapier you cannot import that library. So you need to pass the data to an endpoint to handle it for you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Completed converting my email2board to handle the above.
A bit more work will need to be done to parse out the username and dates since I assumed that there is only 1 space between item name, username and date.
Update : more intelligent parsing implemented, with a register for board and user credentials
If you are interested in test it drop me a note. My profile page has my contact.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just created this documentation for this project "Email to Advanced Checklist"
https://github.com/xu2xulim/Trello-Email/blob/master/Solutions/Email%20to%20Advanced%20Checklist.md
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Zapier has a transfer feature that allows you to load data from Sheet or Excel and otheres. It can call a post request to create the Advanced Checklist with assignment and due dates. It requires a premium plan on Zapier/
An endpoint would look something like
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.