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:
   Click here to expand...

  

  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.

  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.

• Preview shows how the datasheet will be displayed.
• Lines switches the screen back to the body or line editing screen.

• Column is a field that is no longer supported.
• Sequence changes the order that the lines are displayed
• Field is determined by the Key Table used when creating the datasheet. You can choose which field you would like to display on each line using this dropdown.
• Label is currently not in use.