Home : Form Options
Q11397 - INFO: Form Options

Set options for the Custom Data Entry Form such as printing, how enter key works, etc...

FIELDS:

Form Name:  Name of the form.  Use the  button to edit the name of the form.

Margins:  Increase or decrease print margins on the outside edges of the form by clicking the up and down arrows for the margin you want to adjust.

Orientation:  Select the orientation for the report.  Portrait is with the short sides of the page horizontal.  In the Landscape position, the long sides are horizontal.

Paper Size: Choose which paper size the report will be printed on from the pulldown list.

Save Copy of Daily Bench Sheet:   With this box checked, a bench sheet will be saved for each day.  This feature allows the user to create custom bench sheets that do calculations on the bench sheet and store only the results in variables in the database.  Raw data values will then be saved on that days bench sheet. 

Whenever the result of a cell's formula done on a Custom Data Entry Form is to be stored in a variable, it is strongly recommended that this feature is used.

Default Logbook:  Sets which logbook is set as the default when making logbook entries with the form.

Max Cols:  Sets the number of columns in the form.  NOTE:  Rows cannot be increased.

Auto Advance:  When it's on, this feature causes the cell selector to advance to the next data entry cell.  The next data entry cell is any cell with:

  • A white background
  • A light yellow background indicating the cell value is outside Entry Range for the variable.
  • A light red background indicating the cell value is a daily violation.
  • A background color listed on Facility Setup Colors Tab- Custom Data Entry Auto Advance Colors   A light orange background indicating value is a daily violation and outside the entry range.

Each time the user presses the enter key.  It will seek for the next entry cell below the current location if the Enter Key Action is set to "Down"  and if the Enter Key Action is set to "Across" the data entry cell to the right will be found.  This setting sets whether the form by default has Auto Advance on or off. 

Enter Key Action:  This default setting determines how the cell selector moves when the user presses the Enter key.  The two settings are "Down" and "Across".  This option sets the default for when the form is used for data entry.  It may be toggled between "Down" and "Across" in data entry mode.

Overwrite Mode:  This default setting determines the edit mode used as each cell is selected during data entry.  If it is set to on, existing data in a cell is replaced as soon as the user begins typing a new value.  When it is off, the user must double click to highlight existing data before it is replaced.

Locked Cell Colors:  Used to specify whether to display locked cells in a specified color.  Cells are locked when using a form (i.e. when the form is being used to enter data, not in design) for a variety of reasons: 

  • when they refer to a calculated variable
  • when they contain a spread formula
  • when the user does not have the rights to edit the data - Variable has it's data read-only flag set, outside the user's data approval settings, or the user type does not allow data to be edited (i.e. Entry or Read-Only users). 

Check Auto Set Colors of Locked Cells To:  and pick the colors for locked cells.  If unchecked, the locked cells will be displayed in whatever color the user has specfied for that cell. 

NOTE:  Data that is locked by the Facility Lock Date will appear in a light blue background indicating they are locked and overrides this setting. 

Form Date Type: Specifies a date that will be loaded when using the form.  Example, if set to Sunday - only a Sunday will be loaded.  When using a form, if the user picks any other day of the week, the previous Sunday will be selected.  This allows you to design forms that the start date of the form will be a certain day of the week, first day of the month, or last day of the month. 

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 7/31/2008 11:37 AM.
Last Modified on 5/22/2018 1:11 PM.
Last Modified by Scott Dorner.
Article has been viewed 3470 times.
Rated 6 out of 10 based on 2 votes.
Print Article
Email Article