How do I change phone format (999) 777-4444 to 9997774444 so i can use it in my pipeline for an outgoing request
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,"-","")
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.
Qrew LegendOr 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,"-","")
I have tried to stringify it, but that didn't work. I was able to find and create a formula field similar to the solution and that resolved my problem. Thank you!
