How to trigger Javascript to execute from server

(0) Share

Report

Posted on by Daniel at VNS

We have some JS that does some mathematical functions on an entity form onload/onsave. We had to do it via JS because the field does calculations based on other calculated fields, so the option to use a calculated field was not available to us. It also does some if/else that I could not find a way to execute with calculated fields anyway.

Problem is, we need to apply it to every form. Expecting anyone to manually open/save thousands of records is obviously not realistic.

I think that in a case like this, a plugin would be the right solution but I am not a coder and don't have a clue where to start on a plugin. So I have to try and find a solution with the tools and skills I do have.

That said, I'd looked at workflows and do not see anything that would open a record (so that the JS could execute client-side), then save the record, en-masse.

Am I missing anything that might do this for me OOB, or would a plug-in be my only option?

Thank you

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

jlattimer 24,562 on at

Like (2)

Report

RE: How to trigger Javascript to execute from server

Short answer - you can't execute JavaScript from the server since in runs in the browser.

If you need to update 1000's of records, you be better off using a stand alone application with the calculations to run once and update all the records. Going forward using a plug-in would be a good option because it does run on the server so any data changes that might come in via an integration or something outside the browser would still cause the calculation to be made.

Was this reply helpful? Yes No
Daniel at VNS on at

Like (0)

Report

RE: How to trigger Javascript to execute from server

Thank you Jason

Was this reply helpful? Yes No
Verified answer

Josh Auton on at

Like (1)

Report

RE: How to trigger Javascript to execute from server

You could use XrmServiceToolkit.js library to do what you need to do. I would use the XrmServiceToolkit.Rest.RetrieveMultiple() to get all the records that need to be updated and then use the XrmServiceToolkit.Rest.Update() to update them all. I don't know if using the restful endpoints is considered doing is server side or not but this is how you would do it in javascript.

Feel free to reach out if you need a little more guidance.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

RE: How to trigger Javascript to execute from server

If it's a On Premise System then you can use SQL update. But you have to be very careful and take backups before updating.

You can also download the data in an excel and calculate in excel and reimport it.

Was this reply helpful? Yes No
Daniel at VNS on at

Like (0)

Report

RE: How to trigger Javascript to execute from server

Thank you Josh and Mohd.

Was this reply helpful? Yes No