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

Creating a unique ID when a trello card is created?

I am investigating using Trello for our mechanical engineering ECN process. We currently use a spreadsheet with "auto created" id numbers (drag a spreadsheet cell to increment) and this id is entered in documents (e.g. 3d models and drawings) to track the issue.

In trello, i can see i can get the card id - but, ideally, we would have a 5 or more digit number. we have several years of records that started at 00001 and we are currently at about 02000. restarting with trello cards at 1 would be an issue.

as i'm trying things out, i'm not paying for trello - so don't have more than one power-up at any time. is there an existing power-up or work around for this?

many thanks.

tony

2 answers

0 votes
Iain Dooley Community Leader Apr 20, 2019

@Anthony Boyd there is a card number power up but the numbers don't persist if you move the cards between boards so it's a bit inadequate.

The short ID of the card is a good choice, it's not too long and it's always unique and it persists between boards.

Using Butler you could set it on the front of every card like this:

When a card is created set custom field value "Project ID" to "{triggercardid}"

If you're looking to create a persistent, sequential numeric ID you'd really need to keep a register of them somewhere like in a Google Sheet or maybe in a Trello card that was used for that purpose. I'm not sure if you can do arithmetic with custom field values in Butler, you might be able to do something like fetch the custom field value from a "last id" card and add 1 to it, then set the custom field value on the created card.

@Katrin Anger do you know if you can do arithmetic like that with custom field values? Or do you have another suggestion?

Here's the same thing done in Trellinator:

https://gist.github.com/iaindooley/d43df0db37142c72f0850f4e2101b77f

You could install the setNewCardId function on a single board, or globally. It will initialise itself and create the required board/card and enable the custom fields power up wherever required. It currently initialises to 02000 the first time you create a card with it.

You can see how to set up Trelinator here:

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

0 votes
Katrin Anger Community Leader Apr 29, 2019

@Anthony Boyd @Iain Dooley 

I know that setting numeric custom fields does support arithmetic operations.

However, reading the use case above, I would rather suggest to make use of user variables with Butler for Trello that lets you store the auto-created id numbers on the cards.

Suggest an answer

Log in or Sign up to answer
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