Look up field update from different entity

(0) Share

Report

Posted on by Community Member

Hi,

Situation:

Custom Entity A has records with field name - Field A

Custom Entity B has records with field name - Field A

I have Order entity where records has look up field to Entity A/Field A

I need to move all records from Entity A to Entity B and Order entity records should have look up field to Entity B/Field A.

Solution:

I am planning to use on-demand workflow to update Order entity records from one look up value to another.

Problem:

On-demand workflow works this way if I want to update from one look up field to another, if both look up fields leading to the same entity. However, in my situation the workflow should add look up field value from Entity B/Field A, based on the value in look up field from Entity A/Field A.

Would creating any kind of relations/mappings between Entity A and Entity B records would help so I could define to take a field from another entity during the creation of the workflow?

Regards,

Jurgis

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Hello If there are same name records in Entity A and B then you can create a .Net application and replace lookup value

Hope you can understand what I mean!

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

I doubt if its possible out of the box. creating a simple console application is a better solution & its just one time job and time saving ( if you are developer ofcourse).

you can look for some examples on google.

Was this reply helpful? Yes No