Forming the pattern for a report created using the Schedule Command in Butler

[Sarah Mayo]

I need help forming the pattern for a report created using Butler's Schedule Command.

My report is generating successfully, but only the "- [{cardname}]({cardlink})" part is rendering the way I want; none of the other variables are rendering. Can someone help me fix the pattern?

This is what I've entered into the pattern field:

- [{cardname}]({cardlink}) - ({labelname} when a yellow label is added) - ({labelname} when a pink label is added) \n\n\n
--- {checklistitemname} when the name of a checklist item starts with "Offers Due Date: "\n
 | {checklistitemname} when the name of a checklist item starts with "Funds Due Date: " \n\n\n
--- {checklistitemname} when the name of a checklist item starts with "CrowdStreet Equity Allocation Goal: "\n
 | {checklistitemname} when the name of a checklist item starts with "Max Allocation (target in portal): " \n \n

This is how it renders in the email:

This is how I WANT it to render in the email:

Hunter Meece - live:

• 61 State Street (Spaulding & Slye) - (IRM - Hunter) - (Hospitality)

--- Offers Due Date: November 12 | Funds Due Date: November 15

--- CrowdStreet Equity Allocation Goal: $3,159,215 | Max Allocation (target in portal): $5,131,150

• Colorado Springs Office Portfolio (Flywheel Capital) - (IRM - Hunter) - (Office)

--- Offers Due Date: 11/18  | Funds Due Date: 11/21

--- CrowdStreet Equity Allocation Goal: $3mm | Max Allocation (target in portal): $10,714,320

Thank you!

[Iain Dooley · Accepted solution]

@Sarah Mayo it looks like what you're doing is trying to use logic inside the report text. That's not possible. Also you can only use card variables, that is to say that the variable "{labelname}" has no impact because the report deals with cards which may have any number of labels. In other words you're "looping" through a list of cards, not a list of labels, so the only relevant variables are those that are inherent to every card (such as name, link, due date, custom field values and so on).

For the type of custom report you're looking for you wouldn't be able to use Butler, but you could do something like this in Trellinator:

https://gist.github.com/iaindooley/5fc0437ac68aa39589cbe56cad65d5b1

You can read more about Trellinator here:

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

[Sarah Mayo]

This was really helpful, thank you for the quick response! I'll check out Trellinator.