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.
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.
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.
Each time data is input into a reportable name input field, the value is stored in the sheetfield.fieldvalue column in the sheetfield table. Below is an example query used to report on a 'misc' field for 'Hormone Sat Lev' for a specific date range:
/*Misc sheet field report for sheets created in date range*/
SET @SheetName='Hormone Survey'; /*Enter description of sheet here (sheet name)*/
SET @ReportableName='Hormone Sat Lev'; /*Enter the reportable name of the misc field here (from sheet field)*/
SET @FromDate='2015-01-01', @ToDate='2015-12-31'; /*Set sheet date range here*/
SELECT p.PatNum AS 'Pat#', CONCAT(p.LName,', ',p.FName) AS 'Patient Name', sheet.DateTimeSheet, sheet.Description AS 'SheetName',sheetfield.ReportableName AS 'FieldReportableName', sheetfield.FieldValue AS 'FieldReportableValue'
INNER JOIN patient p ON p.PatNum=sheet.PatNum
INNER JOIN sheetfield ON sheetfield.SheetNum=sheet.SheetNum
WHERE sheet.Description LIKE @SheetName
AND sheetfield.ReportableName LIKE @ReportableName
AND DATE(sheet.DateTimeSheet) BETWEEN @FromDate AND @ToDate;