M4-CYG3-M-ENG_Iss2.doc
82
User Fields
Template Files can contain up to 40 User Fields which can be used
to collect extra information from the Gauge user when they start a
new record from a template.
Each User Field can prompt for the following types of data;
1. Alphanumeric i.e. “ABC123”
2. Number i.e. “245.6”
3. Date (dd-mm-yyyy) i.e. “21-07-2008”
4. Date (mm-dd-yyyy) i.e. “07-21-2008”
5. List i.e. “Red, Blue, Yellow, Green..”
6. Yes/No Choice
Each User Field has: a ‘Name’ field, this is used to prompt the
Gauge user to enter in information, and a ‘Value’ field to hold the
information. An optional ‘Cell Ref.’ field to specify where the Value
should be inserted in the spreadsheet.
For example;
If the User Field Type = Alphanumeric
If the User Field Name = ‘Vessel Name’
If the User Field Cell Ref = ‘Sheet 1!E20’
When the Gauge user starts a new record they will be prompted
to enter in a ‘Vessel Name’.
To Next Page
Loading...