SchoolWorkSpace

Help : Form Templates

Form Templates

Form templates allow you to define the structure of a standard form so you can easily send forms.

e.g. Create a Template for a trip, then for each trip just customise the items that change i.e. date and location.

Some Templates are inherited from your MAT/LA or SchoolWorkSpace, these can be customised, or just used as defined.

Templates can also be exported as a file and imported so you can save as a backup or share them.

Archived Templates

Old Templates can be archived, Archived Templates can be restored or deleted.

Template Scripting

A Basic script language can be used when processing a template to build a form.

Each command is on a separate line in the template scripting advanced option of a form entry.

  • repeat the start of a repeatable section

  • until {expression} - return to the form item with 'repeat' if the test is not true

  • add({variable},2) - add 2 to a variable

  • adddate({variable},7) - add 7 days to a date variable

  • adddate({variable},1,week|month|year) - add a timespan to a date variable

  • let {variable}={value} set a variable to a value - special variable values are:

  • let ColumnName={value} set the current item columnname

  • let DefaultValue={value} set the current item default value

  • let Subscript={value} set the current item subscript value

  • let Text={value} set the current item text value

  • if {expression} evaluate an expression true or false

  • then {} if the previous if was true then execute the {} statement

  • else {} if the previous if was false then execute the {} statement

{value} use [[variable]] for replacing values

{expression} is {value}>|<|>=|<=|={value}

example1

Template control - weeks dropdown number of weeks 1-5

Template control - startdate input type Date

Form control - Section [[startdate]]

let week=1

repeat

Form control - Monday

let ColumnName=Mon[[week]]

Form control - last item in the section

adddate(startdate,7)

add(week,1)

until [[week]]>[[weeks]]