Set Parent Field Value from Child BC

(2 votes, average: 4.00 out of 5)

 Loading ...

This post more of an open question then an answer to problem. I came across this requirement few days ago and pondered for few hours to find an optimal solution. In the end I had to revert to scripting in the final solution.

But I still believe there is a better way to do this. Therefore I am putting this in front of you all so that somebody out there can provide an answer that I am looking for

Requirement:

We have a Service Request as Parent BC and Activities as Child BC.

When a Flag called ‘Approved’ is checked on Activities List Applet then value of a Field called ‘Change Description’ on Service Request should be set as ‘Activity Approved’

Solution I tried:

• Create a new Flag Field (base field) in Service Request.
• Create a user Property ‘On Field Update Set’ on Service request with following value:
  “Flag Field”, “Change Description”, “Activity Approved”
• In the Activities write the following script in BC Write Record Event.
  
if (Approved == "Y")
{
this.ParentBusComp().SetFieldValue("Flag Field","Y");
}

Problem:
I don’t like this scripting and this base field in Service Request. I tried with a calculated and Multi Value Field but these fields don’t work with ‘On Field Update Set’ User Property on BC

 But I am sure that there has to be a better way to do it. Please if you know there is a better way, then please let us all know.