You are here: Help Topics > Customization > Calculation > Miscellaneous Functions

Miscellaneous Functions

Function	Description
ASSIGNEDTO	Determines whether the specified user is assigned to the current document.
B64TOGUID	Converts a base64-encoded GUID to a standard 8-4-4-4-12 format.
BROWSTAT	Indicates whether a specified database browse is currently being displayed.
CANSIGN	Determines whether the specified role is able to sign off the document.
CELLCALC	Returns the calculation of the cell.
CELLCOL	Returns the table column number starting at 1 for A of the current cell.
CELLLABEL	Returns the cell label of the cell.
CELLNO	Inserts a cell number as a string into the current cell.
CELLROW	Returns the table row numbers staring at 1 of the current cell.
CELLSTR	Returns the formatted text contents of the cell.
CELLTABLE	Returns the table identifier of the cell.
COMPLETION	Returns the completion status of the current document.
COMPLTBY	Determines whether the current document meets specified sign off criteria.
CUSTPROP	Returns the custom property specified by "name".
CUSTPROPAT	Returns the custom property of an object specified by an "item id" and "property name".
CUSTPROPR	Returns a range of custom properties.
CVDATA	Returns the data associated with the provided ID from the CV Database.
CVDATAC	Returns the data associated with the provided ID from the System Database set up under Document \| Settings \| System Databases.
CVDATAL	Performs the same function as CVDATA, but takes advantage of the longer character limits for Group, Form, and Identifier introduced in version 2009.00.
CVDATALNG	Returns the data associated with the provided "Group", "Form" and/or "ID" from a specified system database.
CVDATAQRY	Performs multiple queries until it returns a non null string data associated with the provided "Group", "Form1", "ID" .. "Group", "FormN", "ID" from a specified system database.
CVDOCPOS	Returns information about the cursor position in the document.
CVFORM	Returns the current form of the default CV database group associated with the document.
CVGROUP	Returns the default CV database group associated with the document.
CVIDEA	Returns table information from a Caseware IDEA .imd file.
CVINFO	With VMERGE as the parameter, returns a Yes or No as to whether the Visual Merge Pane is currently open.
CVMENUST	Used exclusively within the State Calculation field of a Button Cell.
DOCENTSCP	Determines whether the current document's entity assignment matches a specified entity.
DOCID	Inserts the document identifier of the current CaseView document.
DOCMODE	Returns an integer that corresponds to the current document mode.
EVAL	Evaluates the value of an expression passed to it.
FIELD	Returns the value of a specified field from a specified database.
GETHIDE	Returns 1 or 2 as the Show Skipped Text button is selected and deselected.
GUIDTOB64	Converts a base64-encoded GUID to a standard 8-4-4-4-12 format.
HASTAG	Determines whether a specified object has a specified tag.
INITIALS	Returns the short name as specified in the Staff Setup dialog.
INPBLANK	Returns whether the specified paragraph is blank.
INPBLANKRC	Returns whether the specified paragraph in a table is blank.
ISADMIN	Returns whether the user is an admin.
ISCONS	Indicates whether the current client file is consolidated or not.
ISINGROUP	Indicates whether a user is a member of a specified group.
ISLOCKED	Indicates whether a file has been locked down and unlocked.
ISPLHOLDER	Determines whether the specified document is a placeholder document.
ISSUECOUNT	Returns the number of issues assigned to the current document.
ITEMPROP	Checks a memo field for a given property and returns the associated value.
KLIEXIST	When used in a Knowledge Library Link section inserted from a Knowledge Library Index, checks to see if the Knowledge Library Index associated with the Knowledge Library entry can be found.
KLIPROP	When used in a Knowledge Library Link section inserted from a Knowledge Library Index, returns information currently in the Knowledge Library Index relating to the selected Knowledge Library entry.
KLLPROP	When used in a Knowledge Library Link section inserted from a Knowledge Library Index, returns information on the selected Knowledge Library entry.
LEVEL	Returns the security level set for the current user.
LOOKUP	Allows the user to create a lookup cell that returns the contents of the referenced cell.
MKPATH	The MKPATH function converts a string parameter path name to an expended path string by replacing each \ with a \\.
NUMROLES	Returns the number of roles contained in a document.
NUMSIGNED	Returns a number of roles a document has signed.
RDYREVIEW	Returns true if the specified document is ready for review.
REPENT	Returns the entity abbreviation for the specified raw database entity code.
ROLECOMPLT	Determines whether a specified role is completed.
ROLEINDEX	Returns the index of the specified role label on a specific document.
ROLELABEL	Returns the role label for the specified role number and document.
SCRNX	Returns the width in pixels of the current display.
SCRNY	Returns the height in pixels of the current display.
SIGNOFF	Returns the signoff initials for the specified role and document.
SIGNOFFCHK	Determines if there are any illegal role sign offs on the current document.
SIGNOFFCVR	Determines if there are any sign offs making the document read only.
SIGNOFFDTE	Returns the signoff date of the specified role and document.
SIGNOFFNME	Displays the name of the user who signed off the specified role and document.
WHOAMI	Returns the name of the user currently logged in.

Miscellaneous Functions

Cookie Notice