CMS Development

RTse
Member

Custom Formula Escape Character?

SOLVE

I'm creating a workflow with a custom formula data format step.

 

I'm using the formula right(cut(cut(cut(cut(cut(trim([enrolled_object.phone]), "(") ")"), "*"), "#"), "+"), 12).

 

But I'm getting this issue:
There was a problem with your formula. We were expecting a valid function or value expression but found " instead.

 

It seems like the "(" and ")" need an escape character.


How do I resolve this?

0 Upvotes
1 Accepted solution
SteveHTM
Solution
Key Advisor | Partner
Key Advisor | Partner

Custom Formula Escape Character?

SOLVE

@RTse - looks like you are simply missing a comma in the formula - after the "(")

 

Hope that its simple!

 

Steve

Steve Christian

HTM Solutions

https://info.htmsolutions.biz/meetings/stevec2

mobilePhone
+1 6195183009
emailAddress
stevec@htmsolutions.biz
website
www.htmsolutions.biz
address
San Diego, CA
Create Your Own Free Signature

View solution in original post

0 Upvotes
1 Reply 1
SteveHTM
Solution
Key Advisor | Partner
Key Advisor | Partner

Custom Formula Escape Character?

SOLVE

@RTse - looks like you are simply missing a comma in the formula - after the "(")

 

Hope that its simple!

 

Steve

Steve Christian

HTM Solutions

https://info.htmsolutions.biz/meetings/stevec2

mobilePhone
+1 6195183009
emailAddress
stevec@htmsolutions.biz
website
www.htmsolutions.biz
address
San Diego, CA
Create Your Own Free Signature
0 Upvotes