NOTESSIDAN

Allt om Lotus Notes & Domino




Kategoriserade @Formulas
Här är en formellista kategoriserad på var man använder respektive formel.


Agenter
@Command([RunAgent]; agent)
@DocMark([Update])
@DocMark([NoUpdate])
@IsAgentEnabled(agent)

Tecken
@Ascii(string)
@Ascii(string; [ALLINRANGE])
@Char(codeNumber)
@Narrow(string)
@NewLine
@Wide(string)
@Commands
@Command([command];parameters)
@PostedCommand([command];parameters)

Logik
@Do(expressions)
@DoWhile(statement; ...; condition)
@For(initialize; condition; increment;statement; ...)
@If(condition1; action1; condition2;action2; ...; condition99; action99;else_action)
@Nothing
@Return(value)
@Select(number; values)
@V2If(condition1; action1; condition2;action2; condition99; action99; else_action)
@While(condition; statement; ...)

Datatyper
@False
@IsNull(value)
@IsNumber(value)
@IsText(value)
@IsTime(value)
@No
@Text(value; format String)
@TextToNumber(string)
@TextToTime(string)
@Time(hour; minute; second)
@Time(year; month; day; hour; minute;second)
@Time(time-date)
@TimeMerge(date; time; timeZone)
@TimeToTextInZone(timeDate; timeZone;formatString)
@TimeZoneToText(timeZone;formatString)
@ToNumber(value)
@ToTime(value)
@True
@Yes

Databaser
@DbExists(server : fi le)
@DbExists(server; replicaID)
@DbManager
@DbName
@DbTitle
@ReplicaID
@ServerName
@WebDbName

Fält
@Abstract([keywords]; size; beginText;bodyFields)
DEFAULT variableName := value
FIELD fieldName := @DeleteField
FIELD fieldName := value
@GetField (fi eldName)
@IsAvailable(fi eldName)
@IsUnavailable(fi eldname)
@SetField(fi eldName; value)
@ThisName
@ThisValue
FIELD fieldName := @Unavailable

Foldrar
@AddToFolder(folderNameAdd;folderNameRemove)
@Command([FolderDocuments];folderName; moveOrCopy)

Ramar
@SetTargetFrame(targetFrame)

Internationellt
@FormLanguage
@LanguagePreference([key])
@Locale([action])
@Locale([action]; locale-tag)
@UserNameLanguage(index)

Listor
@Compare(textlist; textlist; [options])
@Count(list)
@Elements(list)
@Explode(dateRange)
@Explode(string;separators;includeEmpties;newlineAsSeparator)
@Implode(textlistValue)
@Implode(testlistValue; separator)
@IsMember(textValue; textListValue)
@IsMember(textListValue1;textListValue2)
@IsNotMember(textValue; textListValue)
@IsNotMember(textListValue1;textListValue2)
@Keywords(textList1; textList2)
@Keywords(textList1; textList2;separator)
@Member(value; stringlist)
@Replace(sourcelist; fromlist; tolist)
@Sort(list; [order];customSortExpression)
@Subset(list; number)
@Transform(list; variableName; formula)

Post
@CheckAlarms
@EnableAlarms(fl ag)
@LDAPServer
@MailDbName
@MailEncryptSavedPreference
@MailEncryptSentPreference
@MailSavePreference
@MailSend
@MailSend( sendTo ; copyTo ;blindCopyTo ; subject ; remark ;bodyFields ; [ fl ags ] )
@MailSignPreference
@OptimizeMailAddress(address)

Matematik
@Abs(anyNumber)
@ACos(cosine)
@ASin(sine)
@ATan(tangent)
@ATan2(x; y)
@Cos(angle)
@Exp(power)
@FloatEq(number; number;confi denceRange)
@Integer(numberValue)
@Ln(number)
@Log(number)
@Max(number1)
@Max(number1; number2)
@Min(number1)
@Min(number1; number2)
@Modulo(number1; number2)
@Pi
@Power(base; exponent)
@Random
@Round(number)
@Sign(signedNumber)
@Sin(angle)
@Sqrt(number)
@Sum(numbers)
@Tan(angle)

Säkerhet
@AdminECLIsLocked (R7)
@Certifi cate([dataToRetrieve]; certifi cate)
@EditECL(server : database; name)
@EditUserECL
@HashPassword(string)
@Password(string)
@PasswordQuality(fi eld_name)
@RefreshECL(server : database; name)
@ServerAccess([access]; userName;serverName)
@UserAccess(server : fi le;[accessPrivilege])
@UserNamesList
@UserPrivileges
@UserRoles
@V4UserAccess(server : fi le)
@VerifyPassword(password; password)

Text
@Begins(string; subString)
@Contains(string; subString)
@Ends(string; subString)
@Left(stringToSearch; numberOfChars)
@Left(stringToSearch; subString)
@LeftBack(stringToSearch; numToSkip)
@LeftBack(stringToSearch; startString)
@Length(string)
@Length(stringList)
@Like(string; pattern)
@Like(string; pattern; escape)
@LowerCase(string)
@Matches(string; pattern)
@Middle(string; offset; numberChars)
@MiddleBack(string; offset;numberChars)
@ProperCase(string)
@Repeat(string; number; numberChars)
@ReplaceSubstring(sourceList; fromList;toList)
@Right(stringToSearch; numberOfChars)
@Right(stringToSearch; subString)
@RightBack(stringToSearch; numberOfChars)
@RightBack(stringToSearch; subString)
@Soundex(string)
@Trim(string)
@Unique
@Unique(textlist)
@UpperCase(string)
@Word(string; separator; number)

Användarinteraktivitet
@DialogBox(form; [AUTOHORZFIT] :[AUTOVERTFIT] : [NOCANCEL] :[NONEWFIELDS] :[NOFIELDUPDATE] : [READONLY] :[SIZETOTABLE] :NOOKCANCEL] :[OKCANCELATBOTTOM]; title)
@PickList([CUSTOM] : [SINGLE]; server :fi le; view; title; prompt; column;categoryName)
@PickList([NAME] : [SINGLE])
@PickList([ROOM])
@PickList([RESOURCE])
@PickList([FOLDERS] : [SINGLE]; server: database)
@PickList([FOLDERS] : [SHARED];server : database)
@PickList([FOLDERS] : [PRIVATE];server : database)
@PickList([FOLDERS] : [NODESKTOP];server : database)
@Prompt([style] : [NOSORT]; title;prompt; defaultChoice; choiceList;fi letype)
@StatusBar(statusBarText)

DDE
@DDEExecute(conversationID;command)
@DDEInitiate(application; topic)
@DDEPoke(conversationID;location; data)
@DDETerminate(conversationID)

Dokument
@Accessed
@AttachmentLengths
@AttachmentModifi edTimes
@AttachmentNames
@Attachments
@Author
@Created
@DeleteDocument
@DocFields
@DocLength
@DocLevel
@DocLock([options])
@DocOmittedLength
@DocumentUniqueID
@GetDocField(documentUNID;fi eldName)
@HardDeleteDocument
@InheritedDocumentUniqueID
@IsDocBeingEdited
@IsDocBeingLoaded
@IsDocBeingMailed
@IsDocBeingRecalculated
@IsDocBeingSaved
@IsDocTruncated
@IsModalHelp
@IsNewDoc
@IsResponseDoc
@Modifi ed
@NoteID
@SetDocField(documentUNID;fi eldName; newValue)
@UndeleteDocument

Errorhantering
@CheckFormulaSyntax(formulaText)
@Error
@Eval(textExpressions)
@Failure(string)
@IfError(statement; alternateStatement)
@IsError(value)
@IsValid
@Success

HTTP/URL
@GetHTTPHeader(requestHeader)
@SetHTTPHeader(responseHeader; value)
@URLDecode(decodingFormat; token)
@URLEncode(encodingFormat; token)
@URLGetHeader(urlstring;headerstring; webusername;webpassword; proxywebusername;proxywebpassword)
@URLHistory([command])
@URLOpen
@URLOpen(urlstring)
@URLOpen(urlstring; [reloadfl ag])
@URLOpen(urlstring; [URLLIST])
@URLOpen(urlstring; [reloadfl ag]: [URLLIST])
@URLOpen(urlstring; [reloadfl ag]: [URLLIST]; charset)
@URLOpen(urlstring; [reloadfl ag]: [URLLIST]; charset; webusername)
@URLOpen(urlstring; [reloadfl ag]: [URLLIST]; charset; webusername;webpassword)
@URLOpen(urlstring; [reloadfl ag]: [URLLIST]; charset; webusername;webpassword$; proxywebusername$)
@URLOpen(urlstring; [reloadfl ag]: [URLLIST]; charset; webusername;webpassword; proxywebusername;proxywebpassword)
@UrlQueryString(parameterName)
@ValidateInternetAddress([addressFormat]; address)

Uppslag
@DbColumn(class : cache; server :database; view; columnNumber)
@DbColumn(“ODBC” : cache;data_source; user_ID1 : user_ID2;password1 : password2; table; column :null_handling; “Distinct” : sort)
@DbCommand(“Domino”;“ViewNextPage”)
@DbCommand(“Domino”;“ViewPreviousPage”)
@DbCommand(“Domino”;“FolderList”;promptString; foldersToExclude)
@DbCommand(“ODBC” : cache;data_source; user_ID1 : user_ID2; password1 : password2;command_string : null_handling)
@DbLookup(class : cache; server: database; view; key; fi eldName orcolumnNumber; keywords)
@DbLookup(“ODBC” : cache;“data_source”; “user_ID1” :“user_ID2”; “password1” :“password2”; “table”; “column” :“null_handling”; “key_column”;“key”; “Distinct” : “sort”)
@DB2Schema( server : file ) (R7)

Namn
@Name([action]; name)
@NameLookup([lookupType];userName; itemToReturn)

Kommentarer
REM “comments”;
REM {comments};
Profi le Documents
@Command([EditProfi leDocument];formName; uniqueKey)
@GetProfi leField(profi leName ;fi eldName; uniqueKey)
@SetProfi leField(profi leName ;fi eldName; value ; uniqueKey)

Urval
@All
SELECT selectionFormula | @AllChildren
SELECT selectionFormula | @AllDescendants
SELECT formula

Temporära Variabler
@Set(variableName; value)

Tid & Datum
@Adjust(dateToAdjust; years; months;days; hours; minutes; seconds; [DST])
@BusinessDays(startDates; endDates;daysToExclude; datesToExclude)
@Date(year; month; day)
@Day(timeDateValue)
@Hour(timeDateValue)
@Minute(time date)
@Month(time date)
@Now(fl ags; serverNames)
@Second(time date)
@Today
@Tomorrow
@Weekday(time date)
@Year(time date)
@Yesterday
@Zone

Användarmiljö
@BrowserInfo(“propertyname”)
@ClientType
@Confi gFile
@Domain
ENVIRONMENT variable := textValue;
@Environment(variable)
@FileDir(pathname)
@FontList
@GetAddressBooks([options])
@GetCurrentTimeZone
@GetPortsList([portType])
@IsAppInstalled(application)
@IsDB2(server : file) (R7)
@PolicyIsFieldLocked( fieldName ) (R7)
@IsEmbeddedInsideWCT (R7)
@IsVirtualizedDirectory
@LaunchApp(application)
@OrgDir
@Platform([SPECIFIC])
@RegQueryValue(keyName;subKeyName; valueName)
@SetEnvironment(variableName; value)
@UpdateFormulaContext
@UserName(index)
@V3UserName
@Version

Vyer
@DocChildren
@DocDescendants
@DocNumber
@DocParentNumber
@DocSiblings
@GetViewInfo([attribute]; column)
@IsCategory
@IsExpandable
@Responses
@SetViewInfo([SETVIEWFILTER];fi lterString; columnName; isCategory)
@SetViewInfo([SETVIEWFILTER];fi lterString; columnName; exactMatch)
@ViewTitle

Tabeller
@GetFocusTable([tableInfoRequest])



Relevanta Poster på Notessidan:



Publicerad 2006-08-04 | Kommentarer: 1 | Läsningar: 4010
Kommentarer

Patrick Kwinten ( 2007-02-06 11:47:02 )
vet du en @left function i javascript var jag kan lägga i number of char?

så inte

function strLeft(sourceStr, keyStr){
return (sourceStr.indexOf(keyStr) == -1 | keyStr=='') ? '' : sourceStr.split(keyStr)[0];
}

den tar en string som key...

mvh

Patrick

(quintiexxx@hotmail.com)



Sök på Notessidan
Thomas Adrian
ThomasCertifierad utvecklare och administratör inom Notes & Domino

Kontakta mig







Senaste Sökningarna på Notessidan
Sön - sharepoint (R:1)
Sön - räkna and antal and besökare (R:0)
Sön - browser (R:17)
Sön - stoppar and mail (R:1)
Sön - korrupt (R:3)
Sön - böcker (R:0)
Sön - kalendern (R:12)
Sön - feature (R:15)
Sön - print and mime (R:2)
Sön - länka (R:0)
Sön - databasen (R:94)
Sön - access (R:47)
Sön - outlook (R:15)
Sön - webanvändare (R:0)
Sön - google and maps (R:6)
Sön - juffe (R:2)
Sön - uidoc.print (R:1)
Sön - java and lotusscript (R:26)
Sön - besök (R:0)




Databasstatistik Blogg
Uppdateras var 15:e Minut

Antal Poster:562
Antal Kommentarer: 1381
Alla sidvisningar idag:
Unika Besökare idag:
Databasstorlek: 186,75Mb
Fixup: 2019-07-23 00:31:06
FT:2019-07-24 04:13:53
DB Procent använd: 99,5
Antal Agenter: 42
Antal Formulär: 65
Antal Vyer: 60
Antal Dokument: 7938
Antal Image Resources: 108
Antal Subformulär: 18
Antal Scriptbibliotek: 11
Totalt Antal Designelement: 576
Antal Attachments: 159
Antal Konflikter: 0
Server version 1: 405
Server version 2: Release 9.0.1FP9|August 14, 2017
Server Plattform: Windows/64
Ändrad: 2019-07-24 05:09:27
Server Tidszon: Z=-1$DO=1$DL=3 -1 1 10 -1 1$ZX=131$ZN=W. Europe
Region:
Kommentarsspam Idag: 7
Kommentarsspam Totalt: 17974


BlogRankers.com

Top Sites at iWEBTOOL.com

Fight Spam! Click Here!

Bloggtoppen.se

Listed on BlogShares

Increase website traffic

Top Internet Blogs

Site Checker