Smartstaff, administrator
421
edits
Changes
no edit summary
{{Template:Deprecated}}
<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
<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
<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.
===Instructions===
* If no Template is defined in the '''Values''' field, the first time the Open button is clicked a blank spreadsheet will need to be created by selection '''New''' from the '''File''' menu and entering the desired dimensions of the spreadsheet
: [[Image:NewSps.png]]* '''IMPORTANT:''' Each time the '''Spreadsheet''' is edited the changes must be saved by clicking File > Save.
Modifications to the '''Spreadsheet''' will be lost if the window is closed without first saving.
===Template===
The '''Values''' field allows you define a template including formatting, formulae and initial default values.
* The default template can be created by creating a record that contains a '''Spreadsheet''' custom field. Create the spreadsheet as desired, including any formatting, formulas and initial values. Then from the Spreadsheet menu select '''View''' and then '''Source'''. The HTML shown can be copied and pasted into the '''Values''' field.
'''Sample:'''
===Variables===
'''Syntax:'''
*Range of CellsSingle Cell: :<span style="font -size=3: medium;">@sps.''fieldname''.A1:C1B2@</fontspan>* Range of Cells:<font size=3>@sps.''fieldname''.A1:C3@</font>
: <span style="font-size: medium;">@sps.''fieldname''.A1:C1@</span>
: <span style="font-size: medium;">@sps.''fieldname''.A1:C3@</span>
'''Where:''' ''fieldname'' is the name of the '''Spreadsheet''' custom field.
[[Category:Custom Fields]]
