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

PPM - Compare values in two fields to prevent double entry

Highlighted
MVDD
Occasional Advisor

PPM - Compare values in two fields to prevent double entry

Hi all,

I have two fields in PPMC on a project form:

1. Project Manager (allowing just one name)

2. Project Manager Replacement (allowing two names)

What I want to achieve is, when you enter a name in Project Manager, that name can not be entered in the field Project Manager Replacement and vice versa.

Any tips on how to achieve this?

 

Thanks!

 

Maurice

1 REPLY
hyllplan
Frequent Visitor

Re: PPM - Compare values in two fields to prevent double entry

Create a rule that does a SQL instr on the other field, if found set a specific value in a hidden field.

Create another rule that look at the hidden field value and acting on it, maybe a popup, reverting input or something

/Johan

//Add this to "OnDomLoad" event