How to combine conditional statements in Lotus Notes formula language? -


i migrating lotus notes sharepoint. trying define lotus notes formula match records migrate. lotus notes noob. not equal operator in lotus notes , , operator. have:

form!="credit hold secured" , form!="credit card" , @matches(@left(companyname;1);"{0-9}")

to combine conditional statements or formulas return true/false (boolean) value, use ampersand specify "and", pipe specify "or", , exclamation point specify "not":

form != "credit hold secured" & form != "credit card" & @matches(@left(companyname;1);"{0-9}") 

note, cleaner way check matching form name is:

@isnotmember(form; "credit hold secured":"credit card") 

which return true if form name not in list of string values. makes easier add new form list in future.


Comments

Popular posts from this blog

Error while updating a record in APEX screen -

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

ios - Xcode 5 "No such file or directory" -