How to concat (1st character of 1st field + 1st character of 2nd field + 3rd field value ) set in Product Id field of the Product form ?

(0) Share

Report

Posted on by surajitinsync

Hi Expert ,

I want to set some concat value of 3 fields in Product Id field of the Product form. I have two option type field 1) Plan 2) Payment Type . Now below is the example of concat value :

Product Id = concat(1st character of Plan + 1st character of PaymentType + Product Name)

Whenever user change Plan or Payment type value Product Id concat value also will be changed real time.

How it can be done ?

Thanks

Surajit Kundu

All responses (4)

Answers (1)

surajitinsync 40 on at

Like (0)

Report

RE: How to concat (1st character of 1st field + 1st character of 2nd field + 3rd field value ) set in Product Id field of the Product form ?

Thanks clofy it's working.
Verified answer

cloflyMao 25,198 on at

Like (1)

Report
RE: How to concat (1st character of 1st field + 1st character of 2nd field + 3rd field value ) set in Product Id field of the Product form ?

Hi surajitinsync,

You could refer to my JS code.

function Concatenatefields(executionContext) { var formContext = executionContext.getFormContext(); var plan = formContext.getAttribute("new_plan").getText(); var payment =formContext.getAttribute("new_payment").getText(); var productName = formContext.getAttribute("new_productname").getValue(); var test =""; if (plan != null) { test = test plan; if (payment != null) { test = test payment; } if (productName != null) { test = test productName; } } else if (payment != null) { test = test payment; if (productName != null) { test = test productName; } } else if (productName != null) { test = test productName; } formContext.getAttribute("productnumber").setValue(test); }

In Opportunity form, run the function at OnChange event of Plan, Payment and ProductName field.

Test result:

Regards,

Clofly