RobHenderson
Quickbase Staff
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Difference between "Apply Regular Expression" and "Find all matches to Regex" in pipeline text stage
Hello Andrew, You are definitely on the right path, as using regex is exactly how I would recommend doing that. If the output is not showing in the activity it is because it's not finding a match. This is just a guess but one thing that's easy to overlook is the formatting of the email. What the regex actually looks at is the code behind the email, so that includes formatting things like html tags and whatnot. I would double check the output of your trigger step to see exactly what the regex needs to be compared against and see if that requires any change in your regex formula. If this isn't what's going on or you would like a hand at this, please open a support case with your CSR ID# and Pipeline ID and link to this article, the agent will escalate it up to me and I'll be happy to take a look into it for you. Hope that helps, ------------------------------ Rob Henderson for ------------------------------64Views0likes1CommentRe: Calculate a future date in a pipeline
Hello Julie, An easy thing to miss is that in Jinja (which Pipeline uses) when you are doing calculations like that, they should be within the same curly brackets. This is very different than how Quickbase functions work. For example: if a.value = 5 b.value = 2 {{a.value + b.value}} comes out to 7 If you put in {{a.value}} + {{b.value}} it will print the literal text of "5 + 2" This is why you are getting that error, instead of a time stamp, it is returning the text: "2021-07-13 00:00:00+00:00+ Days(14.0)" Specific to your use case, I would recommend the following: {{a.complete_date + time.delta(days=b.maintenance_interval)}} Information on how to work with dates in Pipelines can be found here: https://help.quickbase.com/pipelines/working_w_date_time.html I hope this helps! -Robert Henderson Support Integration Engineer for Quickbase ------------------------------ Rob Henderson ------------------------------22Views0likes0Comments