COLS Data Sheet Function

NextGen® Enterprise EHR Template Editor Help 8

COLS Data Sheet Function

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 Parent topic: Functions

NextGen® Enterprise EHR Template Editor Help, 8.3.1

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

NextGen® Enterprise EHR Template Editor Help, 8.3.1

LEN String Function

Use the MEMOLEN string function instead of the LEN function for memo fields. Use the FIELDLEN string function with the LEN function to return the remaining number of characters that can be entered in a text-type data entry field. Use: Returns the number of characters in a string Syntax: {LEN( «string» )} Arguments: «string» Character string to be evaluated Returns: The number of characters in the given string Example: Field = txt_field{template_name_.txt_field} = NextGen{LEN( {template_name_.txt_field} )} Result: 7 Parent topic: Functions See also MEMOLEN String Function FIELDLEN String Function

NextGen® Enterprise EHR Template Editor Help, 8.3.1

SUBS String Function

Use: Extracts part of a character string, starting at a specified position Syntax: SUBS( «string» , «start» , «len» )} Arguments: «string» Character string to be evaluated«start» Zero-based character position from where to begin the search«len» The number of characters to be returned Returns: The number of characters specified from the character string Example: Field = txt_field{template_name_.txt_field} = NextGen Healthcare Information Systems, LLC{SUBS( {template_name_.txt_field}, 8, 5 )} Result: Health 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.3.1

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

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

COLS Data Sheet Function

ROWID Data Sheet Function

LEN String Function

SUBS String Function

ROWS Data Sheet Function

ROWS Data Sheet Function

COLS Data Sheet Function

COLS Data Sheet Function

ROWID Data Sheet Function

LEN String Function

SUBS String Function

ROWS Data Sheet Function

ROWS Data Sheet Function