Formula Help - Struggling with conditions
Posted on 2006-03-29
I have the following formula actioned by a button on a form:
@If( Fitters_Comments != "";
@Do( FIELD WIP_Date := @Now;
FIELD WIP_Fitter := @Name([CN]; @UserName);
FIELD status := "Pending";
FIELD Fitters_Comments_1 := Fitters_Comments_1 + WIP_Fitter + " @ " + @Text(WIP_Date) + " - " + Fitters_Comments + @NewLine ;
FIELD Fitters_Comments :="";
@Command( [RefreshHideFormulas] ));
@Do(@Command([EditGotoField]; "Fitters_Comments" );
@Prompt( [Ok]; "Not Updated"; "Please enter a valid comment and try again" ) ) )
I need to add the following conditions to it:
If the status field = "Awaiting Parts" when the button is pressed I need a message box to pop up to check whether parts are still on order. If yes is pressed I want the status field to remain as "Awaiting Parts" If no is pressed I want the status field to change to "Pending"
I figure I need to take out the 4th line: FIELD status := "Pending";
and somewhere put in a @Dowhile "status =....@prompt.....@success;@failure?
I can't seem to figure this out... I bet I kick myself when I see the answer!
Thanks for your help!