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
ElcalvoMikeElcalvoMike 

Using custom fields in custom field formulas

I feel like this should be pretty simple, yet I cannot get it to work.
 
I have a Job Description field (the API field name is Job_Description__c) and I want to create a short description with just the first 20 characters.
This field is populated from  a Web to Lead form.
so..
 
LEFT(Job_Description__c,20)
 
But the syntax error always comes up : Cannot find field Job_Description__c.
 
Can I not use a custom field in another custom field formula?
 
Mike
Jeff TalbotJeff Talbot
Description, long text area custom fields, & multi select picklists cannot be used in formula fields.
ElcalvoMikeElcalvoMike

Unfortunately, I cannot use any custom fields, regardless of thier type, in a formula of a new custom field.

Always get, Field does not exist.

See pic, Quantitiy__c is a Text 50 field and it doesn't work either.
JakesterJakester
Hi Mike,

Default value fields can't reference other fields on the same object. If you have Enterprise Edition or higher you could make a workflow that would automatically update this field when the record gets created and anytime the source field changes.
ElcalvoMikeElcalvoMike

Fantastic, just what I needed to know.

Will work on that!

 

Much appreciated.

 

Mike

 
justajaynejustajayne

Thanks Jakester!

 

You also helped answer part of my question as well :)

 

O' Happy Day

Thanks again
ElcalvoMikeElcalvoMike
Remember to activate your Workflow after creating it. Made that mistake.
justajaynejustajayne
will do thanks :)