Making Siebel Interviews easy

How to update a field based on change in another field?

How to update a field based on change in another field?

OR

How to update a field when another field is updated?

The answer to this question is.

  • Scripting
  • On Field Update Set n user property. (This is the answer interviewer is looking for though)

Explanation:

Scripting:

You can write script on SetFieldValue event of buscomp to update the target field. But the problem with this solution is if user UNDO the record then your script won’t revert back the changes that it has done.

One more solution can be to check in SetFieldValue event if that field is being updated through global flag and then on WriteEvent of buscomp execute your script only if that flag is set to true. But again you will have to set global flag to false may be Delete event (this is fired when user undo the record).

These solutions by scripting are really cumbersome. So we generally use On Field Update set n User property for this kind of requirement.

On Field Update Set n:

As the name suggests that this user property is used to set value of another field when a particular field is updated. In this user property n is the incremental number which is 1 more than the number used in the last On Field Update Set user property.

Value:
The value of the On Field Update Set user property consists of three quoted parameters separated by a comma and a space which is as following “FieldToCheck”, “FieldToSet”, “[Value]”

Example:
You want to set TargetField with SourceField value whenever SourceField is updated. So you will specify it like this.

Property: On Field Update Set 1
Value : “SourceField”, “TargetField”, “[SourceField]”

You can also make use of expression in the Value that you specify.

Example:

“SourceField”, “TargetField”, “[SourceField] + [AnotherField]”

  • Puneet Kaut

    Hi,

    We can use BC User Property :- “On Field Update Set n”.

    n can have any unique numeric value.

    value of this User prop. can be :”FieldToCheck”, “FieldToSet”, “Value”

    Thanks
    Puneet Kaur

  • varu

    Does this hold true for Delete scenario as well?
    i.e. if Source field value is deleted, thn target field value will also be deleted?

  • prabua

    Hi Neel,

    I created one Command and i added into Applet Method Menu Item. It is displaying now. When i try to click “Command”, it should go to different view but i am getting an error that “Cannot locate record within view: 'view name' Applet: 'Applet Name' (SBL-UIF-00269)

    For Example: On Account List View, i have my created command, when i click this command, it should go to Contat Detail View but it is successfully navigation with error window (Which i posted above).

  • sivaprasadmacha

    HOW TO CHANGE READ ONLY FIELD VALUE?

  • Gaffar Abdul

    How to delete the victim records of a child when it is associated with parent entity, after the DeDuplication Merge Process?

    posted by

    sha.