Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Trello - Is there any way to import changes to existing cards on a Trello board?

Leya Avalos September 11, 2020

We have hundreds of cards on our Trello board and need to be able to update a custom field on the cards with a unique identifier.

2 answers

0 votes
Iain Dooley
Community Champion
September 12, 2020

@Leya Avalos you can use the API to do it, this Trellinator function will put the card's ID into a custom field on the card:

https://gist.github.com/iaindooley/0b325b1df9a802208125e45354a58062

You just need to update the board name variable at the top

Note that because the custom fields API is so HTTP request intensive, I've used a "setTimeout" to execute one update every 2 seconds so you don't hit the rate limit. 

You can execute that function via BenkoBot here:

https://app.benkobot.com/

You could also assign some different unique ID derived from some other method than just the short ID of the card.

Leya Avalos September 14, 2020

@Iain Dooley can this method be used to assign a unique field value for each card contained in a csv or other format outside of Trello?

Iain Dooley
Community Champion
September 14, 2020

@Leya Avalos it could, but the functionality of BenkoBot is a little trickier in this regard right now because you would have to connect to the external source using a REST API. If you deploy Trellinator via Google Apps Script you can use the same basic code but you have access to the Google Sheets API which is much easier to use, for example if you had a sheet with card link and field value in it this would update the custom field value on the cards:

https://gist.github.com/iaindooley/219df4b476f8d183eb734c718ef88ead

Iain Dooley
Community Champion
September 14, 2020
0 votes
Deleted user September 11, 2020

Yes, there is a power-up to customize your own fields:

 

https://trello.com/power-ups/56d5e249a98895a9797bebb9/custom-fields

 

Hope it will help you!

Leya Avalos September 11, 2020

We use that power-up, but that only gives us a place to put the unique identifier on the card. As far as I can tell, the custom field power-up does not give us a method to mass update the existing cards to have the field filled with the unique identifier needed.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events