ROWS Data Sheet Function

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

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

REPEAT String Function

Use: Repeats a string a specified number of times Syntax: {REPEAT( «string» , «num»)} Arguments: «string» String value to repeat«num» Number of times to repeat Returns: A string of the repeated substrings Example: {REPEAT( XYZ , 3)} Result: XYZXYZXYZ Parent topic: Functions

NextGen® Enterprise EHR Template Editor Help 8

ISVISIBLE Function

Use: Indicates whether a field is visible or hidden on a template. The result can be used in the condition for a Show Item trigger, Hide Item trigger or Refresh Data Grid trigger. This function is not supported for a collapsible panel, order control, or sub template. Syntax: {ISVISIBLE( «field» )} Arguments: «field» Field name Returns: 1 = Visible 0 = Hidden Example: Data Sheet field = encounter_sheet_001Button field = assign_function_valueNumeric data entry field = isvisible_indicatorOn the assign_function_value button field, set up a Button Click event/Assign Field Value trigger with the following value calculation: template_name_.isvisible_indicator = {ISVISIBLE( encounter_sheet_001 )} Result: The encounter sheet field is visible on the template, so 1 displays in the isvisible_indicator field. Parent topic: Functions

NextGen® Enterprise EHR Template Editor Help 8

SQRT Function

Use: Calculates the square root of the provided value Syntax: {SQRT(<<value>>)} Arguments: <<value>> Numeric or decimal value Returns: The calculated square root as decimal Example: {SQRT(144)} Result: 12 Parent topic: Functions

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

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

ROWS Data Sheet Function

Recommendations

ROWID Data Sheet Function

FLOOR Function

REPEAT String Function

ISVISIBLE Function

SQRT Function

ASSIGN Function

ROWID Data Sheet Function

FLOOR Function

REPEAT String Function

ISVISIBLE Function

SQRT Function

ASSIGN Function