JavaScript vs Business Rules for Math Functions

(0) Share

Report

Posted on by bw17

I am currently trying to multiply two existing fields (field1 and field 2) and the to divide the result by 100 to return a percentage to an existing field called field3. Which method would adhere to best practices the closest (if either):

Scenario A:

Create a hidden field on the form to store the value of field1 * field 2 and then divide the hidden field by 100 (using a Business Rule to handle all the calculations)

Scenario B:

Use JavaScript to handle the entire calculation and place OnChange Event Handlers on field1 and field2

My main focus is to complete the calculation and to reduce the amount of time the form takes to load.

Thanks,

Ben

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

I believe speed will be the same so you can use any of ways.

Was this reply helpful? Yes No
bw17 10 on at

Like (0)

Report

Thanks for the quick reply

Was this reply helpful? Yes No
Pawns or Kings on at

Like (0)

Report

Hi Ben,

While the speed will be essentially the same, in terms of best practices, Microsoft encourages you use their interface as much as possible. Writing custom code, especially as it transitions from one version to the next, could result in some bugs.

Furthermore, instead of a business rule, you could also just set Field3 to a calculated field and edit the properties of the calculation.

Next to Field Type, click the edit button, and you will get an interface like this:

I hope this helps.

Regards,

David

Was this reply helpful? Yes No
bw17 10 on at

Like (0)

Report

Thanks for the advice David, I did consider using a calculated field however field3 is an existing field required by the system which I cannot change.

Was this reply helpful? Yes No
Pawns or Kings on at

Like (0)

Report

Ah, okay. Yes, in that case, you would either have to use a business rule or custom JavaScript. I recommend using the business rule for the reasons outlined in my previous response.

Good luck!

David

Was this reply helpful? Yes No
arif imteyaz 375 on at

Like (0)

Report

Business Rule is recommended by Microsoft.

Was this reply helpful? Yes No