Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Make Field B dependent on Field A

SOLVED
Go to solution
Highlighted
Deep Mehta
Regular Collector

Make Field B dependent on Field A

Hi PPM'ers,

I was wondering how can I make a field dependent on the outcome of another field in RT?
I would like to see specfic options in the Auto Complete List for Field B based on Field value of A.
Can these also done with more fields like C depends on B which depends on A?

Thanks.
4 REPLIES
Sangiliraja_1
Collector

Re: Make Field B dependent on Field A

Hi Deepa,

Yes this is very much possible.

Let me confirm if this is what you are looking for. Field B is a ACL whose values depends on value of a Field A.

In this case, you can have field B validation as a SQL and use token of Field A in the where clause.

I thinks this helps.

Thanks
SAngiliraja.P
Deep Mehta
Regular Collector

Re: Make Field B dependent on Field A

Sangiliraja,
To clarify my question..

I have an ACL field A with values 1 , 2
and ACL Field B with Values D, E, F, G, H.

So,
CASE 1 - If I choose 1 in Field A, I should just see D, E and F in Field B as available choices.
CASE 2 - If I choose 2 in Field A, I should just see G and H in Field B.

Can you provide an example if this can be done?

Thanks,
Deep
Sangiliraja_1
Collector
Solution

Re: Make Field B dependent on Field A

Hi Deep,

This involves little bit of logical work.
here is a solution i have designed.

PFA.

Get back to me if this works for you

Thanks
Sangiliraja.P
Deep Mehta
Regular Collector

Re: Make Field B dependent on Field A

Thanks Sangiliraja. This is working
//Add this to "OnDomLoad" event