• Marion Drevet
  • NEWBIE
  • 0 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 1
    Likes Given
  • 1
    Questions
  • 1
    Replies
I have created a webform under http://mycompany.force.com/quamelia
I have created a custom URL http://www.webform.mycompany.com from which I want to redirect to http://mycompany.force.com/quamelia
I want the client to be able to see only the URL http://www.webform.mycompany.com even after the redirection.
My IT support tells me they can redirect from http://www.webform.mycompany.com to http://mycompany.force.com but not to http://mycompany.force.com/quamelia
How do I do that?
Thanks in advance
We use Salesforce and the Marketing Cloud. In SF, we're using the standard phone field which is formatting numbers as such (XXX) XXX-XXXX. To use SMS in the MC, I have to reformat the phone as follows 1-XXX-XXX-XXXX when the student is from the United States. I'm using the follow CASE function in SQL, but can't save the query without getting an error.

CASE WHEN a.Phone LIKE ('(%') THEN ('1'+'-'+ SUBSTRING(a.Phone,2,3) +'-'+ SUBSTRING(a.Phone,7,3)+'-'+ SUBSTRING(a.Phone,11,4)) as Phone
END

I'm trying to determine if the phone starts with a parenthesis and then format it correctly if it's true. Any ideas? a.Phone comes from a Data Extension that has the Salesforce phone in it.
We use Salesforce and the Marketing Cloud. In SF, we're using the standard phone field which is formatting numbers as such (XXX) XXX-XXXX. To use SMS in the MC, I have to reformat the phone as follows 1-XXX-XXX-XXXX when the student is from the United States. I'm using the follow CASE function in SQL, but can't save the query without getting an error.

CASE WHEN a.Phone LIKE ('(%') THEN ('1'+'-'+ SUBSTRING(a.Phone,2,3) +'-'+ SUBSTRING(a.Phone,7,3)+'-'+ SUBSTRING(a.Phone,11,4)) as Phone
END

I'm trying to determine if the phone starts with a parenthesis and then format it correctly if it's true. Any ideas? a.Phone comes from a Data Extension that has the Salesforce phone in it.