Clientell AI

Create a Formula Field

Use Cases:

  • Create custom formula fields by simply describing your calculation—no syntax needed.
  • Let the system handle the technical details so you can focus on your business logic.
  • Build advanced metrics for your reports without learning formula language.
  • Instantly add new calculations to your CRM by just telling the system what you want.
ConfigurationConsultant

Prompt

Create a formula field Margin_Percent__c on Opportunity: (Amount – Cost__c) / Amount.

Related use cases

~1 min

Update a Picklist Instantly

Add or remove values without touching Setup.

“Add the value Pilot and deactivate Proof of Concept in the picklist Opportunity_Type__c.”

Opportunity_Type__cPicklist
New BusinessActive
ExpansionActive
+Pilot
New
Proof of ConceptDeactivated
RenewalActive
1 added · 1 deactivated

Debug a Salesforce Error

Paste an error. Get the root cause in seconds.

“Apex error ‘FIELD_CUSTOM_VALIDATION_EXCEPTION’ on saving Opportunity — identify which validation rule fired and why.”

FIELD_CUSTOM_VALIDATION_EXCEPTION
Object: Opportunity
Action: Save record
Root Cause
Rule: Require_Amount
Amount must be > 0 when Stage ≠ Prospecting
Set Amount > 0 or change Stage to Prospecting
1 validation rule identified

Block Backward Stage Changes

Stop reps from moving opps backward — except admins.

“Create a validation rule on Opportunity to prevent Stage from moving backwards (e.g., from Proposal back to Qualification) except for System Administrators.”

Validation RuleOpportunity
Qual
Proposal
Nego
Closed
System Admins exempt
Prevents backward stage movement

Related How-To Guides

How to Create Formula Fields in Salesforce

Learn how to create formula fields to calculate values, combine text, or perform logic without writing code.

How to Manage Salesforce Fields

Learn how to create, modify, and manage custom fields in Salesforce to capture the data you need.