Auto populate a field based

(0) Share

Report

Posted on by Sip Khann

Hi all,

I am completely new to javascript. We have come across an issue where a text field on a form (Form A) needs to be populated from a field on contact form. The logic is when a field value ( lookup field on Form A) is changed the text field below it shows the related value. Could someone possibly share the code please.

All responses (5)

Answers (1)

LeoAlt 16,331 Moderator on at

Like (0)

Report

RE: Auto populate a field based

Hi partner,

I think you need to change the code to "Lookup_Contact != null"

Regards,

Leo
Sip Khann 55 on at

Like (0)

Report

RE: Auto populate a field based

Hi Leo Zhan,

Thanks for suggestion. I tried adding the below code but it does not work. Cant understand why though.

else if (Lookup_Contact==null) {

formContext.getAttribute("Field").setValue(field A);

}

}
LeoAlt 16,331 Moderator on at

Like (0)

Report

RE: Auto populate a field based

Hi partner,

1.You can add a judge rule that checks if the lookup field is empty.

2.Whatever number or text field, you could use "formContext.getAttribute("field").setValue(value);" to set value to them.

Here's a blog about how to set/get values from different type of field.

https://crm365blog.wordpress.com/2018/05/29/get-set-field-values-in-c-javascript-and-utility-functions/

Best Regards,

Leo
Sip Khann 55 on at

Like (0)

Report

RE: Auto populate a field based

Hi Leo Zhang ,

Thanks a lot. That did work like a charm except for one small issue when lookup field is empty again on form A, i get the below error. And also i had to add another field (text field) as the current field (field b) is a whole number (data type).

Really appreciate the response.
Verified answer

LeoAlt 16,331 Moderator on at

Like (1)

Report
RE: Auto populate a field based

Hi partner,

So you means you want the field A on form A be populated from field B on contact form based on the lookup value of contact in form A?

If so, please refer to the following code.

function getValueFromLookUp(executionContext){ var formContext=executionContext.getFormContext(); //get contact lookup field value on form A var Lookup_Contact=formContext.getAttribute("Lookup_contact"); if(Lookup_Contact!=null){ //get contact record id var value=Lookup_Contact.getValue(); var id=value[0].id; //use record id to retrieve field B on contact form Xrm.WebApi.retrieveRecord("contact",id,"?$select=fieldB").then( function success(result){ //get the field B value and set it to field A var fieldB=result.fieldB; formContext.getAttribute("fieldA").setValue(fieldB); }, function (error){ console.log(error.message); } ) } }

Add this JS function to form A contact lookup field onchange event.

Remember to click "Pass execution context as first parameter"

Best Regards,

Leo