How can i lookup and copy the value of a specific custom field from a linked card?

[Femke Lucassen]

Hi

i have 2 boards

1: names

2: projects

the cards are linked together by card name

on board name there is a custom field action set to yes or no.

on board projects, when a green label is added to the card, i want butler to lookup the value of custom field action in the linked card, and copy the value to the same custom field on board projects.

so far i did not had any luck yet. is there a variable available to lookup the customfield value in a linked card?

thanks

Femke

[Mike - Dreamsuite Consulting · Accepted solution]

Hi @Femke Lucassen 

Trello lookups are limited to card name, card description, dates and labels.

But, there is a workaround that involves the 2 automations below:

Automation 1 - Projects Board

when a green label is added to a card, lookup the first card linked in attachments and add a green label.

Automation 2 - Names Board

When a green label is added to a card with custom field "Action" set to "regex:/Yes|No/i", remove the green label, find the card "triggercardlink" and set the custom field "Action" to "{matchedtext}

[Femke Lucassen]

Yes thank you! the label trick did it in combination with the regex.

i feel like Regex can cover lots of my issues which i cannot sort in the general automations. by chance any good source to learn the regex language?

thanks

[Mike - Dreamsuite Consulting]

Top tip with regex, AI does a brilliant job with it. Just describe what you are wanting to do and it'll give you the regex code, most times it is spot on too...

You can test it using:

https://regex101.com/ 

You can learn a bit more about regex here:

https://www.regular-expressions.info/quickstart.html 

Here are some articles I wrote a while back with Trello regex examples:

https://community.atlassian.com/forums/Trello-articles/Mikes-Trello-Tips-Automation-to-truncate-a-numeric-custom-field/ba-p/2385182 

https://community.atlassian.com/forums/Trello-articles/Mikes-Trello-Tips-Round-Custom-Field-Number-Up-%EF%B8%8F-or-Down-%EF%B8%8F/ba-p/2505991 

[Femke Lucassen]

thanks mike, will look into them