Mo
Tu
We
Th
Fr
Sa
Su
 
 
Basic information about formulas, conditions, filters and scripts
 
Global functions available for scripts e.g. CurrentUser()
Function
Description
Arguments
Returns
CallDllInt
Calls external PartnerLibrary.PartnerClass (custom library deployed at WWW/Partner/ParnerLibrary.DLL), public static int CallDllInt(string, string, string, int, int, int)
S1 [String] Optional
S2 [String] Optional
S3 [String] Optional
I1 [Int] Optional
I2 [Int] Optional
I3 [Int] Optional
Int
CallDllString
Calls external PartnerLibrary.PartnerClass (custom library deployed at WWW/Partner/ParnerLibrary.DLL), public static string CallDllString(string, string, string, int, int, int)
S1 [String] Optional
S2 [String] Optional
S3 [String] Optional
I1 [Int] Optional
I2 [Int] Optional
I3 [Int] Optional
String
CommandsShow
Returns visual presentation of commands. For multiple records returns only those commands that are relevant for all of the commands
TableId [Int] Required, Table identificator
RowIds [String] Optional, Row identificators, one or more for groupable commands (separated with comma e.g. 1,2,3)
CanCommands [Bool] Required, Whether to show custom commands
CanUpdate [Bool] Required, Whether to show Edit command
CanDelete [Bool] Required, Whether to show Delete command
Html
CurrentDateOnly
Gets current date, without time
DateOnly
CurrentDateTime
Gets current date and time
DateTime
CurrentRows
Reserved for commands running multiple rows at the same time e.g. ForEach row in CurrentRows()
LookupMulti
CurrentUser
Returns current user
User
CurrentUserReal
Returns current real user, even if working on behalf of someone else
User
DateCreate
Gets new DateTime
Year [Int] Optional
Month [Int] Optional
Day [Int] Optional
Hour [Int] Optional
Minutes [Int] Optional
Seconds [Int] Optional
DateTime
DateDiff
Calculates difference between dates so d2 - d1 e.g. DateDiff(d1, d2, "Days"). Returns umber of units e.g. days, hours, minutes, seconds. You can also use operators + - to add or substract whole days (unit) from DateOnly and DateTime
Date1 [DateTime] Optional
Date2 [DateTime] Optional
Unit [String] Optional, Choose one: Days, Hours, Minutes, Seconds
Decimal
DateDiffDaysText
Calculates difference between dates so Date2 - Date1 and returns text e.g. DateDiffDaysText("2015-11-10", "2015-10-09") returns 1 year 1 month 1 day.
Date1 [DateTime] Optional
Date2 [DateTime] Optional
String
DateDiffDietPL
Calculates diet days between dates for delegations (typical polish), so d2 - d1 e.g. DateDiffDiet(d1, d2, true). Returns number of units e.g. days, minutes
Date1 [DateTime] Optional
Date2 [DateTime] Optional
IsPoland [Bool] Optional
Decimal
DateNow
Returns curent date with time
DateTime
DateToday
Returns current date only
DateOnly
EnPl
Checks users culture language and returns proper string, English is the default
ValueEn [String] Optional, Value to be returned for English
ValuePl [String] Optional, Value to be returned for Polish
String
GetCulture
Returns currently logged user culture as integer: 1033 English, 1045 Polish
Int
GetFromUrl
Gets url attribute, usefull on custom pages e.g. you have a page with constructed URL http://...?something&key=55 then you may filter your webpart writing ="MyKey=" + GetFromUrl("key")
KeyName [String] Required, Url attribute name
String
GetFromWebpart
Gets selected values from another webpart on same page
Webpart [String] Required, Title of the webpart
Field [String] Required, Name of the field
String
GetGroup
Gets group by its title e.g. to set row dedicated permissions CanGroupRead = GetGroup("My Group title")
GroupTitle [String] Optional
Lookup
GetList
Gets table by its key name e.g. GetList("MyCustomList")
KeyName [String] Required, List key name
Table
GetTable
Gets table by its key name e.g. GetTable("MyCustomTable")
KeyName [String] Required, Table key name
Table
GetUser
Searches user by email, by login or by summary e.g. GetUser("domain\john.smith"), GetUser("john.smith@company.com"), GetUser("John Smith")
EmailLoginSummary [String] Optional, Email, login or summary
User
GuidCreate
Generates new unique GUID as String
String
If
Checks condition, returns ValueYes when condition is satisfied, otherwise returns ValueNo
Condition [Bool] Optional, Condition to be evaluated
ValueYes [String] Optional, Value to be returned when condition is satified
ValueNo [String] Optional, Value to be returned when condition is not satified
String
If2
Checks condition, returns ValueYes when condition is satisfied, otherwise returns ValueNo
Condition1 [Bool] Optional, Condition 1 to be evaluated
Value1 [String] Optional, Value to be returned when condition 1 is satified
Condition2 [Bool] Optional, Condition 2 to be evaluated
Value2 [String] Optional, Value to be returned when condition 2 is satified
Value3 [String] Optional, Value to be returned when condition 2 is not satified (otherwise)
String
If3
Checks condition, returns ValueYes when condition is satisfied, otherwise returns ValueNo
Condition1 [Bool] Optional, Condition 1 to be evaluated
Value1 [String] Optional, Value to be returned when condition 1 is satified
Condition2 [Bool] Optional, Condition 2 to be evaluated
Value2 [String] Optional, Value to be returned when condition 2 is satified
Condition3 [Bool] Optional, Condition 3 to be evaluated
Value3 [String] Optional, Value to be returned when condition 3 is satified
Value4 [String] Optional, Value to be returned when condition 3 is not satified (otherwise)
String
IsModified
Yes when value was modified. See also OldValue
Value [Any] Optional, Value to be checked
Bool
IsNipPL
Checks whether string satifies polish rules for NIP
NIP [String] Optional
Bool
IsNull
Yes has no value. Opposite to IsValue
Value [Any] Optional, Value to be checked
Bool
IsPeselPL
Checks whether string satifies polish rules for PESEL
PESEL [String] Optional
Bool
IsRegonPL
Checks whether string satifies polish rules for REGON
Regon [String] Optional
Bool
IsValue
Yes when has value. Opposite to IsNull
Value [Any] Optional, Value to be checked
Bool
New
Creates new in-memory data record for given table e.g. New("MyCustomList"). In order to save it use Insert("Your comment")
TableName [String] Required, Table key name
Lookup
NewProcess
Creates new in-memory request record for given workflow e.g. New("Workflow Title"). In order to save it use Start("Your comment")
WorkflowTitle [String] Required, Workflow title
Process
Not
Returns opposite value of Bool
Value [Bool] Optional, Bool value to be evaluated
Bool
OldValue
Returns the oryginal value, before it was modified. See also IsModified
Value [Any] Optional, Value to be checked
String
SendEmail
Sends email, returns True when sent ok
To [String] Required, List of receipients TO separated with comma. You can use group names to send to all group members
Cc [String] Optional, List of receipients CC separated with comma. You can use group names to send to all group members
Subject [String] Required
Body [Html] Optional, Email HTML content
Bool
SendLog
Sends email to administrators (Administration => Parameters => EmailNotifyAdminOnError) about currently running script. Normally when script fails such notification is sent, but when everything works ok and we are not sure what is really going on we may read it in inbox without other interruptions
Keyword [String] Optional, Keyword to distinguish emails e.g. you have multiple SendLog("1") SendLog("2") so then you see which one worked for you
Bool
SetPermission
Sets current row specific permission for maximum one person that can read or can edit row
CanRead [User] Optional, User that can read row
CanEdit [User] Optional, User that can edit row
Bool
SqlDatesRange
Returns sql query for finding dates ranges. Helpful in complex dates spans comparisions.
FieldStart [String] Required, Range 1 FROM in table, name of the DateOnly or DateTime field
FieldEnd [String] Required, Range 1 TO in table, name of the DateOnly or DateTime field
ValueStart [DateTime] Optional, Range 2 FROM value
ValueEnd [DateTime] Optional, Range 2 TO value
Option [Int] Required, Options how to compare. For now always 1 meaning any range od dates ovelaps
String
Stop
Stops running, displaying message
Message [String] Required
Bool
Update
Updates current data record
Comment [String] Optional
Bool
 
Object methods e.g. MyStringField.Substring(...)
Function
Description
Arguments
Returns
ChoiceString
ChoiceString.EndsWith
Returns TRUE when ChoiceString ends with given one
Value [String] Optional, String to find
Bool
ChoiceString.StartsWith
Returns TRUE when ChoiceString starts with given one
Value [String] Optional, String to find
Bool
ChoiceString.ToDecimal
Tries to return decimal value of the ChoiceString, otherwise 0
Decimal
ChoiceString.ToInt
Tries to return integer value of the string, otherwise 0
Int
DateOnly
DateOnly.AddDays
Example AddDays(5), AddDays(-5)
Units [Int] Optional
DateOnly
DateOnly.AddHours
Example AddHours(5), AddHours(-5)
Units [Int] Optional
DateTime
DateOnly.AddMinutes
Example AddMinutes(5), AddMinutes(-5)
Units [Int] Optional
DateTime
DateOnly.AddMonths
Example AddMonths(5), AddMonths(-5)
Units [Int] Optional
DateOnly
DateOnly.AddWorkingDays
Example AddWorkingDays(5) adds working days based on the area calendar
Units [Int] Optional
DateOnly
DateOnly.AddYears
Example AddYears(5), AddYears(-5)
Units [Int] Optional
DateOnly
DateOnly.Day
Returns day part
Int
DateOnly.Month
Returns month part
Int
DateOnly.ToDateTime
Example CurrentDateOnly().ToDateTime().AddMinutes(5)
DateTime
DateOnly.ToString
Formats date only e.g. ToString("yyyy-MM-dd")
Format [String] Optional
String
DateOnly.Year
Returns year part
Int
DateTime
DateTime.AddDays
Example AddDays(5), AddDays(-5)
Units [Int] Optional
DateTime
DateTime.AddHours
Example AddHours(5.5), AddHours(-5)
Units [Decimal] Optional
DateTime
DateTime.AddMinutes
Example AddMinutes(5), AddMinutes(-5)
Units [Int] Optional
DateTime
DateTime.AddMonths
Example AddMonths(5), AddMonths(-5)
Units [Int] Optional
DateTime
DateTime.AddWorkingHours
Example AddWorkingHours(5.5) adds working hours based on the area calendar
Units [Decimal] Optional
DateTime
DateTime.AddYears
Example AddDays(5), AddDays(-5)
Units [Int] Optional
DateTime
DateTime.Day
Returns day part
Int
DateTime.Hour
Returns hour part
Int
DateTime.Minute
Returns minutes part
Int
DateTime.Month
Returns month part
Int
DateTime.Second
Returns seconds part
Int
DateTime.ToDateOnly
Example CurrentDateTime().ToDateOnly() will result as CurrentDateOnly()
DateOnly
DateTime.ToString
Formats date time e.g. ToString("yyyy-MM-dd HH:mm:ss")
Format [String] Optional
String
DateTime.Year
Returns year part
Int
Decimal
Decimal.Ceiling
Converts Decimal to closest Int that is greater or equal e.g. (1/3).Ceiling() = 2
Int
Decimal.Floor
Converts decimal to closest Int that is less or equal e.g. (1/3).Floor() = 2
Int
Decimal.Round
Rounds decimal value to closest decimal having required decimal digits e.g. decimal.Round(2) = decimal.14
Decimals [Int] Optional, Resulting decimal digits
Decimal
File
File.EndsWith
Returns TRUE when file name ends with given one
Value [String] Optional, String to find
Bool
File.OCR
Returns text extracted from file
TopLeftX [Int] Optional, X coordinates of the top left point
TopLeftY [Int] Optional, Y coordinates of the top left point
Width [Int] Optional, Width
Height [Int] Optional, Heidth
String
File.SetTextFile
Adds, clears or replaces File field with new text file created from string e.g. MyField.SetTextFile("filename.xml", myString). Both must have values, otherwise field is cleared. Please note that you cannot use variables for managing files
Filename [String] Optional, Filename with extension e.g. MyFile.xml
Content [String] Optional, Text to be inserted as file content
Bool
File.StartsWith
Returns TRUE when file name starts with given one
Value [String] Optional, String to find
Bool
FileMulti
FileMulti.Count
Gets number of files
Int
FileMulti.EndsWith
Returns TRUE when file names end with given one
Value [String] Optional, String to find
All [Bool] Optional, 1 all file names, 0 any file name
Bool
FileMulti.SetTextFile
Adds, clears or replaces one file in a FileMulti field with new text file created from string e.g. MyField.SetTextFile("filename.xml", myString). Both must have values to set file, no filename clears all files e.g. MyField.SetTextFile("","anything"), no content clears given file only e.g. MyField.SetTextFile("file1.docx","") will remove one file1.docx only
Filename [String] Optional, Filename with extension e.g. MyFile.xml
Content [String] Optional, Text to be inserted as file content
Bool
FileMulti.StartsWith
Returns TRUE when file names start with given one
Value [String] Optional, String to find
All [Bool] Optional, 1 all file names, 0 any file name
Bool
Html
Html.Replace
Returns html with replaced text. It is important to note, that html is not touched, only text in between tags (opposed to String.Replace)
Find [String] Optional, What to find and replace
Replace [String] Optional, Replace with what
Html
Int
Int.ToString
Formats int with trailing zeros e.g. (5).ToString("000") = "005")
Format [String] Optional
String
Lookup
Lookup.Delete
Deletes completely record of data
Comment [String] Optional
Bool
Lookup.Insert
Inserts data record created earlier with New()
Comment [String] Optional
Bool
Lookup.Recalculate
Recalculates formulas
Bool
Lookup.Update
Updates data record
Comment [String] Optional
Bool
LookupMulti
LookupMulti.Count
Gets number of lookups
Int
Process
Process.Start
Starts a new process created earlier with NewProcess()
Comment [String] Optional
Bool
String
String.EndsWith
Returns TRUE when string ends with given one
Value [String] Optional, String to find
Bool
String.Length
Returns length of string
Int
String.Replace
Returns text with replacements e.g. ("abcde").Replace("ab", "12") returns "12cde"
Find [String] Optional, What to find and replace
Replace [String] Optional, Replace with what
String
String.StartsWith
Returns TRUE when string starts with given one
Value [String] Optional, String to find
Bool
String.Substring
Returns substring text, index is 1 based e.g. ("abcde").Substring(2,2) returns "bc"
Index [Int] Optional, Starting index, first letter is 1
Length [Int] Optional, Number of letters
String
String.ToDecimal
Tries to return decimal value of the string, otherwise 0
Decimal
String.ToInt
Tries to return integer value of the string, otherwise 0
Int
String.ToKeyName
Returns key name using Pascal Casing, concatenating Words, each Word starts with Capital letter, no spaces, cannot start with digit, replacing ą with a, Ü with u etc.
String
Table
Table.Count
Calculates quantity of rows satisfying the query e.g. to get count of children records pointing this table GetList("ChildrenList").Count("ParentLookupTo=" + Id)
Query [String] Optional, Query normal filter
Int
Table.Delete
Deletes rows satisfying the query. Returns number of rows deleted
Query [String] Optional, Query normal filter
Comment [String] Optional
Int
Table.First
Finds one row, first satisfying the query
Query [String] Optional, Filter
Lookup
Table.GetRowFirst
Finds one row, first satisfying the query
Query [String] Required, Filter
Lookup
Table.GetRowMax
Finds one row, having maximum value in field and satisfying the query
FieldMax [String] Required, Field name having the maximum
Query [String] Required, Filter
Lookup
Table.GetRowMin
Finds one row, having minimum value in field and satisfying the query
FieldMin [String] Required, Field name having the minimum
Query [String] Required, Filter
Lookup
Table.GetRows
Returns all the rows satisfying the query e.g. GetTable("MyTable").GetRows("Firstname='" + thisFieldName + "'")
Query [String] Optional, Filter
LookupMulti
Table.GetRowsByDateRange
Returns all the rows satisfying the query e.g. GetTable("MyTable").GetRowsByDateRange("Firstname='" + thisFieldName + "'", "FieldDateFrom", "FieldDateTo", ValueFrom, ValueTo, 1)
Query [String] Optional, Extra filter
FieldStart [String] Required, FROM field name (DateOnly or DateTime)
FieldEnd [String] Required, TO field name (DateOnly or DateTime)
ValueStart [DateTime] Optional, FROM value
ValueEnd [DateTime] Optional, TO value
Option [Int] Required, Options how to compare. For now always 1 meaning any range od dates ovelaps
LookupMulti
Table.Max
Finds one row, having maximum value in field and satisfying the query
FieldMax [String] Required, Field name having the maximum
Query [String] Required, Filter
Lookup
Table.Min
Finds one row, having minimum value in field and satisfying the query
FieldMin [String] Required, Field name having the minimum
Query [String] Required, Filter
Lookup
Table.Sum
Calculates sum of values for the rows satisfying the query e.g. to get sum of children records pointing this table GetList("ChildrenList").Sum("ColumnToSum", "ParentLookupTo=" + Id)
FieldSum [String] Required, Field to sum up
Query [String] Required, Query normal filter
Decimal
User
User.IsInGroup
Checks whether user belongs to the group or not
Group [String] Required, Group title
Bool
UserMulti
UserMulti.Count
Gets number of users
Int