Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Autocalculate javascript field from excel importing

(1) ShareShare
ReportReport
Posted on by

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

  • Martinius Profile Picture
    on at
    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).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Overall leaderboard

Product updates

Dynamics 365 release plans