Hi Geniuses,
I have some tricky trigger problem, let me explain
I have set a trigger select in field ProjectManagerUserName using the function =right(upper(osuser()),(len(osuser())-index(osuser(),'\')))
(it is just taking the windows login and select the field), now I have locked this field...... Now come the tricky part while selecting the second select in field on HierarchyUserName what I want is that first it checks whether HierarchyUserName and windows username are matching if they are matching then clear the previous select in field on ProjectManagerUserName and select the HierarchyUserName
ex Windows login id : sseth
ProjectManagerUserName : sseth
both are matching so now it locks the ProjectManagerUserName with sseth as value
now HierarchyUserName : sseth
as now HierarchyUserName is also sseth so now it should remove the selection on ProjectManagerUserName and lock the selection on HierarchyUserName
Why I am doing it is tricky, may be the data model will tell you, PFA same