So you want the error to occur when (( 'Completed?' = 'DB.Completed?') AND ($USER$ = 'ChangeOwnerLoginName'))
OR (( 'DB.RFC Status' = "Approved With Changes" ) AND (NOT ($GROUPS$ LIKE "%Configuration Management%" )) AND (NOT ($GROUPS$ LIKE "%Admin%" )) AND $USER$ != 'ChangeOwnerLoginName') Maybe that will work. Maybe not. Thanks for giving me a headache. Brien 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"