You need to sign in to do that
Don't have an account?
Cole Russell 2
Is there an easy way to check if my formula field is considered deterministic?
I am making updates to a specific formula field that is currently indexed. After I made the changes the field is no longer indexed (which is normal) and I contacted Salesforce Support to index the field again. They said the formula field no longer met the requirements to be indexed and after looking at the reference material I'm not sure what change I made caused this. Is there an easy way to check my formula and make sure it can indexed by Salesforce Support?
https://developer.salesforce.com/blogs/engineering/2013/02/force-com-soql-best-practices-nulls-and-formula-fields.html
It looks like our team of experts can help you resolve this ticket. We have Salesforce global help-desk support and you can log a case and our Customer Success Agents will help you solve this issue. You can also speak to them on live chat. Click on the below link to contact our help-desk. Trust me it is a support service that we are offering for free!
https://jbshelpdesk.secure.force.com
Thanks,
Jarvis SFDC team
Here are examples of common non-deterministic formulas. Force.com cannot index fields that:
- Reference other entities (i.e., fields accessible through lookup fields)
- Include other formula fields that span over other entities
- Use dynamic date and time functions (e.g., TODAY, NOW)
A formula is also considered non-deterministic when it includes:- Owner, autonumber, divisions, or audit fields (except for CreatedDate and CreatedByID fields)
- References to fields that Force.com cannot index
- Multi-select picklists
- Currency fields in a multicurrency organization
- Long text area fields
- Binary fields (blob, file, or encrypted text)
Standard fields with special functionalitiesA Custom Index can't be created on these types of fields: