New answers tagged dml
1
Salesforce has several useful APIs for getting data in to, and out of, Salesforce, available on a cornucopia of platforms. Simply use a search engine with something like "[some application] salesforce integration." For example, I found the Data Connector for Salesforce app that integrations Google Sheets with Salesforce by typing google sheets ...
4
PATCH requests to the sObject Rows REST resources are documented to return no body:
Example response body for updating fields in an Account object
none returned
You should be looking at the result status code for a 200-series HTTP status to determine the outcome of your call.
Additionally, you should not write new code against the ancient API version ...
2
This code is definitely not the right solution in some way or another, but it's not clear exactly what. As Kris points out in the comments, the obvious and almost certainly correct solution is a formula field: no code at all.
If for some reason a formula field is contraindicated, which seems like a stretch to me, the correct solution is almost certainly a ...
1
You can't put a DML in a loop; you'll hit an exception if you try to update more more than 150 records this way.
You should query only records that have the checkbox checked to avoid the if statement, and reduce governor limit usage.
You didn't query Value2__c, so you can't use it in your calculations.
You don't need to query a field that you don't intend to ...
Top 50 recent answers are included
