Does this solve it?

(USER$ = 'ChangeOwnerLoginName' AND 'Completed?' != 'DB.Completed?') OR
($GROUPS$ LIKE  "%Configuration Management%") OR ($GROUPS$ LIKE
"%Admin%")

If action = Nothing
Else action = Error message

Ken.


On 11/2/2011 1:48 PM, Drew Shuller wrote:
> Hello listers, can I get a sanity check please?
>
> How do you write a filter Run If that allows a person that owns an RFC
> (this is a custom app) to modify the record, but only if he is
> changing a specific field? Otherwise, an error message should stop the
> filter. The Configuration Manager and the system admin should be able
> to change the record whenever they want. No one else should be able to
> modify the record.
>
> These two Run If statements do what I want unless I put them into one
> Run If statement, joined with an OR:
>
> (( 'Completed?' != 'DB.Completed?') AND ($USER$ !=
'ChangeOwnerLoginName'))
>
> and this one:
>
> (( 'DB.RFC Status' =  "Approved With Changes" ) AND (NOT ($GROUPS$
> LIKE  "%Configuration Management%" )) AND (NOT ($GROUPS$ LIKE
> "%Admin%" )))
>
> During testing, the Config Manager can update the RFC, but not if he's
> changing the "Completed?" field. The Change Owner can't modify the RFC
> at all. After a couple of days of hacking away I'm pretty confused.
> Thanks for any and all help!
>
> Drew
> Comayagua
>
>
________________________________________________________________________
_______
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>

________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
*******************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please
notify the system manager. This footnote also confirms that this
email message has been swept for the presence of computer viruses.
www.Hubbell.com - Hubbell Incorporated**


_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Reply via email to