I have a problem. I have modified to calculate some fields in an form, they are only calculate when I open and save a record.
Form include Fields with:
Calculated type.
Simple type: calculated by JavaScript when user load and save form.
How can I recalculate for all old records without open and save form? values will recalculate/display in views correctly.
Is there any batch job to do that?
Thanks.
In that case I think JavaScript won't be a correct option to go with.. Can you not perform the same calculation using Workflow and fire it on-demand for selected records?
In that case I think JavaScript won't be a correct option to go with.. Can you nit perform the same calculation using Workflow and fire it on-demand for selected records?
I tried your idea, onChange fired when I open form and change temp field, but when I tried to use bulk update 2 records on view, the event is not fired. The script could be not triggered. Do you have any idea?
Thanks you, I will try bulk update as you suggestion
When I open any record and save, this field is calculated. (Execute JavaScript)
When I check old records in view (list), this field is empty.
How can I update to calculate old records without open and save form?
As it is a simple field, you can make use of your JavaScript function to trigger it on change of your temporary field,
Mark answer as verified if it resolved your problem.
Data type: currency
Field type: Simple
The field is calculated in JavaScript (form load and save event)
Firstly, can you confirm what is the datatype of that fields that you want to modify? If you can send the screenshot of that field that'll be ideal.
How is the simple field calculated by javascript when form load and save ? it's calculated auto?
Hi,
Calculated fields are computed on database level, and they are automaticaly updated on views and forms. We don't need to recalculate that information.
But if you want to recalculate your rollup fields, you may need use CalculateRollupFieldRequest.
docs.microsoft.com/.../microsoft.crm.sdk.messages.calculaterollupfieldrequest
Here is a good blog about the difference.
community.dynamics.com/.../dynamics-crm-calculation-amp-rollup-fields
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156