Autocalculate javascript field from excel importing

(1) Share

Report

Posted on 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

I have the same question (0)

All responses (1)

Answers (0)

Martinius 10 on at

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).

Was this reply helpful? Yes No