function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
jgreene.ax1178jgreene.ax1178 

Field Update formula not working

Hi all!

 

I'm trying to get a field to auto update based upon the formula below:

 

text(Campus__c)&" "&StartDate&" "& Type "

 

It's supposed to update to '(School Location) - 10-23-2012 - Open House'

 

However, the formula isn't working.

 

Thanks for any help!

Best Answer chosen by Admin (Salesforce Developers) 
Santosh KumbarSantosh Kumbar

try this : " ' " &text(Campus__c) & " - " & StartDate &  " - " & Type &" ' "

 

If any Field used in above formula is a type of  Number, Date, DateTime, Picklist then use funtion text(field), that returns you the text.

 

Is startdate standard field? 

 

 

Regards

San

www.santoshkumbar.com

All Answers

Sushant RaoSushant Rao

Are startdate and type custom fields? If it is then they would require '__c' after the fieldname. 
Santosh KumbarSantosh Kumbar

Try this : ' & text(Campus__c) & " - " & StartDate &  " - " & Type & '

 

* If startDate and Type are custom fields then append __c at end for each of this.

 

 

 

Regards

San

www.santoshkumbar.com
jgreene.ax1178jgreene.ax1178

No, they aren't custom fields - they're standard. 

 

And San.k, the formula syntax works, but when I create the record, the EXACT formula shows up in the field, not what the formula is designed to show:)
kamlesh_chauhankamlesh_chauhan

Try this one.

 

TEXT(Campus__c) & " " & StartDate__c & " " & Type__c

 

Please check your StartDate and Type field's correct API name.

 

Regards,

Kamlesh Chauhan, (Founder & CTO)

LogicRain Technologies, (Salesforce and Force.com Development Division)

Cellular: +91-(997) 476-6800 Office: (732) 676-6400 Skype:kamlesh.logicrain

kamlesh@logicrain.com || http://www.logicrain.com || LinkedIn

 

Answers/Suggestions are my own.
If a reply to a post answers your question or resolves your problem, please mark it as the solution to the post so that others may benefit.

 
Santosh KumbarSantosh Kumbar

try this : " ' " &text(Campus__c) & " - " & StartDate &  " - " & Type &" ' "

 

If any Field used in above formula is a type of  Number, Date, DateTime, Picklist then use funtion text(field), that returns you the text.

 

Is startdate standard field? 

 

 

Regards

San

www.santoshkumbar.com

This was selected as the best answer
jgreene.ax1178jgreene.ax1178

Thanks so much!  This works perfectly.  All I had to do was add in 'text' before the startdate and it worked perfectly!

 

Thanks a bunch!