Removing Email address formatting for extraction and filling a custom field

Oliver Rathonyi-Reusz September 13, 2024

Hello!

I have a jotform set up to automatically populate the description of a Trello card with the form answers.  The first answer is an email address which shows up in the description formatted/clickable link.

I have an automation set up to extract that email address and populate it to a custom field where it is to be used by another automation.  However, when the automation pushed the email address to the Custom field it comes in the format 

 

[example@abcd.com](mailto:example@abcd.com "‌")

 

My second automation that needs the email address from the custom field needs it as plain text eg.

example@abcd.com

 

Anyone know how to extract the email from the description as plain text?

 

Thanks in advance.

1 answer

0 votes
Renato Fagaraz
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
September 26, 2024

Hi, @Oliver Rathonyi-Reusz

It seems you're delving in a more advanced area of Automation, congrats!

For these, I'd recommend checking our Wildcards article, as they might help you find a condition to extract exactly the text of the email you're looking for https://support.atlassian.com/trello/docs/pattern-matching-and-wildcards/

As you might have noticed, wildcards are a basic level of using Regex (regular expressions) to match specific pieces of text. If you're looking for more complex matches I'd recommend looking for a Regex tutorial as that can prove to be an invaluable industry tool to have under your belt, and quite useful in situations like you're seeing.

Hopefully that helps! 

Oliver Rathonyi-Reusz September 26, 2024

thank you - I also feel that is where the answer lies, but it's quite a learning curve.  If I get to the point where I can make something work, I will post it!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
AUG Leaders

Atlassian Community Events