Running Successive Pipes

Does anyone know if it’s possible to run pipes in succession?

For example: I have a name field (FIRST LAST). I want to replace the space with an underscore with replace(' ', '_') and then take the results and make the string lowercase with toLowerCase(). End result would be: first_last.

I think it should be possible. Have you tried using two rules, one to do the first step and the other to do the second step?

I haven’t tried but I’ll take a look.

So you definitely can run two pipes in a row and they will execute in order. I’m not sure if your equation will work because I haven’t use the search & replace pipe before so I’m not sure how to set it up. Here is an example I setup to test if the idea works:

  • I created 3 fields in the table (Name) (Pipe Result) & (Pipe Result 2) 1

  • I created a rule and used the text utility pipe to count the words in the name. In this case, the answer is 2 (first and last). and set the (Pipe Result) to the response Value

  • Then I made another rule and used the advanced math pipe to multiple (Pipe result) by 5 and set the (Pipe result 2) to the Response value

Worked like a charm.


@SuiteUpstairs is 100% right.

The only functions you can daisy chain are the text utilities.

For example, you can combine multiple functions together like so:


As you can see here:

Thank you both!

@SuiteUpstairs That was my thought as well to use a record field to hold temporary values. I’ll have to play around with it more but it seems one temp field doesn’t work; having the pipe read the record value, do the operation, then save back over the top of the original temp value. I’m not 100% sure on that, but I’ll experiment.

@moe That’s a very nice gem you posted! Text operations are something I can see doing a lot of so being able to chain those would be helpful. Thanks for posting that! I’ll be exploiting that feature for sure!