In Smartabase, data can be collected in a number of different forms, including event, profile, database and related entity forms.
Forms consist of sections, which in turn contain fields to collect and display information.
All form types have similar creation processes and form components. There are three ways to create a form:
- Start with a blank template.
- Use one of the existing templates.
- Import a form into Smartabase.
When building a form, it is also important to understand how to test the form and how to interpret and resolve any warning messages.
Steps to build a blank form
- Select the relevant tool from the builder interface, depending on which type of form you want to create.
- From the Options drop-down menu, choose the option to create a new form.
- Enter the following details:
- Form name (required)
- Category (optional)
- Tags (optional)
- Describe the purpose of the form (optional).
- Add a description for the form (optional).
- Leave Start with set to Start with blank form.
- Click the Build button. This will load the new blank form.
- Add any of the following from within the form:
- Instructions
- Categories
- Tags
- Sections
- Questions
- Click Save to save the new form.
A form must contain at least one field in order to be saved.
Steps to import a form
You can use this method if you have already exported a form from a Smartabase site.
- Select the relevant tool from the builder interface.
- From the Options drop-down menu, choose the option to create a new form.
- The form name, category, tag field and description fields can be left blank because they will be inherited from the imported file. If you fill them out now, they will override the imported values.
- Set Start with to Import form from another application.
- Click on Choose file and Upload your text file to Smartabase.
- In the form builder, check that the contents of the form are correct.
- Click Save to save the imported form.
Testing your form
Before you start collecting data in your form, you should first test that all of the fields work as expected. You can use the preview mode in the form builder while you are creating the form, but some features are unavailable in the preview (e.g. history calculations, linked calculations, performance standards) so it is best practice to test the form in the main interface.
Some sites may have settings enabled which will automatically provide you with access to the forms on the main interface. If this is not the case, an administrator will need to assign data permissions to your role to allow you to test the form. Remember that you'll need to have data permissions to any associated forms (e.g. databases, embedded forms, linked forms) as well as the form you've just built.
Understanding warning messages
When building a form, you may see a list of warning messages at the bottom of the page. There are different types of warning messages, and you should consider taking steps to resolve them before saving your form. We have included a list of the warning messages with information on what they mean and how to resolve them below. The first table includes critical errors that will prevent the field from working, and the second table includes non-critical errors which we recommend resolving.
Critical errors
Error message | Details | Resolution | Applicable fields |
You must add at least one question to save. | This message is displayed when there are no fields in a form. | To resolve this error, add at least one field to your form. | N/A |
Should have at least one option. | This message is displayed when you have not set up any options for an option field. | To resolve this error, add at least one option using the field’s Options properties. | True / false, Yes / no, Tick, Dropdown, Multiple selection, Single selection, Search list and Slider fields. |
You must select a database. | This message is displayed when you have not selected a database form for a Database field to reference. | To resolve this error, select a Database using the field’s Advanced properties. You must have a database form available to be able to select a database. | Database fields. |
The database you have selected () does not exist. | This message is displayed when you have attempted to select a database form for a Database field to reference, but have not completed the process. | To resolve this error, select a Database in the field’s Advanced properties. You must have a database form available to be able to select a database. | Database fields. |
You must select a related entity. | This message is displayed when you have not selected a related entity form for a Related entity field to reference. | To resolve this error, select a Related entity in the field’s Advanced properties. You must have a related entity form available to be able to select a related entity. | Related entity fields. |
The related entity you have selected () does not exist. | This message is displayed when you have attempted to select a related entity form for a Related entity field to reference, but have not completed the process. | To resolve this error, select a Related entity in the field’s Advanced properties. You must have a related entity form available to be able to select a related entity. | Related entity fields. |
The equation is empty. | This message is displayed when you have not entered an equation using the equation editor in the Calculation properties for a calculation field. | To resolve this error, enter an equation in the field’s Calculation properties. | Calculation, Duration calculation, History text calculation, History calculation, Historical date calculation, Table calculation, Table text calculation, Table option calculation, Table date calculation, Table duration calculation, Option calculation and Text calculation fields. |
_eq_X is not a known variable | This message is displayed when an incorrect field name is entered into the equation for a calculation. | To resolve this error, inspect all field names in the equation and ensure they correctly match the field names in the form. | Calculation, Duration calculation, History text calculation, History calculation, Historical date calculation, Table calculation, Table text calculation, Table option calculation, Table date calculation, Table duration calculation, Option calculation and Text calculation fields. |
There is one field selected that does not have their linked items setup correctly. | This message is displayed when you have not selected a Form and Field to link data from for a linked calculation field. | To resolve this error, select a Form and Field in the field’s Calculation properties. | Linked value, Linked text, Linked option, Linked data and Linked time fields. |
No form selected. | This message is displayed when you have not selected a Form to link data from for linked calculation fields. This warning is essentially a duplicate of the above warning. | To resolve this error, select a Form in the field’s Calculation properties. | Linked value, Linked text, Linked option, Profile linked value, Profile linked text, Profile linked option, Linked data, Linked time and Profile linked date fields. |
No field selected. | This message is displayed when you have not selected a Field to draw the date from for a Date calculation or Time calculation field. | To resolve this error, select a Field in the field’s Calculation properties. | Date calculation and Time calculation fields. |
Should have at least one form item selected. | This message is displayed when you have not selected any fields to be included in an Average, Sum, Minimum or Maximum field. | To resolve this error, tick at least one field using the field’s Calculation properties. | Average, Sum, Minimum and Maximum fields. |
The date from must be selected. | This message is displayed when you have not selected the start date for a Date difference calculation, Time difference calculation or Date duration field. | To resolve this error, select a From date in the field’s Advanced properties. | Date difference calculation, Time difference calculation and Date duration fields. |
The date to must be selected. | This message is displayed when you have not selected the end date for a Date difference calculation or Time difference calculation field. | To resolve this error, select a To date in the field’s Advanced properties. | Date difference calculation and Time difference calculation fields. |
The display units must be selected. | This message is displayed when you have not selected units for a Date difference calculation, Time difference calculation or Date duration field to be displayed in. | To resolve this error, select the Display units (days, months, years) in the field’s Advanced properties. | Date difference calculation, Time difference calculation and Date duration fields. |
You must select the display units. | This message is displayed when you have not selected units for an Age calculation field to be displayed in. | To resolve this error, select the Display units (days, months, years) in the field’s Advanced properties. | Age calculation fields. |
Non-critical errors
Error message | Details | Resolution | Applicable fields |
The following field can't display more than two options. | This message lists any Tick fields that have more than two options. | To resolve this error, make sure only two options are entered using the field’s Options properties. | Tick fields. |
There is one field selected that is categorical but does not have any options. | This message is displayed when you have not set up any options for an option calculation field. | To resolve this error, add at least one option using the field’s Options properties. | Table option calculation, Option calculation, Linked option and Profile linked option fields. |
There is one field selected that have 16 or more options. When viewing in tables these will not display well, so you are recommended to change this to either a database or a search list for usability purposes. | This message is displayed when you have entered 16 or more options for a Dropdown or Single selection field. | To resolve this error, make sure less than 16 options are entered in the field’s Options properties, or consider changing the field type to a Database or a Search list. | Dropdown and Single selection fields. |
There are x fields selected to show in tables by default. You may want to reduce this number for usability purposes. | This message is displayed when there are nine or more fields set to show in tables by default. | To resolve this error, only set Default show in tables? to True in eight or less fields' Advanced properties. There is no significant impact to the integrity of the form if this message is ignored, however, people viewing the form in the Reports or Performance history tools will need to scroll to be able to see all fields. |
All fields |
There is one field selected that may not be abbreviated to show in tables. You may want to abbreviate for usability purposes. | This message is displayed when a field is set to show in tables by default, the field name is longer than 16 characters, and an Abbreviation has not been set. | To resolve this error, either set Default show in tables to False in the field’s Advanced properties, add an Abbreviation in the field’s Advanced properties, or change the name of the field so that it is 16 characters or less. There is no significant impact to the integrity of the form if this message is ignored, however, the field name may not be completely visible when using the Reports and Performance history tools, depending on the Report column width set in the field’s Advanced properties. |
All fields. |
The following field may require a number format set. | This message lists any number fields that don’t have a Format (number of decimal places) set. | To resolve this error, set a Format in the field’s Advanced properties. | Number, Positive number, Calculation, Duration calculation, History calculation, Table calculation, Table duration calculation, Linked value, Profile linked value, Average, Sum, Minimum and Maximum fields. |
The following field may not be capitalized correctly. | This message lists any fields that don’t have names beginning with a capital letter. | To resolve this error, make sure to capitalize your field name correctly. There is no significant impact to the integrity of the form if this message is ignored. |
All fields. |
In addition to the warning messages displayed at the bottom of a form, you may see a warning message appear in as a system notification at the bottom-right of your page. For example, you’ll see a warning message in this format if you have two fields with the same name. The following error message will display: Each form item has to be a unique name. To resolve this error, make sure all fields in your form have different names.