So here is an odd question. On our Opportunity object we have a formula field. Is there anyway to pull in the actual formula calculation through any API, APEX, REST, SOAP? I have an iOS app and a requirement is to have the UI update according to the formula. My only option at this point seems to be copying that formula to the client-side, but then if it ever changes then the app needs to be updated as well. However, if I could pull in the formula from Salesforce then I could dynamically generate it. So is it possible?
[SalesForce] Formula Field from REST Service
Related Solutions
You can remove the requirement for the security token based on IP address, either at the organization level or the Profile level. If all of the users of this app are the same Profile, add a Login IP Range (at the Profile, not Organizational level) that includes the IP addresses they will be using. You could even add the range 1.0.0.0 through 255.255.255.255 if you want. I would recommend making this range as narrow as possible, but with mobile apps that may not work out.
It almost goes without saying that if you do this you're disabling a big part of Salesforce security.
The response will return the API Name of the field in the "fields" array of the response. But only if the Error Location of the Validation Rule is configured correctly.
The Field needs to be selected from the picklist when creating (or modifying) the validation rule. This is shown in the screenshot below
When I violate the example validation rule above, my json response is:
[ {
"fields" : [ "BillingCity" ],
"message" : "This Billing City is a bad choice, please select another.",
"errorCode" : "FIELD_CUSTOM_VALIDATION_EXCEPTION"
} ]
So as long as the Error Location on each Validation Rule is specified as 'Field', you will be able to place the error message next the right field in your mobile app.
Best Answer
Sure it's possible. The
DescribeSObjectResultresponse in the SOAP API includes an array ofFieldobjects, and formula fields will have aformulakey that contains the formula for that field.Of course, parsing that formula into logic your client can evaluate is an entirely different massive undertaking, but the foundation is there...