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!

[-O- · Accepted solution]

This is what I have defined in my PDI:

HHave added the fields to the Change Request form:

After flushing the cache, when I change System, Analyst and Owner automatically update.

[appstorm]

IT WORKS!!!

I had to change the system field from a reference to a drop-down, but it FINALLY works!

Thanks so much!!!

[-O-]

You're most welcome and I'm glad it's working 🙂

[appstorm]

Quick question: Why was this not working when system was a reference field referencing u_change_request_system_owner table, but works when it is a choice list?  Just curious, since it would be easier to reference the table column data, instead of having to maintain a drop-down.

Thanks again!

[-O-]

I cannot say for sure without knowing all the definitions of all the fields involved, but the bottom line is that values must match on a value level, not on a display value level. If you could provide me the definition of the field on the table, I could tell you exactly why it is working the way it is configured now.