Using Butler Wildcard with paragraphs of text

Deleted user February 24, 2023

Hey folks,

 

CONTEXT

I am working with order fulfilment in Trello, from cards that have automatically generated descriptions.

My desired outcome is to populate custom fields with the customer's FIRST name, LAST name, and email address.

I know how to do that using wildcards in Butler rules, BUT unfortunately the auto generated description repeats the information twice.

 

PROBLEM

The automatically generated description in the card repeats the customer information (this is out of my hands. UGH) , this means the wildcard pattern I had thought to use isn't working. 

 

For example:

 

Order No. X

Thank you for your purchase blah blah etc etc

A full paragraph of information

Another full paragraph of information

Customer Information Tara Thomas email@emailaddress

 

You just received an order! This is a copy of the email that your customer received.

Order No. X

Thank you for your purchase blah blah etc etc

A full paragraph of information

Another full paragraph of information

Customer Information Tara Thomas email@emailaddress

 

MY QUESTION

I'm thinking that a workaround might be to use a Butler rule with wildcards to say;

post the section from the unique phrase "You just received an order!" to the end of the description, as a comment.

Then I can reference the comment to populate the custom fields. I had thought to use Butler wildcards but can only work out how to create a pattern per word? That seems unwieldy.

How do you create a pattern for a paragraph or sectoin of text vs/ individual words?

Like;

 

Order No. {*}

Thank you for your purchase {single wild card that covers all of the text up until the unique sentence "You just received an order!"}

 You just received an order! This is a copy of the email that your customer received.

{single wild card that covers all of the text up until "Customer Information"}

Customer Information Tara Thomas email@emailaddress

 

I am an absolute selftaught Frankenstein in Butler so I'm open to other suggestions, please keep in mind that more advanced coding solutions are likely to blow fuses in my brain!

 

Notes for search terms;

The workflow I have is;

1. The free version of square online sends an order notification for a digital product to my gmail

2. A gmail filter applies a label to describe the product

3. A zapier zap sends the gmail to Trello as a card, using the email body as the description

4. A Butler rule draws the customer information from the description to populate custom fields (this was the step my question relates to)

5. The custom field for product triggers card to move to list with appropriate product title

6. Butler rule sends an Email using Sendboard for Trello to send the customer an email with the link to download digital product.

1 answer

0 votes
Deleted user February 24, 2023

Okay, so I have found a solve. The Butler rule is;

when the description of a card in list "Incoming Orders" contains "Customer Information {* } {* } , {* } {* } Customer Information", set custom field "First" to "{wildcard1}", set custom field "Last" to "{wildcard2}", and set custom field "email" to "{wildcard3}"

 

It doesn't seem to matter that the entirety of the sequence Customer Information - Customer Information is repeated... so that's rad!

 

Not sure of ettiquette but thought I'd leave this here for myself in 12 months when I forget how I did it... or indeed anyone else with same quandary!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events