|
Definition of Subform Display Name
| ▪ | The Subform Display Name will be seen by the User as a heading for the group of questions that sits under it |
| ▪ | If this Subform or group of questions is to appear on a different tab within the same form, the Display Name will also be the Tab name |
| ▪ | The Subform Display Name is a required field |
Definition of Database Table Name
| ▪ | The Subform name is the name used internally by Kontinuum |
| ▪ | The Subform name cannot contain spaces |
| ▪ | The Subform name is also the name of the SQL table that will hold all data collected within that Subform |
| ▪ | Each Subform must have a Form Name |
Definition of Tab Display Name
| ▪ | A Subform can appear on the same form or it can be split into Tabs |
| ▪ | The Tab Display Name appears as a Tab Header at the top of the form |
| ▪ | Enter a space if you do not wish to have a Tab Header for your Subform |
Definition of Description
| ▪ | The Display Description allows designers to give a more detailed overview of the information the Subform is collecting |
| ▪ | The Display description is an optional field when creating a new Subform |
Definition of Subform Type
| ▪ | Designers may choose to display questions in a variety of different ways, they are as follows: |
| ▪ | The Subform type will default to One when first created |
Definition of Subform Type - One
| ▪ | Selecting the Subform type One means that for every one question there is one answer |
| ▪ | The first Subform of every workflow must be of Subform type One |
| ▪ | See below an example of One to One Subform design |
Definition of Subform Type – Growing
| ▪ | Selecting the Subform type Growing means that each question is displayed at the top of a column and answers can be filled in under each header, row by row |
| ▪ | At the end of each row there is Add new Row button |
| ▪ | Once the row of questions has been completed the User can press the Add new Row button to add an additional blank line of questions |
| ▪ | See below an example of Growing Subform design |
Definition of Subform Type – Multi Row Growing
| ▪ | Selecting the Subform type Multi Row Growing means that each question is displayed as it would be in a one subform type except there can be multi rows. |
| ▪ | At the end of each row there is Add new Row button |
| ▪ | Once the row of questions has been completed the User can press the Add new Row button to add an additional blank line of questions |
Definition of Subform Type – Side Bar
| ▪ | Selecting the Subform type Side Bar means that each question is displayed at the top of a fixed number of rows are displayed |
| ▪ | Each of these rows has one or more Sidebar columns that define the information that will appear horizontally |
| ▪ | See below an example of Sidebar Subform design |
Definition of Subform Type – multi row Side Bar
| ▪ | Selecting the Subform type Multi Row Side Bar means that each question is as it would be in a one subform type except that the subform is repeated and a fixed number number of rows are displayed |
| ▪ | Each of these rows has one or more Sidebar columns that define the information that will appear horizontally |
Definition of Subform Type - Double Bar
| ▪ | Selecting the Subform type Double Bar means the Subform appears with a fixed vertical header and a fixed horizontal column |
| ▪ | All other questions are then displayed as locations in a coordinate grid |
| ▪ | See below an example of Double Bar Subform design |
Definition of Sub Form Type – Double
| ▪ | Selecting the Subform type Double means the Subform appears as two boxes side by side |
| ▪ | The User is then able to move all items from one box to the other box |
| ▪ | All items that are moved to the left box will be stored in the database |
Definition of Subform Order
| ▪ | Designers may choose to have more than one Subform in a Form |
| ▪ | The Order option allows the designer to define the order in which the Subforms appear |
| ▪ | Each Subform has a default value from 1 to 11 |
Definition of Appear Column
| ▪ | Designers may choose to display Subforms side by side from left to right |
| ▪ | The Appear column always defaults to 1 |
Definition of Tab Number
| ▪ | This option allows designers to break up the information shown to a user in a Form by displaying it in different tabs |
| ▪ | To allocate a Subform to a different tab assign a number from 1-10 |
| ▪ | More than one Subform can be assigned the same tab number |
| ▪ | If there is only one form then no tabs are shown |
Definition of Use Data from Auxiliary Form
| ▪ | This feature is used when you want to be able to display and update information from either |
| ▪ | 1) a form in the current workflow |
In this case just type in the name of the form in the workflow
| ▪ | 2) a database table which currently resides on the same SQL Server instance as the WebandFlo Database |
| ▪ | In this case the syntax for the Auxiliary Form is <database name>.dbo.<table name> |
| ▪ | 3) a remote database structure which does not reside in the same SQL Server instance as the WebandFlo Database. This could be an Oracle, Access, Excel or other ODBC compliant database. |
| ▪ | In this case the syntax for the Auxiliary Form is <name of linked server>...<table name> |
| ▪ | To create a linked server please see the Miscellaneous\Linking to External Servers help file |
*Please note that all of the column names in the subform must match the column names as defined in the external workflow
Definition of BUTTON PIXELS FROM LEFT
| ▪ | This value represents the horizontal location where the subform will appear on the form |
| ▪ | Requires the pixels from top value to be filled out in order for this value to have an effect |
Definition of BUTTON PIXELS FROM TOP
| ▪ | This value represents the vertical location where the subform will appear on the form |
| ▪ | Requires the pixels from left value to be filled out in order for this value to have an effect |
Definition of PARENT SUBFORM
| ▪ | This value allows you to treat the subform as a child subform to the parent subform. |
| ▪ | The child subform must be of type growing or multi row growing. |
| ▪ | The Parent Subform must be of type growing, multi row growing, side bar or multi row sidebar. |
Definition of PARENT COLUMN
| ▪ | This value allows you define what column or columns link the child subform with the parent subform. |
| ▪ | There must be atleast one column defined as the parent column. |
| ▪ | All the values supplied for this column by the end user must be unique.
|
|