Modifying field value on Quote BC based on specific Quote Item #

We have a join field name 'Common Agreement' on Quote BC, Quote Entry
Applet. It has a predefault value text "You have agreed for 25 units, the
vendors standard Terms & Conditions apply."

So irrespective of any Quote Item # that is created in bottom Quote Item
List Applet, we have the above standard text value in top Quote Entry
Applet.

Now the requirement is, if a Quote Item record with specific 'Quote Item #,'
example '1400' is created, the field name 'Common Agreement' in top Quote
Entry Applet should have modified text "You have agreed for 40 units the
vendors standard Terms & Conditions apply."

Popular White Paper On This Topic

I guess this must be predefaulting when a new record is created.
Once a record has been created and assuming there is a joined
record, the record in Quote BC will need to be refreshed. Once
option could be to write a script in write record event and call
method 'refreshrecord'

You are right, join field name 'Common Agreement' on Quote BC, Quote Entry
Applet (top applet) is predefaulted and populates the 'Common Agreement'
field with text "You have agreed for 25 units, the vendors standard Terms &
Conditions apply." when new Quote record is created. That works fine.

My requirement is, if a Quote Item record with only specific 'Quote Item #,'
example '1400' is created in the bottom Quote Item List Applet, the field
name 'Common Agreement' in top Quote Entry Applet should have modified text
"You have agreed for 40 units the vendors standard Terms & Conditions
apply." else for any other 'Quote Item #,' the Common Agreement field should
contain the predefaulted text.

One of the options that I can think of is to have a calculated
field that displays text based on value in the joined field and
Quote Item No. So, in case there is value in joined field,
display that, else if Quote Item No. is 1400, display the text
X else text Y.