Dynamically Populate a Field Based-on the Value(s) of Another Field

[appstorm]

I have been working on several on-change client scripts to make this work, but have so far been unsuccessful.  The task to make two fields that share the same table populate with their respective values, based-on the value of another field from the same table.

Below, is my script include.

How do I go about writing an on-change CS to make this work?

Thank you!

[BALAJI40]

Hi,

Do you want to populate owner and analyst based onChange of the system or vice versa?

[appstorm]

Correct, based onChange of system.

[BALAJI40]

Please use the script suggested by Prasad Pagar.

[Steven Parker]

In our instance, I filter a reference field based on another reference field by doing that following:

You could use an advanced Reference Qualifier on the reference field.  Here is our example:

"SOW Number" - Current reference field I am updating the Reference Qual on

"current.variables.customer" - form field reference to custom table

"u_client" - reference field on my custom table

Below is my Advanced Reference Qualifier on the "SOW Number" field.

javascript:'u_client='+current.variables.customer+'^u_active=true';

So basically this filters the "SOW Number" reference field by the "Customer" field which is also a reference field.  It only shows SOW numbers associated with the customer chosen that are active.