a:= 1b:= 50
Sir/madaam, what validation formula should i use, in order client will not input less than (a) and not be greater than (b)… thanks in advance…
Subject: validation
assuming that you have a Number field called “Amount” which you need to validate,
a) Using Formula :
@If(Amount<1 | Amount>50;@Return(@Prompt([OK];@DbTitle;“Amount should be between 1 to 50”));“”);
b) Using Lotus Script :
dim ws as New NotesUiWorkspace
dim uidoc as NotesUiDocument
dim doc as NotesDocument
set uidoc = ws.CurrentDocument
set doc = uidoc.Document
if (doc.Amount(0)<1 or doc.Amount(0)>50 ) then
msgbox “Amount should be between 1 to 50”
end if
hope this helps!!
Subject: RE: validation
ThanksI must appreciate your responses and attention to details here. I have been reading your responses for a while now, and all of them seem to be making perfect sense. This time, I was looking a way to stop the process after @Prompt and your suggestion did the trick. Thanks man. Take Care
Viru
Subject: @If((Field < a) | (Field > b) ; @Failure(“Out of Range!”) ; @Success)