ROWID Data Sheet Function

NextGen® Enterprise EHR Template Editor Help 8

Data Sheet Types

Type Function Table Data Appointments Displays all the appointments for the selected patient. Appointment Table Case Sheet Displays information for a specific case. Allergy, Medication, Billing ICD List, Procedures, Concepts, Templates, Documents, Images, Reports, and Emails tables. All Case Management template tables. Data Flow Sheet Displays data from multiple tables. Summarizes data from all encounters and displays the data in columns by encounter date rather than in rows. Note: If you build a Data Flow Sheet with fields from a frequently used template, at run time you may receive a large-size data grid that displays data from all relevant encounters. All template tables. Data Grid - CM Displays data entered from Case Management templates. All tables associated with the available Case Management templates. Data Grid - DM Displays data entered from Demographics templates. All tables associated with available Demographics templates. Data Grid - MR Displays data entered from Medical Re

NextGen® Enterprise EHR Template Editor Help 8

Edit Data Grid Trigger

The Edit Data Grid action enables you to add, delete, or open a record or sort the columns displayed in the following types of data grids with Extended Popup templates: Medical Records (MR), Case Management (CM), Demographics (DM), Summary, System, and Practice. You can use this trigger instead of manually selecting options from the data grid right-click menu at run time. Only data tied to the current encounter can be edited; everything else is read only. This action can be triggered from the following field events: button, label, or active image Click, or data sheet/grid Row Selected or Double Click. Follow the applicable steps in General Trigger Setup. Select the Edit Data Grid action. The Edit Data Grid window opens. Select the data grid on which you want to perform the action. From the Action list, select the applicable action: Add. Launches a blank Extended Popup template for entering a new record in the data grid. Delete. Deletes the record in the selected row. CAUTION: This acti

NextGen® Enterprise EHR Template Editor Help 8

Set up Upload Extended Data Trigger

The Upload Extended Data action enables you to insert, update, or delete Extended Popup template data in a row on a data grid/sheet. This trigger can be used for Medical Records (MR), Demographics (DM), Case Management (CM), and Summary data grids and System and Practice data sheets. You can use a row ID (database sequence number) to delete or update row data without having to select a row present on the template. Follow the applicable steps in General Trigger Setup. Select the Upload Extended Data action. The Upload Extended Data window opens. From the Type list, select the data grid/sheet type: Medical Records (default) Case Management Practice Demographics System You can enter the first few letters of the name to quickly find and select it in the list. The Table list is filled with the tables available for the selected type. From the Table list, select the applicable table. You can enter the first few letters of the name to quickly find and select it in the list. The fields in the s

NextGen® Enterprise EHR Template Editor Help 8

System Popup Data Sheet Row Selected Actions

The following actions are available for fields on Practice and System data grids and Stored Procedure data sheets. Alert Assign Field Value Assign Note Value Change Field Color DBPickList Disable Control Edit Data Grid Enable Control Fax Report Goto Field Grid Row Select Hide Item ICD SNOMED Map Launch Application Lookup External Id Modify Patient Open Chart Patient Education Patient Problem Print Report Refresh Data Grid Refresh Sidebar Refresh Template Region Highlight Reports Save Template Save & Close Template Send Email Service Item Lookup Set Default Values Show Item Stored Procedure Template Pop-Up Trigger Script Web Navigate Web XChange For information on Double Click actions on data grids, see System Popup Data Grid Double Click Actions. Parent topic: System Popup Template Events and Actions

NextGen® Enterprise EHR Template Editor Help 8

System Template Data Sheet Row Selected Actions

The following actions are available for fields on Practice and System data grids and Stored Procedure data sheets. Alert Assign Field Value Assign Note Value Change Field Color DBPickList Disable Control Edit Data Grid Enable Control Fax Report Goto Field Grid Row Select Hide Item ICD SNOMED Map Launch Application Launch Template Lookup External Id Modify Patient Open Chart Patient Education Patient Problem Print Report Refresh Data Grid Refresh Sidebar Refresh Template Region Highlight Reports Save Template Save & Close Template Send Email Service Item Lookup Set Default Values Show Item Stored Procedure Trigger Script Web Navigate Web XChange For information on Double Click actions on data grids, see System Template Data Grid Double Click Actions. Parent topic: System Template Events and Actions

NextGen® Enterprise EHR Template Editor Help 8

MR Data Sheet Row Selected Actions

The following actions are available on the Data Sheet field types: Appointments, Case Sheet, Data Grid - CM, Data Grid - DM, Data Grid - MR, Employer, Encounter Sheet, Family Unit, Practice, Problem List, Problem Notes, Race, Relationship, Stored Procedure, Summary Data Grid, Summary Sheet, System, and Tracked Problems. For more information on Double Click actions, see MR Data Grid Double Click Actions. For information on actions available for Data Flow Sheets and Orders Summary Sheets, see MR Save, Copy Forward, and Equipment Notify Actions. Alert Assign Field Value Assign Note Value Change Field Color DBPickList Disable Control Edit Data Grid Enable Control Export Audio Fax Note Fax Report Goto Field Goto Module Grid Row Select Hide Item ICD SNOMED Map Launch Application Launch Document Launch Image Launch Template Lookup External Id Modify Patient Open Chart Patient Appointments Patient Allergy Patient Diagnosis Patient Implantable Device Patient Education Patient Item Patient Lab O

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.

ROWID Data Sheet Function

Recommendations

Data Sheet Types

Edit Data Grid Trigger

Set up Upload Extended Data Trigger

System Popup Data Sheet Row Selected Actions

System Template Data Sheet Row Selected Actions

MR Data Sheet Row Selected Actions

Data Sheet Types

Edit Data Grid Trigger

Set up Upload Extended Data Trigger

System Popup Data Sheet Row Selected Actions

System Template Data Sheet Row Selected Actions

MR Data Sheet Row Selected Actions