Sheet Input Field

Use Input Fields to indicate to users or patients where data is entered on a sheet.

In Edit Sheet Def, click Input Field.

Alternatively, double-click an existing Input Field from the Fields list to edit.

Input fields are Sheet Field Types used to indicate areas where a user will enter data.

They are commonly added to Patient Form and Medical History sheets where entered data can be imported directly to the database. See: Import Patient Forms and Medical Histories.

When a new sheet is created and viewed on a device connected to the office database, including office computers, kiosks, and eClipboard tablets, the Input Fields will automatically show any data from the chart that is in an importable field.

Note: Medication, allergy, and problem input fields for Medical History sheets require special setup.

Field Name: The available input fields for the selected sheet type. Available fields will change depending on the sheet type.

Reportable Name: Only shows when misc is the selected Field Name. Enter an identifying name for the misc field.

Mobile Caption: Caption to identify field when viewing sheet on a mobile device.

Font: These properties affect the appearance of the text.

Growth Behavior: This attribute can be set when it is not known ahead of time how large the text input will be. Setting the growth behavior causes a field to grow bigger; it will never cause a field to shrink. Click the dropdown to select an option:

X/Y Pos: Determines the placement of the upper left corner of the field in relation to the x and y axis. X = horizontal. Y = vertical.

Width: The width of the input field.

Height: The height of the input field. If font size is increased, field height may need to be increased so all text is visible.

Required: If checked, the user will be required to input data in the field before saving the form.

Tab Order: The order of the field when users press Tab on the generated form. (Hint: Click Tab Order in the right panel to view and edit the tab order of all elements on a sheet.

Auto Note: Click [...] to choose an Auto Notes template to assign to this Input Field. The Auto Note is automatically inserted when the sheet is generated in the Fill Sheet window. Not functional with mobile apps (e.g., eClipboard) or Web Forms.

Query Example for a Misc Field

Each time data is input into a reportable name input field, the value is stored in the sheetfield.fieldvalue column in the sheetfield table.

Query Example 1832 can be used to report on misc field data in a data range. See User Query for more information on running queries.