How do I change phone format

Question

How do I change phone format (999) 777-4444 to 9997774444 so i can use it in my pipeline for an outgoing request

MarkShnierYou · Accepted Answer

Or make a formula in native Quickbase.

var text Tel = ToText([Mobile for Drug test Notifications]);

var text RemoveBracketOne = SearchAndReplace($Tel,"(","");

var text RemoveBracketTwo = SearchAndReplace($RemoveBracketOne,")","");

SearchAndReplace($RemoveBracketTwo,"-","")

DonLarson · Answer

I have not tried to change a phone number format in a Pipeline but here is the article on transforming data.

https://helpv2.quickbase.com/hc/en-us/articles/4473004144660-Transforming-your-data

I suspect you need to change it to a string. That would look something like

{a.phone|string()}

I have not tested that one but will give it a look.

Sign up