 Image Added
The body of the template allows you to choose which Questions you want to include. You have several options to customise the datasheet below. The first step is to pick which Key Table you want the template to use, which determines what entity the datasheet is attached to. Datasheet Type is an optional classification from Template Types. The Code field is used for Sharperlight export, while the Description should define the function of the form with added Details if needed. - Sequence determines the order that the questions are displayed. It is advisable to create gaps to allow for easy rearrangement of questions.
- Code on each line is used for Sharperlight export.
- Line Type can be one of the following:
Boolean - Yes / No Text - single line text entry Text - Multi Line - multiple lines of text entry Date and Date Time are indistinguishable on the Questionnaire presented to the User Integer - numbers only Currency and Decimal are indistinguishable on the Questionnaire presented to the User Job Picker - allows user to pick from the Jobs List Person Picker - allows user to pick from the People List (both internal and external persons) Employee Picker - allows user to pick from a list of employees only Time - time only without the date no date - Plant Item Picker - allows user to pick from a list of existing Plant Items
- Company Picker - allows user to pick from a list of existing Companies
- Toggle - works with the Selection List field to give the user buttons to select from, ideal for mobile users.
- Section - designates the line as the start of a new section where no answer is given and the Question field is the title
- Subsection - designates a subsection under a Section where no answer is given and the Question field is the title
- Question is the question text shown on the datasheet and should give the user enough context to give an answer.
- Instructions are optional text that will appear when the user hovers their mouse over the question. This is useful to provide additional guidance on what the user is meant to do.
- Selection List is used in conjunction with the Line Type field to specify a list of options for the user to select. Separate items on the list by using the , character.
- Required marks the line as required for the user to complete and prevents submitting the datasheet until it has been answered.
- Has Notes gives the user space to write notes regarding the question.
- Default Value populates the answer with the text entered here, saving the user time if the answer is usually the default.
- Weight is not currently in use.
- Formula and Value are also available for contextual display of questions. For example, if we enter Formula = "Show if (Code)", and Value = "True", the additional question would be displayed if the user answers True to a question with a Code of "10". For more details, expand below:
| Expand |
|---|
 Image Added
The image shows the Datasheet Template, the initial state of a Datasheet of this form, and then the display based on the responses detailed. Some key points from the example are: A. Sections and Subsection also support response dependency.
B. The Value conditions referring to a Boolean answer are ‘true’ and 'false'; this is case sensitive.
C. Response dependency can be over multiple levels.
D. The Value conditions referring to a Toggle answer are as per the Selection List; this is case sensitive.
E. The Value conditions referring to a Text List answer are as per the Selection List; this is case sensitive.
F. The Value conditions referring to a Picker answer is the respective primary key value.
G. The Value conditions referring to a Text answer is the expected string; this is case sensitive. Note in this case this is a Hide option.  Image Added Response dependency support is NOT available for integer, date, datetime response types; and dependency is only support for a single response value.
|
Use the Preview button to see how the datasheet will be displayed, and the Header button to navigate to the screen where you can edit what appears in the heading of the datasheet. | 
