10,730
edits
Line 308: | Line 308: | ||
! Function name || Description || Variable data types || Argument data types | ! Function name || Description || Variable data types || Argument data types | ||
|- | |- | ||
| | | AddDays || Returns DateTime argument plus X days || DateTime || Arg1: DateTime; Arg2: Number | ||
|- | |||
| AddHours || Returns DateTime argument plus X hours || DateTime || Arg1: DateTime; Arg2: Number | |||
|- | |||
| AddItem || Adds argument to end of list. || StringList || Arg1: Number, Boolean, String, DateTime | |||
|- | |- | ||
| | | Addition || Returns addition of arguments || Number || Arg1: Number; Arg2: Number | ||
|- | |- | ||
| | | AddMinutes || Returns DateTime argument plus X minutes || DateTime || Arg1: DateTime; Arg2: Number | ||
|- | |- | ||
| | | AddMonths || Returns DateTime argument plus X months || DateTime || Arg1: DateTime; Arg2: Number | ||
|- | |- | ||
| | | AddParty || Adds a party to an activity || Activity Entity || User | ||
|- | |- | ||
| AddPrefix || Adds argument value as prefix to variable || Text || Text, Number, Boolean, Date | | AddPrefix || Adds argument value as prefix to variable || Text || Text, Number, Boolean, Date | ||
|- | |- | ||
| | | AddSufix || Adds argument value as suffix to variable || Text || Text, Number, Boolean, Date | ||
|- | |- | ||
| | | AddWeeks || Returns DateTime argument plus X weeks || DateTime || Arg1: DateTime; Arg2: Number | ||
|- | |- | ||
| | | AddYear || Returns DateTime argument plus X years || DateTime || Arg1: DateTime; Arg2: Number | ||
|- | |- | ||
| | | Assign || Assigns value to variable || Text, Number, Boolean, Date || Variable data type, all types for text variable | ||
|- | |- | ||
| | | AssignNew || Creates a new instance of an object in the variable | ||
|- | |- | ||
| | | Clear || Assigns null or empty value to variable || Text, Number, Boolean, Date || | ||
|- | |- | ||
| | | ClearItems || Removes all items from list variable || StringList || | ||
|- | |- | ||
| | | Concat || Returns concatenated string from two arguments || Text || 2 args: Text, Number, Boolean, Date | ||
|- | |- | ||
| | | Concat3 || Returns concatenated string from three arguments || Text || 3 args: Text, Number, Boolean, Date | ||
|- | |- | ||
| | | Convert || Converts value from string || Number, Boolean, Date || String value | ||
|- | |- | ||
| | | Delete || Deletes the record || Entity || | ||
|- | |- | ||
| | | Difference || Returns difference between first and second arguments || Number || Arg1: Number; Arg2: Number | ||
|- | |- | ||
| | | Element At || | ||
|- | |- | ||
| | | Exponentiation || Returns the nth exponent of a given number || Number || Arg1: Number; Arg2: Number | ||
|- | |- | ||
| | | Division || Returns division of arguments || Number || Arg1: Number; Arg2: Number | ||
|- | |- | ||
| | | ExecuteJS || [[Execute JavaScript from rules]] || Boolean, String, Number, Money, DateTime, StringList, Entity, Lookup || Arg1: name of the IFrame form tab that links to the script; Arg2: name of the JavaScript function | ||
|- | |- | ||
| | | Format || Returns formatted string from StringList ([[Formatting strings in rules|How to use?]]) || Text || Arg1: Text; Arg2: StringList | ||
|- | |- | ||
| | | Get Date Part || Return a portion of a date time field || DateTime | ||
|- | |- | ||
| | | GetItem || Returns item at specified index. || StringList || Number | ||
|- | |- | ||
| | | GetUnixTime || Converts datetime into unix time || Number || Arg1: Date Time | ||
|- | |- | ||
| | | IndexOf || Returns the first occurrence of a specified substring within a string || Number || Arg 1: String; Arg 2: substring | ||
|- | |- | ||
| | | InsertItem || Adds argument to specified index. Index starts at 0. || StringList || Arg1: Number, Boolean, String, DateTime; Arg2: Number | ||
|- | |- | ||
| | | LengthOf || Return the length of a string || Number || Arg1: String | ||
|- | |- | ||
| | | LoadAggregate || Allows you to use Fetch XML aggregation functions || || Arg1: entity; Arg2: field; Arg3: aggregation function | ||
|- | |- | ||
| | | Logarithm || Returns the logarithm to the base n of a given number || Number || Arg1: Number; Arg2: Number | ||
|- | |- | ||
| | | Multiplication || Returns product of arguments || Number || Arg1: Number; Arg2: Number | ||
|- | |- | ||
| | | Negate || Returns negated value of argument || Boolean || Boolean | ||
|- | |- | ||
| | | N-th Root || Returns the nth root of a given number || Number || Arg1: Number; Arg2: Number | ||
|- | |- | ||
| RemoveItem || Removes item at specified index || StringList || Number | | RemoveItem || Removes item at specified index || StringList || Number | ||
|- | |- | ||
| RemoveParty || Removes a party from an activity || Activity Entity || User | | RemoveParty || Removes a party from an activity || Activity Entity || User | ||
Line 392: | Line 388: | ||
| SaveAfter || (OnSave, OnExecute rule only) Saves an entity record that you created or changed in rules || Entity || Arg1: Other entity that must be saved first | | SaveAfter || (OnSave, OnExecute rule only) Saves an entity record that you created or changed in rules || Entity || Arg1: Other entity that must be saved first | ||
|- | |- | ||
| | | SetNow || Assigns current time to variable || DateTime || | ||
|- | |||
| SetToday || Assigns current day to variable || DateTime || | |||
|- | |||
| SetTomorrow || Assigns tomorrow to variable || DateTime || | |||
|- | |- | ||
| | | Substring || Returns a sub-string || Text || Arg1: Text; Arg2 and Arg3: Number | ||
|- | |- | ||
| | | TimeDifference || Returns difference between first and second argument || Number || Arg1: Date Time; Arg2: Date Time; Arg3: unit of time | ||
|} | |} | ||