You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I get a lot of issues generated from my customers datacenters. The issue description contains a table with information that I want to enter in custom fields with automation.
The table can look something like this
Is it possible to fetch through Regex?
The issues are created from incoming e-mails. These e-mails contains a table with all the information I need for custom fields. These field are then used in integrations with other systems.
As there are hundreds of issues created, it would be great if I can create an automation that fills the custom fields.
Hi @Olof Nysten I think I almost have it :).
I prepared issue with a table:
And I prepared an automation with following setup:
I logged my description to find out what is its format and it was:
|greeting|Hello| |name|Martin| |last name|Bayer|
I hope it will help... :)
@Olof Nysten this worked great for horizontal matches, thank you!
I'm using the match function to return numeric values associated to a given month/quarter/year:
A couple questions:
Using the regex noted for horizontal matching, I sum the number associated to each month in the table into a custom field for the respective Q1 total (e.g. Q1= matches for Jan + Feb + Mar, and so on). When I add Jan, Feb, Mar using regex match, the Q1 total shows up fine. :tada:
In the same automation string, I need to sum the now updated quarterly total fields into an Annual Total. I tried this two ways:
In both cases the Annual total field won't update unless I re-edit the description field, so there seems to be an "edit" trigger lag.
Depending on the layout of data in a table, is it possible to perform a vertical match instead of the horizontal solution you provided? Aka instead of using match to pull data to the right, is it possible to pull the data below?
A preferred table layout would be:
| | | | | | |
For a given month, the result is to pull the number entered below it into a custom field once the Description field is edited/updated; using the example the desired return would be "1" when matching for "Jan" or "5" when matching for "May"?