You need to sign in to do that
Don't have an account?
cldave
Workflow Task: Update Field using a formula
I'm trying to populate a custom email field on leads by combining the values of the standard fax field and adding "@smartfax.com"
Results would be: 1+fax#@smartfax.com
it's just i have no idea how to formulate this formula in the workflow update field formula editor? or any other way?
Thanks in advance.
That example worked beautifully. Here's the code:
"1" & MID(Fax,2, 3) & MID(Fax ,7,3) & MID(Fax ,11,4) & "@smartfax.com"
Just replace your fax field in the "Fax" one above.
All Answers
The formula should just be: Fax_field__c & "@smartfax.com"
Thank you for quick answer, that did work but it cause a problem:
here's an example of what got populated:
Try this:
1 & TEXT(Fax_field__c) & "@smartfax.com"
Sorry, that won't work since you can only use TEXT on a picklist, number or date field. Since it is coming back as text, try using FIND and SUBSTITUTE functions.
Example: SUBSTITUTE(Email, LEFT(Email, FIND("@", Email)), "www.") finds the location of the @ sign in a person's email address to determine the length of text to replace with a “www.” as a means of deriving their website address.
Thanx, but i'm having some problem still, what you told me sounded like chines at first, than i start playing around, got to a partial formula but i can't seem to have it work
SUBSTITUTE(Fax, LEFT(Fax, FIND("(", Fax)), "1")
so i figured this take out the left paranthese "(" but how do i do that again with the right paranthese, the space between area code and phone # and the dash and Add the @smartfax at the end
ex: (866) 123-4567
If you could write the formula for me i would really appreciate it (as you can see it is not my forte ;-)
p.s i found this on the help on formula, tried it but did not work for me
Unformatted Phone Number
This formula removes the parentheses and dash characters from North American phone numbers.
This is necessary for some auto-dialer software.
IF(Country_Code__c = "1", MID( Phone ,2, 3) & MID(Phone,7,3) &
MID(Phone,11,4), Phone)
maybe that is the solution but i gives me an error when i put it in
That example worked beautifully. Here's the code:
"1" & MID(Fax,2, 3) & MID(Fax ,7,3) & MID(Fax ,11,4) & "@smartfax.com"
Just replace your fax field in the "Fax" one above.
ty vm Strong it worked!!!
I rellay appreciate your help
:-)