Sheet Input Field
Input fields are Sheet Field Types used to indicate areas where a user will enter data.
When Edit Sheet Def, click InputField.
They are commonly used in patient forms and medical histories where entered data can be imported directly to the database. (Import Patient Forms and Medical Histories).
Field Name: The available input fields for the selected sheet type.
Reportable Name: Only shows when misc is the field name. Enter an identifying name for the misc field.
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 you increase font size, you may need to increase field height so that 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;