COLS Data Sheet Function

NextGen® Enterprise EHR Template Editor Help 8

FLOOR Function

Use: Calculates the floor of the provided value. Syntax: {FLOOR( «value» )} Arguments: «value» Numeric or decimal value Returns: The rounds down to the integer. Example: {CEILING(7.2) Result: 7 Parent topic: Functions

NextGen® Enterprise EHR Template Editor Help 8

MEMOLEN String Function

Use the FIELDLEN string function with the MEMOLEN function to return the remaining number of characters that can be entered in a memo-type data entry field. Syntax: {MEMOLEN( «string» )} Arguments: «string» Character string to be evaluated Returns: The number of characters in the given string Example: Field = txt_memo{template_name_.txt_memo} = 25 characters{MEMOLEN( {template_name_.txt_memo} )} Result: 25 Parent topic: Functions

NextGen® Enterprise EHR Template Editor Help 8

ORNOTEQUAL Function

Use: Compares multiple fields or variables to a specified value to determine if any of their values are not equal. This function uses OR logic where any value being compared may not equal the source value in order to return an equal value for the group. You can compare values with or without regard to case (case sensitive or case insensitive). For example, in a case-insensitive comparison, abc is the same as ABC or aBc. Note: The OREQUAL function compares multiple fields or variables to a specified field or variable to determine if any are equal. Syntax: {ORNOTEQUAL( «no case» , «compare_to» , «value1» , «value2»,,,, )} Arguments: «no case» 1 = case insensitive 0 = case sensitive«compare_to» Field to compare other values to«value1» Field to be compared You can type "PICK: to display the Picklist window for selecting a picklist to determine if any of its values is not equal to the source value. «value2»,,,, (to «valuen») Each additional field to be compared Returns: 1 = Not equal 0 = Eq

NextGen® Enterprise EHR Template Editor Help 8

ASSIGN Function

Use: Assigns the source value to a list of destination parameters (fields and/or variables). Syntax: {ASSIGN( «source» , «dest1», «dest2»,,,, )} Arguments: {source} Source value«dest1» Field or variable to be assigned the source value«dest2»,,,, (to «destn») Each additional field or variable to be assigned the source value Returns: The source value Example: Source value = ""dest1 = template_name_.field1dest2 = template_name_.field 2dest3 = @variable1{ASSIGN( "" , template_name_.field1 , template_name_.field2 , @variable1)} Result: An empty value is assigned to the destination fields and variable. Parent topic: Functions

NextGen® Enterprise EHR Template Editor Help 8

ROWS Data Sheet Function

Use: Displays the number of rows in a data sheet on the template Syntax: {ROWS( «datasheet» )} Arguments: «datasheet» Name of the data sheet Note: The data sheet must be on the same template as the function. Returns: The number of data sheet rows Example: Data sheet vital_signs{ROWS( vital_signs )} Result: 6 Parent topic: Functions

NextGen® Enterprise EHR Template Editor Help 8

ROWID Data Sheet Function

Use: Displays the database sequence number (seq_no) for a row selected from a data grid on the template. Note: This function can be used only with the following data sheet types: Data Grid - CM, Data Grid - DM, Data Grid - MR, and Summary Data Grid. The sequence number is returned only if the selected row belongs to the current encounter. Syntax: {ROWID( «datagrid» )} Arguments: «datagrid» Name of the data grid Note: The data grid must be on the same template as the function. Returns: The sequence number (globally unique identifier (GUID)) from the database table that holds the information contained in the row. Example: Data grid allergy_ext_popup with selected row{ROWID( allergy_ext_popup )} Result: The sequence number for the selected row is displayed in the edit field assigned the value. Parent topic: Functions

Use:	Displays the number of columns in a data sheet on the template
Syntax:	`{COLS( «datasheet» )}`
Arguments:	`«datasheet» Name of the data sheet` Note: The data sheet must be on the same template as the function.
Returns:	The number of data sheet columns
Example:	`Data sheet CARD_CHFScreeningQuestions {COLS(CARD_CHFScreeningQuestions)}` Result: 3

COLS Data Sheet Function

Recommendations

FLOOR Function

MEMOLEN String Function

ORNOTEQUAL Function

ASSIGN Function

ROWS Data Sheet Function

ROWID Data Sheet Function

FLOOR Function

MEMOLEN String Function

ORNOTEQUAL Function

ASSIGN Function

ROWS Data Sheet Function

ROWID Data Sheet Function