Autocalculate javascript field from excel importing

Like (1) Share

Report

Posted on 9 Jun 2023 09:39:54 by Gardagantxo2007

Hi,

I have an entity with a calculate field that onload event form gets a javascript value. It works fine manually record creation. But importing from excel....

I need to import using this excel template lots of records. It works, but...... this javascript calculate field does not refresh

I have to edit each record and save it again with out changes. After, once in every year, those records had to recalculate (Programmed Process task)

My 2 question:

- Is possible to update the field value during the import?

- Is possible to create a bussiness process to refresh selected records?

Thanks in advance

All responses (1)

Answers (0)

Martinius 10 on 18 Sep 2023 at 17:18:21

Like (0)

Report

Autocalculate javascript field from excel importing

Yep, you can update the calculate field value during the import and create a business process to refresh selected records. Just use the Data Import Wizard to import the data from Excel into Dynamics 365 and specify the calculate field as a mapped field.

What about creating a business process to refresh selected records - try creating a workflow in the Workflow Designer that gets the records you want to refresh, updates the calculate field, and then ends (you can trigger the workflow manually or automatically).