News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Autocalculate javascri...

Finance | Project Operations, Human Resources, ...

Unanswered

Autocalculate javascript field from excel importing

(1) Share

Report

Report

Posted on by Gardagantxo2007

27

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 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... 291,431 Super User 2024 Season 2

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans