Home User Manual Discussion Forum Search

Sheets: Input Fields

Input fields are a type of Sheet Field used to indicate areas where a user will enter data.  They are commonly used in patient forms and medical histories where entered data can be Imported directly to the database. 

Note: Medication, allergy, and problem input fields for medical histories require special setup. See Sheets: Medical History Setup.

On the Edit Sheet Def window, click InputField.

Field Name: The available input fields for the selected sheet type.

  • Database fields can be imported.
  • 'misc' can be used to collect information that doesn't correspond to a database field.  The entered data cannot be imported, but can be reported in a Custom Query. Entered data is stored in the sheetfield.fieldvalue column in the sheetfield table. Make sure to enter a corresponding Reportable Name. An example of a custom query is at the bottom of this page.

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.

  • Name: We recommend using common fonts (e.g. Times New Roman, Arial, Courier) and testing sheets on a browser and device you plan to support.  Font support is dependent on the browser used to view the web form.  If a browser doesn't support a font, a different font will be substituted and this can affect layout of the sheet. 
  • Size:  Font point size.
  • Bold (checked) or not bold (unchecked).

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:

  • None: No growth behavior.
  • Down Local: Typically used for the address because it is not known ahead of time if it will span one or two lines. If the field grows to two lines, the fields immediately below are bumped down (like CityStateZip).
  • Down Global: Useful for table style data and letter bodies. Bumps down all fields on the entire sheet that are below the field that's growing.

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.

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.  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 'Sheet Name',
sheetfield.ReportableName AS 'FieldReportableName', sheetfield.FieldValue AS 'FieldReportableValue' 
FROM sheet
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; 


Open Dental Software 1-503-363-5432