Apex Code Development You need to sign in to do that
Don't have an account?
aq_dev Custom Formula Help
So I have created a custom formula field that displays a series of fields in a text box for us to copy and past into an email for quicker use.
Our problem is that one of the fields I have inserted is an email field and for whatever reason the hyperlink has extended and bled into the next inserted field which is a simple text field.
Example...
Student Name: John Doe
Student Email: John@yahoo.com
Parent Name: Jane Doe
State: NC
Home Phone: 111-111-1111
Parent Email: Jane@yahoo.com
Here is my formula....
("Student Name: "+ Name )+
BR() + ("Student Email: " + Student__r.Email)+
BR() +( "Parent Name: " + Parent_Name__c )+
BR() + ("State: " + State__c) +
BR() +("Home Phone: " +Home_Phone__c )+
BR() +( "Parent Email: " + Parent_Email__c)
As you can see I've tried to bracket each line to stop this but nothing seems to work.
PLEASE HELP
I'm not sure what's causing it, but have your tried to "force break" it by inserting a value that is invalid in a URL.Email?
like this:
("Student Name: "+ Name ) + BR() + ("Student Email: " + Student__r.Email) + " " + BR() +( "Parent Name: " + Parent_Name__c ) + BR() + ("State: " + State__c) + BR() +("Home Phone: " +Home_Phone__c ) + BR() +( "Parent Email: " + Parent_Email__c)All Answers
I'm not sure what's causing it, but have your tried to "force break" it by inserting a value that is invalid in a URL.Email?
like this:
("Student Name: "+ Name ) + BR() + ("Student Email: " + Student__r.Email) + " " + BR() +( "Parent Name: " + Parent_Name__c ) + BR() + ("State: " + State__c) + BR() +("Home Phone: " +Home_Phone__c ) + BR() +( "Parent Email: " + Parent_Email__c)Thanks so much for the help. Still don't know why it did that but your solution worked!
No problem, you owe me a beer!
Cheers
PS. I like to drink these
http://beeradvocate.com/beer/profile/863/7971