Recalculate formula fields via SQL
As a developer it is sometimes easier and more efficient to update data directly in SQL instead of using one of the API's like Maximizer.Data and Maximizer.Web.Data
At the moment if there is a formula field that references a field/UDF that I update/insert/delete directly in SQL it does not update in Maximizer.
We could also update the formula values in the SQL manually, but we have to rely on the users to tell us what fields are formula and what the formulas are. Then expect them to remember to tell us when they change them.
A stored procedure that recalculate the formula UDF's that reference a certain field would be useful.
We are committed to making Maximizer work for both public cloud (CRM LIve) and private cloud (on premise). The only way to make that work is through API’s. We use the API’s ourselves so will continue to evolve them. Please use the dev.connect forum to ask any questions about the API’s if you need more insights to help do the work that you need to do
-
Peter Somogyi commented
I also have an extensive customization for a customer that uses SQL to insert/update/delete UDF values. Updating formula fields is an essential part of this customization. A stored procedure would be ideal to force formulas to update.
-
Jeff Brown commented
I think having the UDF formula recalculate automatically every time the record is viewed would help.