Help me rewrite this formula
Posted on 2003-02-25
I have two fields on a form that is populated from a view. The fields contain a list of names example:
Requested_Approver -> Bob Socks;Jimmy Johnson
PME_Approver -> Bud Wiser;Chuck Roast
I have a action button called approve - someone from each list has to approve the form. I set up a hidden field called Approve_Checks - so if Bob its the approve button a DE is placed in the field, then the action should stop because someone from the PME_Approver list needs to approve. So now when Bud checks approve - the hidden field will append PME - so the field look like DE;PME
Then if both are there the action should continue on through the rest of the program. Here is what I have thus far:
@If(@IsMember(@Name([CN]; @UserName); Requested_Approver); @SetField("Approve_Checks";Approve_Checks:"DE"); "");
@If(@IsMember(@Name([CN]; @UserName); PME_Approver); @SetField("Approve_Checks"; Approve_Checks:"PME"); "");
@If(@IsMember("DE":"PME"; Approve_Checks);""; @Return(@Command([FileCloseWindow])));
REST OF ACTION ->
<- END of ACTION
Any suggestions welcome.
A quick def. of problem. I have two fields of names, someone from each field has to approve the document for the document to change states. After the first person approves the action still must wait for the second one to approve, after the second approves the action should complete itself and change states of the action.
Thanks For All your time and help