Validating before save

HCL Domino Domino Forum
1

Need some coding help for a newbie:

I have a form that is used to add a new documant to my database but I want to be able to set the value of one field (Status) when I save the document based on the values of five others (checkboxes). The form has an ADD button with the code:

@Command([FileSave]);

@Command([CloseWindow])

The field to change (Status) has a normal text value of ‘open’ and I need to change it to ‘complete’ but only if the value of all five checkboxes are set to ‘Approved’, if any one of them does not have ‘Approved’ as its value then the value of Status is left unchanged.

Problem is I am not sue how to go about this. Any help would be good

Martin

2

Subject: try this

(assuming the other fields are called f1 thru f5)

u:=“Approved”;

FIELD Status:=Status;

@If((f1 = u) & (f2 = u) @ (f3 = u) & (f4 = u) & (f5 = u);@Do(@Setfield(“Status”;“Approved”);

@Command([FileSave]));“”);

@Command([FileClose])

3

Subject: Many thanks

Spot on - works a dream

thanks

Martin