Miscellaneous Functions
Click on a function name below to continue:
|
ExcelFormula
Description | Passes an Excel formula to an Excel report. |
Remark | The input must be a string in between quotation marks. Must be the outermost function in a formula. |
Example | Ex. ExcelFormula('SUM(A1:A100)') will pass the formula SUM(A1:A100) to Excel, which will evaluate the formula when the spreadsheet is opened. |
CellValue
Description | Returns the value of the current cell. |
Remark | This function is only used in Conditional Formatting. |
Example | Suppose a cell of a report displays the price of products. Ex. CellValue()> 150 returns True if the price of the product is greater than 150. |
FilterValue
Description | Returns the current value of a filter. |
Remark | Takes two arguments. 1. The index of the filter. 2. The sub-index used for filters that contain multiple values (i.e. between or one of). If there are no filters the function will return an Index out of Range message. Indexes begin with 1. |
Example | Suppose the filter summary is “Order Detail.UnitPrice > '3.6' and Products.ProductName is one of ('Boston Crab Meat', 'Tofu')”. Ex. FilterValue(2,2) returns Tofu. |
getDocNotificationLink
Description | Returns the Document Link from User Notification. |
Remark | --- |
Example | --- |
getFormNotificationLink
Description | Returns the Form Link from User Notification. |
Remark | --- |
Example | --- |
Hyperlink
Description | Creates a hyperlink to an external website. |
Remark | Takes two arguments. 1. The URL of the website. 2. (Optional) the text to display in the cell. If display text is omitted, the URL will display. If PDF exports open in a tab within this application, then clicking the hyperlink may direct a user to leave the application. |
Example | E.g. Hyperlink('www.asite.com', 'click here') returns a hyperlink that displays the text 'click here' . Clicking this text will open http://www.asite.com. |
LoadImage
Description | Loads a server side image based on the input path into the cell. |
Remark | Can be used to load an image dynamically in place of the insert image feature. The path to the image must be in quotation marks. The entire path of the image is not required if your administrator has set a 'LoadImage' Prefix. |
Example | Ex. LoadImage('c:/StaryNight.JPG') will return |
StripHtmlTags
Description | Removes any html tags from the input string. |
Remark | The input must be a string in between quotation marks. |
Example | Ex. StripHtmlTags('<h1>This is heading 1</h1>') - returns This is heading 1. |
splitstring
Description | The input string is split between each character. |
Remark | --- |
Example | --- |
splitStringAndReturnValue
Description | Returns the value by splitting the input string. |
Remark | --- |
Example | --- |
subStringAfterLast
Description | Returns the value based on the last substring of the input string. |
Remark | --- |
Example | --- |
Next Collection: Templates - Express View