Creating a New Database Form Template

Modified on Tue, 10 Nov at 7:48 AM

This article outlines how to configure a database form in the IntelligenceBank platform.

For more information about databases in general, review the About Databases article here.

Note: Databases can be created by Main Admins, Database Admins, and any user with Create permission on the Databases module.

Create the Database

1Open DatabasesGo to the Databases module.
2Add a DatabaseClick the + Add button in the top right corner. The Database Settings page opens.

+ Add button in the Databases module

3Configure settingsName your database, select the Submission Type and Default Order, and set any other database settings on the page as needed.
4SaveWhen you're ready, click Save and Create Form. This takes you to the Form Builder.
Tip: If your new database is similar to an existing one, you can clone that database's form template instead of building the form from scratch.

Build Your Form

In the Form Builder, the left side lists the elements (field types) you can add to your database form. These would be the fields users see and fill out when they create records (or briefs, tasks, projects, etc.).

Available Elements

ElementUse It To
PageAdd more pages to the form.
SectionBreak a page into sections, so related fields are grouped together.
TextUsers can type in open text.
Number, Email, Currency, Website, PhoneThese field options will be validated for their specific type of value. For example, a phone number field will ensure that users provide their information in a phone number format.
SelectLet users choose from a list of pre-defined options in either a drop-down, radio button, or checklist format.
DateCapture a date within the form.
GridAdd a grid of values to the record.
UploadAttach files or URLs. See Upload Fields.
CalculationCalculate a value from other fields.
NoteShow information or instructions on the form.
LookupSelect users, groups, resources, or records from other databases. See Lookup Fields.
Sequence IDGive each record an automatic ID number. See automatic ID numbers.

Elements list in the Form Builder

Important: Once an element/field has been created, you cannot edit it to be a different type of field. This is most notable for Select field types. If a field is created as a single select dropdown field originally, you cannot change it into a multi-select dropdown, radio button, or checkbox field type.

Adding a Field

  1. Select an element from the list.
  2. Enter a field title, and fill in any settings specific to that field type.
  3. Click Save & Close. The field is added to the form, shown on the right side of the Form Builder.

Field settings in the Form Builder

Mandatory Fields

You can make many field types mandatory, so that users will not be able to save and publish a record without filling in those fields. Click the Mandatory tab within a field and select Not Mandatory, Mandatory, or Only Mandatory with Conditions (which lets you determine conditions when this particular field should be mandatory, based on other field selections in the form).

Any field marked as Mandatory will display an asterisk next to its field name in the Form Builder and on the form when users fill it out.

Any field that is Mandatory with Conditions will display an asterisk and a cross icon next to its field name in the Form Builder only. Users filling out a form will see the asterisk marking it mandatory only if the condition is satisfied.

Mandatory tab on a field

Conditional Fields

Many field types can also be made conditional, meaning they will only appear on the record form if other fields have particular values. To learn more about how to set up conditional fields, review this article here.

Conditions on a field

Form Settings

On the Form Settings tab, you can choose the Title field, which is the field shown most prominently when records are viewed, and any Secondary fields.

Form Settings tab

Reordering Fields

To change the order of your fields, click the arrows icon in the bottom right corner of the screen. A list of every field in the database will appear in a window. Click and hold a field, then drag and drop it into place. Then, select Save. The fields will then reorder in the Form Builder.

Note, you can only reorder fields within the same section. You cannot move a field into a different section than the one it was originally created in.

Arrows icon for reordering fields

Reorder fields window

You can also reorder sections by selecting the section name and dragging and dropping it in the same fashion outlined above. Doing so will move all fields within that section (as well as the section itself) to whatever position you've reordered it in.

Set Permissions

You can set permissions on the database directly from the Form Builder while you're creating it. Click Set Permissions to choose which groups have Create or Admin permission on records within this database. You can also add rules for which groups can Edit or View all or specific records.

This is also where you'll find the Restricted Edit Record Permission checkbox. When enabled, users with Edit permission can't delete records or manage permissions on them.

Set Permissions window

When you're ready, select Submit to save the configured permissions.

Submit button in Set Permissions

Note: The terms 'Database' and 'Records' are customisable, so they may appear differently in your platform. See the related terminology.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article