Data Sheet Data Limit

NextGen® Enterprise EHR Help

Data Loading for Hidden Data Sheets

If a data sheet is hidden, an option may be in place to disable data loading when the template is opened. Parent topic: Data Sheets

NextGen® Enterprise EHR Help

Data Sheet Memo Field Text

If a memo field in a data sheet contains a large amount of text, the text is displayed when you hover over the field. Parent topic: Data Sheets

NextGen® Enterprise EHR Help

Data Sheets

This section provides information on: Data loading for hidden data sheets Sorting data sheets for display only Viewing lengthy text in a data sheet memo field Editing data copied forward in a Data Grid - MR Data limit Data Sheet Data Limit Special Sort Data Sheet Data Loading for Hidden Data Sheets Data Sheet Memo Field Text Data Grid - MR Copy Forward Data Parent topic: Using Templates

NextGen® Enterprise EHR Template Editor Help 8

Insert a Data Sheet Field

At run time, data sheets are prevented from loading more data than can be allocated. The limit is 200,000 cells of data including headers. If the limit is exceeded, a message window appears. Drag the Data Sheet icon from the Fields toolbar to the template design area where you want to place it. The Insert Data Sheet window opens. This example shows the data sheet options that are available for an Encounter Sheet. Other options appear for different data sheet types and tables. From the Type list, select the type of data sheet you need to insert. The default type is based on the template type. For example, if the data sheet is on a Medical Records template, the default data sheet type is Encounter Sheet. If you select Relationship, the View list appears. You can select the relationship of the person to the patient from the list. For instructions on setting up a data sheet using a stored procedure, see Stored Procedure Data Sheets. For instructions on setting up a data sheet for a problem

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

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

Data Sheet Data Limit

Recommendations

Data Loading for Hidden Data Sheets

Data Sheet Memo Field Text

Data Sheets

Insert a Data Sheet Field

COLS Data Sheet Function

ROWS Data Sheet Function

Data Loading for Hidden Data Sheets

Data Sheet Memo Field Text

Data Sheets

Insert a Data Sheet Field

COLS Data Sheet Function

ROWS Data Sheet Function