0
edits
Changes
no edit summary
<u>'''General Description'''</u>
This field type is used to present the user with a spreadsheet that is compatible with MS Excel. This spreadsheet is stored as part of the record and can be exported as a .xls file, or be opened directly by MS Excel.
The '''Spreadsheet''' field will manifest on the record in both '''View''' and '''Edit''' mode as a button:
:[[Image:SpsView.png]]
When '''Open''' is clicked:
'''View Mode:'''
:[[Image:Sps2View.png]]
'''Edit Mode:'''
:[[Image:SpsEdit.png]]
<u>'''Field Options''' </u>
* '''Display Order''': The order (relative to other fields) in which this field is displayed
* '''Tab Name''': Displays the field under a given tab
* '''Field Name''': The name of the field, used internally to reference the user's input
* '''[[Caption]]''': The leading question or prologue before the field
<u>'''Special Options for Field'''</u>
* '''Values''': Allows you to define a template including default values and formulas. See [[#Template|below]].
<u>'''Field Formatting Options'''</u>
* '''[[Tool Tip]]''': Enter help text to be shown on mouse-over
* '''HTML Tag''': Additional attributes to the field HTML tag
* '''[[Visibility Condition]]''': Conditions upon which the field is visible
<u>'''[[Role Field Permissions|Role - Field Permissions]]'''</u>
These [[Role Field Permissions|fields]] allow you to control by [[Role]] who is allowed to view and/or modify the field.
<u>'''[[Status Field Permissions|Status - Field Permissions]]'''</u>
* ''Only present within the [[Universal Tracking Application]]''
These [[Status Field Permissions|fields]] allow you to control by the [[Status]] of the record whether or not the field can be viewed and/or modified.
==Notes==
===Template===