News and Announcements icon

Dynamics 365 CommunityForums Project Service Automation forum Autocalculate javascri...

Project Service Automation forum

Unanswered

Autocalculate javascript field from excel importing

(0) Share

Report

Report

Posted on by Gardagantxo2007

25

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

Categories:

All responses Img

All responses (1)

Answers Img

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 284,876 Super User

#2

Martin Dráb 225,425 Super User

#3

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans