You need to sign in to do that
Don't have an account?
10 digit phone format is not working on flow when i update records
Hii everyone,
10 digit Phone number format is (xxx) xxx-xxxx but i want less than 10 digit then also format should be work. If suppose my phone field have 9 digit 123456789 then i want this type of format like (123) 456-789
is it possible? it should be work between 7 number.
i have formula given below:
IF( NOT(ISBLANK(Phone)), IF( LEN(Phone) >= 7, "(" & LEFT(Phone,3) & ") " & MID(Phone,4,3) & "-" & RIGHT(Phone, LEN(Phone)-6), Phone ), "" )
this formula i use on flow builder its working good when record is created but not working when record is updated. when i updated record format had not correct.
Thanks in advance!