Arithmetic on option set fields

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi Community,

I was wondering if it is possible to sum two option set fields in CRM without having to use javascript?

For example i have option set A with a value of 1, option set B with a value of 3, id like to add the two values and then store the total in a separate field.

Many Thanks in advance.

*This post is locked for comments

All responses (5)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Arithmetic on option set fields

If the fiueld you want to set the value is String. Use this code:

var value1 = Xrm.Page.getAttribute("OptionsetAFieldName").getValue();

var value2 = Xrm.Page.getAttribute("OptionsetBFieldName").getValue();

var sum = value1 + value2;

Xrm.Page.getAttribute("FieldNametoSet").setValue(sum.toString());
Suggested answer

Nithya Gopinath 17,074 on at

Like (0)

Report

RE: Arithmetic on option set fields

Hi Moons,

See: community.dynamics.com/.../200929
a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: Arithmetic on option set fields

You can start here - msdn.microsoft.com/.../jj602964.aspx
Community Member Microsoft Employee on at

Like (0)

Report

RE: Arithmetic on option set fields

Hi Andrii,

thank you for your reply

Could you point me in the right direction please of some examples if possible.

Many Thanks.
Suggested answer

a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: Arithmetic on option set fields

Hello,

I don't think that's possible. You will have to write couple of JavaScript code lines.