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

[Leya Avalos]

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.

[Rémi BERNIÈRES]

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]

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.

[Iain Dooley]

@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]

@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]

@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]

@Leya Avalos you can read more about setting up Trellinator in Google Apps Script here:

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