Listado de Formulas

Ver el tema anterior Ver el tema siguiente Ir abajo

Listado de Formulas

Mensaje por JoseRios el Lun Feb 25, 2008 3:39 pm

AGENTES:

Código:
@Command([RunAgent]; agent)
@DocMark([Update])
@DocMark([NoUpdate])
@IsAgentEnabled(agent)

CARACTERES:

Código:
@Ascii(string)
@Ascii(string; [ALLINRANGE])
@Char(codeNumber)
@Narrow(string)
@NewLine
@Wide(string)
@COMMANDS:
@Command([command];parameters)
@PostedCommand([command];parameters)

CONTROL LOGICO:

Código:
@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; ...)

TIPOS DE DATOS:

Código:
@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

BASE DE DATOS:

Código:
@DbExists(server : file)
@DbExists(server; replicaID)
@DbManager
@DbName
@DbTitle
@ReplicaID
@ServerName
@WebDbName

CAMPOS:

Código:
@Abstract([keywords]; size; beginText;bodyFields)
DEFAULT variableName := value
FIELD fieldName := @DeleteField
FIELD fieldName := value
@GetField (fieldName)
@IsAvailable(fieldName)
@IsUnavailable(fieldname)
@SetField(fieldName; value)
@ThisName
@ThisValue
FIELD fieldName := @Unavailable

CARPETAS:

Código:
@AddToFolder(folderNameAdd;folderNameRemove)
@Command([FolderDocuments];folderName; moveOrCopy)

MARCOS:

Código:
@SetTargetFrame(targetFrame)

INTERNACIONALIZACIÓN:

Código:
@FormLanguage
@LanguagePreference([key])
@Locale([action])
@Locale([action]; locale-tag)
@UserNameLanguage(index)

LISTAS:

Código:
@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)

CORREO:

Código:
@CheckAlarms
@EnableAlarms(fl ag)
@LDAPServer
@MailDbName
@MailEncryptSavedPreference
@MailEncryptSentPreference
@MailSavePreference
@MailSend
@MailSend( sendTo ; copyTo ;blindCopyTo ; subject ; remark ;bodyFields ; [ flags ])
@MailSignPreference
@OptimizeMailAddress(address)

MATEMÁTICAS:

Código:
@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)

SEGURIDAD:

Código:
@Certificate([dataToRetrieve]; certificate)
@EditECL(server : database; name)
@EditUserECL
@HashPassword(string)
@Password(string)
@PasswordQuality(fi eld_name)
@RefreshECL(server : database; name)
@ServerAccess([access]; userName;serverName)
@UserAccess(server : file;[accessPrivilege])
@UserNamesList
@UserPrivileges
@UserRoles
@V4UserAccess(server : file)
@VerifyPassword(password; password)

TEXTO:

Código:
@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)

INTERACCIÓN CON EL USUARIO:

Código:
@DialogBox(form; [AUTOHORZFIT] :[AUTOVERTFIT] : [NOCANCEL] :[NONEWFIELDS] :[NOFIELDUPDATE] : [READONLY] :[SIZETOTABLE] : NOOKCANCEL] :[OKCANCELATBOTTOM]; title)
@PickList([CUSTOM] : [SINGLE]; server :file; 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;filetype)
@StatusBar(statusBarText)

DDE:

Código:
@DDEExecute(conversationID;command)
@DDEInitiate(application; topic)
@DDEPoke(conversationID;location; data)
@DDETerminate(conversationID)

DOCUMENTOS:

Código:
@Accessed
@AttachmentLengths
@AttachmentModifiedTimes
@AttachmentNames
@Attachments
@Author
@Created
@DeleteDocument
@DocFields
@DocLength
@DocLevel
@DocLock([options])
@DocOmittedLength
@DocumentUniqueID
@GetDocField(documentUNID;fieldName)
@HardDeleteDocument
@InheritedDocumentUniqueID
@IsDocBeingEdited
@IsDocBeingLoaded
@IsDocBeingMailed
@IsDocBeingRecalculated
@IsDocBeingSaved
@IsDocTruncated
@IsModalHelp
@IsNewDoc
@IsResponseDoc
@Modifi ed
@NoteID
@SetDocField(documentUNID;fieldName; newValue)
@UndeleteDocument

CONTROL DE ERRORES:

Código:
@CheckFormulaSyntax(formulaText)
@Error
@Eval(textExpressions)
@Failure(string)
@IfError(statement; alternateStatement)
@IsError(value)
@IsValid
@Success

HTTP/URL:

Código:
@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; [reloadflag]: [URLLIST]; charset; webusername)
@URLOpen(urlstring; [reloadflag]: [URLLIST]; charset; webusername;webpassword)
@URLOpen(urlstring; [reloadflag]: [URLLIST]; charset; webusername;webpassword$; proxywebusername$)
@URLOpen(urlstring; [reloadflag]: [URLLIST]; charset; webusername;webpassword; proxywebusername;proxywebpassword)
@UrlQueryString(parameterName)
@ValidateInternetAddress([addressFormat]; address)

LOOKUPS:

Código:
@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; fieldName or columnNumber; keywords)
@DbLookup(?ODBC? : cache;?data_source?; ?user_ID1? : ?user_ID2?; ?password1? :?password2?; ?table?; ?column? :?null_handling?; ?key_column?;?key?; ?Distinct? : ?sort?)

NAMES:

Código:
@Name([action]; name)
@NameLookup([lookupType];userName; itemToReturn)

COMENTARIOS:

Código:
REM ?comments?;
REM {comments};

DOCUMENTOS PERFILES:

Código:
@Command([EditProfileDocument];formName; uniqueKey)
@GetProfileField(profileName ;fieldName; uniqueKey)
@SetProfileField(profileName ;fieldName; value ; uniqueKey)

SELECCION:

Código:
@All
SELECT selectionFormula | @AllChildren
SELECT selectionFormula |@AllDescendants
SELECT formula

VARIABLES TEMPORALES:

Código:
@Set(variableName; value)

FECHA Y HORAS:

Código:
@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

VARIABLES DE ENTORNO DEL USUARIO:

Código:
@BrowserInfo(?propertyname?)
@ClientType
@ConfigFile
@Domain

ENVIRONMENT:

Código:
variable := textValue;
@Environment(variable)
@FileDir(pathname)
@FontList
@GetAddressBooks([options])
@GetCurrentTimeZone
@GetPortsList([portType])
@IsAppInstalled(application)
@IsVirtualizedDirectory
@LaunchApp(application)
@OrgDir
@Platform([SPECIFIC])
@RegQueryValue(keyName;subKeyName; valueName)
@SetEnvironment(variableName; value)
@UpdateFormulaContext
@UserName(index)
@V3UserName
@Version

VISTAS:

Código:
@DocChildren
@DocDescendants
@DocNumber
@DocParentNumber
@DocSiblings
@GetViewInfo([attribute]; column)
@IsCategory
@IsExpandable
@Responses
@SetViewInfo([SETVIEWFILTER];filterString; columnName; isCategory)
@SetViewInfo([SETVIEWFILTER];filterString; columnName; exactMatch)
avatar
JoseRios

Cantidad de envíos : 39
Edad : 32
Localización : Santiago, Chile
Fecha de inscripción : 25/02/2008

Ver perfil de usuario http://noteroschile.wordpress.com

Volver arriba Ir abajo

Ver el tema anterior Ver el tema siguiente Volver arriba

- Temas similares

 
Permisos de este foro:
No puedes responder a temas en este foro.