Sign Up ›
  • ghallettkp
  • NEWBIE
  • 0 Points
  • Member since 2007
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 2
    Replies
2 replies

Substituting Carriage Return in a Custom Formula Field

I have a custom formula field in contacts that is a hyperlink that opens a new event with information about the contact in the description (long story as to why we're doing this - trust me that this is the way to go...).
 
So, all goes well - I've substitituted spaces for + so that the hyperlink will work. My issue comes when I try to use mailing address. My only choice is mailing address and not mailing address 1, mailing address 2, mailing address 3. When there's a carriage return in the mailing address, the hyperlink doesn't get formed properly. So, the answer is to replace the carriage return with %0D. But, how do I specify the carriage return in the URL? I've tried CHAR(10), CHR(10), TEXT(10), BR() to no avail. I've tried calling Salesforce support but I'm told this area is not supported and I should talk to my developer??? (Side note: I love how salesforce keeps using these features as selling points and then refuses to support them when you run into issues).
 
So, does anyone know what I would use here? Here's what the code looks like ("NEED CARRIAGE RETURN HERE" is where I need the carriage return code:
Code:
HYPERLINK("https://na5.salesforce.com/00U/e—&who_id="&Id&"&followup=1&evt5=Meeting&what_id="&AccountId&"&returl=%2F"&Id&"&evt6="&SUBSTITUTE(FirstName," ","+")&"+"&SUBSTITUTE(LastName," ","+")&"%0D"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Phone, "(",""),")","")," ","+")&"%0D"&SUBSTITUTE(SUBSTITUTE(MailingStreet," ","+"),NEED CARRIAGE RETURN CODE HERE,"%0A"), "Book a Meeting")


Message Edited by ghallettkp on 04-01-2008 12:17 PM
1 replies

URL field

I've created a text custom formula field in contacts which logs a call for that contact. I've done this so it can be displayed in the contacts list view and our telesales just need to click the link to log a call and just go back to their list (rather than having to go into the contact, logging a call and then going back out to the contact list view).

So, right now the url is really ugly and long. Is there anyway I can use HTML in a field to make the URL appear as "Log a Call" only? I tried using a href= in a field with type URL but that didn't work.
1 replies

URL field

I've created a text custom formula field in contacts which logs a call for that contact. I've done this so it can be displayed in the contacts list view and our telesales just need to click the link to log a call and just go back to their list (rather than having to go into the contact, logging a call and then going back out to the contact list view).

So, right now the url is really ugly and long. Is there anyway I can use HTML in a field to make the URL appear as "Log a Call" only? I tried using a href= in a field with type URL but that didn't work.
6 replies

Excel Connector Not recognizing new install/not found

For some reason the excel connector for PE has stopped working and we desperately need some help.

First it worked great, but then it was moved. We then followed the instructions below, deleted all signs of the excel connector on the computer, restarted, re-installed the excel connecter, and did everything possible - but we can’t get the excel connector back to working.

Each time we re-install, re-add the Add-in (or replace it), and then go to re-add the sforce connector toolbar, it gives us the same error that it cannot be found and is still looking for it in the original place it was – the first time it was installed.

Is there any way to fix this?

We’ve been trying everything on the discussion board, including the instructions below from the FAQ and still cannot get it to work.

I already tried this:
Open Excel
Click Tools, Add-Ins
Uncheck the sforce_connect checkbox, click OK
Close Excel
Open Excel again, if the "sforce_connector" menu bar is still there, right click on the tool bar area of excel, uncheck the sforce Connector check box
Close Excel
Open Excel
If the bar is gone and the Add-INs list is showing the add-in as unchecked or gone then you can re-install the add-in from the new file location of the XLA, see the install instructions on the web (http://sforce.sourceforge.net/excel/index.htm)

 

Thanks so much!