MobiDB Database Designer – Form Designer

MobiDB Database Designer offers a convenient visual form designer that helps users create forms (card view of an entry).  It opens automatically when you create a new database and add at least one table. You are offered to set designer grid properties, such as number of columns in the grid. This setting allows more precise location of the controls on the form and allows more optimal use of space on a screen.  

The designer can also be opened from the existing table or card by pressing the corresponding menu item in the navigation panel.

 

 

This is how designer looks on a tablet:

 

 

 

Toolbox

 Toolbox contains a list of all available fields. A user can add fields onto the form by simple drag-and-drop.  

 

Outline

 Outline contains a list of all fields added to the form. It shows field type and name of a field used in formulas.  

 

Designer form

 Designer form is a working area where all fields are added. A user can change control size and location on a form to achieve an optimal card look and feel.  

 

Designer menu

 Designer menu provides access to the following functions: save and exit, table calculable expressions, undo, redo, and more options.

This is how designer looks on a phone:

 
 

Designer form

 Designer form is a working area where all fields are added. A user can change control size and location on a form to achieve an optimal card look and feel.  
 

Designer menu

 Phone designer menu provides access to the following options: save and exit, table calculable expressions, undo, redo, and more options.
 

Description of field types and their properties

 String  
 
 

String is used to add text values to the database, for example names, products, description, services. Any text information can be added.

The following string properties are available:  

Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description. 

Enable barcode input – if checked you will be able to scan barcodes to enter values in this field.

Default value – if entered, shows the set value on the form (and in a table). This value can be changed on a form at any moment. This option can be used, for example when you have some form that should be filled in by the other person and you can add hints on how to fill it by such default values.  

 

Label

Label is used to add text information that is equal for all entries in the database. It can be used to add a caption to the card, so that you are able to see what information you are going to add or edit. You can also use it to name some group of fields: contact information, product details, etc.

The following Label properties are available:

Text – sets text of a label displayed on a form. 

Alignment – sets text alignment in the control.

Size – sets text size.

 

Float

 
Float is used to enter and display decimal numbers.
 
The following Float properties are available:
 
Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description.

Default value – if entered, shows the set value on the form (and in a table). This value can be changed on a form at any moment.  

 

Integer

 

Integer is used to enter and display integer values.

The following Integer properties are available:  

Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description. 

Default value – if entered, shows the set value on the form (and in a table). This value can be changed on a form at any moment.

 
Bool 
Bool (Boolean) is used to add checkboxes to a database. It has two states: checked and unchecked. This field can be edited from both card and table view.
 
The following Bool properties are available:
 
Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description.

Default value – if entered (checked or unchecked), shows the set value on the form (and in a table). This value can be changed on a form at any moment.  

Date

 
Date is used enter and display dates. A user is able to select some date by selecting it in the date picker.
 
The following Date properties are available:

Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description. 

Set current date as defaultif checked sets current date by default or every new entry.

Custom formatsets custom date format. It set, for example, in the following manner: dd-MM-yyyy, MM/dd/yyyy, dd.MM.yyyy, etc.  “y” – Year, “M” – Month, “d” – Day. The number of letters means the number of figures displayed.

 

Time

 
Time is used to enter and display time. A user is able to select time by selecting it in the time picker.
 
 
The following Time properties are available:
 

Caption – sets name of a field visible on a form and in the table caption. 

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description.

Show seconds – if checked time value shows seconds. 

Set current time by default – if checked sets current time for every new entry.

 

Hyperlink

  

Hyperlink is used to enter and display hyperlinks. The hyperlinks shown on the form is active. By tapping on it users gets to the web browser that opens the specified web page.

The following hyperlink properties are available:

Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description. 

Enable barcode input - if checked you will be able scan barcodes to enter values in this field.

Default value – if entered, shows the set value on the form (and in a table). This value can be changed on a form at any moment.

 

Email

  

Email is used to enter and display emails. Email shown on a form is active. By tapping on it a user gets to an email client and is able to send a message to the selected recipient.

The following Email properties are available:

Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description. 

Enable barcode input - if checked you will be able scan barcodes to enter values in this field.

Default value – if entered, shows the set value on the form (and in a table). This value can be changed on a form at any moment.  

 

Phone

 

Phone is used to enter and display phone numbers. Upon pressing the corresponding icon in a card a user is able to dial the number via one of the dialer apps.

 The following Phone properties are available:
 
Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description. 

Use strict validation – if checked, allows entering phone number in 10-digit format.

Enable barcode input - if checked you will be able scan barcodes to enter values in this field. 

Default value – if entered, shows the set value on the form (and in a table). This value can be changed on a form at any moment.

 

Picture

  

Picture is used to add and display images in a card. Picture can be selected from the gallery or cloud storage , or taken by the device camera . It’s also possible to delete the image from the card ()or save it outside of the app for further use ().

The following Picture properties are available:  

Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description.  

Rating

  

Rating provides an intuitive rating experience that allows users to select the number of stars that represents their rating.

The following Rating properties are available:  

Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description.

Maximum value – sets maximum possible rating value.

Step – sets step for increment or decrement of rating. The default step is 1.

Default value – if entered, shows the set value on the form (and in a table). This value can be changed on a form at any moment.

 

Address

  

Address is used to enter and display physical address information.

The following Address properties are available:  

Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description. 

Show country – if checked information about country is visible and can be added or edited.

Show region – if checked information about region is visible and can be added or edited. 

Show city – if checked information about city is visible and can be added or edited.

Show postal code - if checked information about postal code is visible and can be added or edited. 

Show address line 1 – if checked address line 1 is visible and can be added or edited.

Show address line 2 – if checked address line 2 is visible and can be added or edited.

Set current country as default – sets country selected in the Language and Input setting of a device.  

 

Currency

 
Currency is used to enter and display money units.
 
The following Currency properties are available:
 
Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description.

Currency sign – sets sign to denote the currency.

Currency sign place – sets if the currency sign should be placed before or after the numeric value.

Default value – if entered, shows the set value on the form (and in a table). This value can be changed on a form at any moment.  

 

Table reference

 

Table reference is used to add relation to the other table in the database. It is used when you need to show some data from the other table in the designed card. It’s also used to avoid duplicate entries and saves time on filling in a card. A user is able to proceed to the related table entry by tapping the corresponding icon in a card, edit some information and get back to the table he was working with.
 
The following Table Reference properties are available:

Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description.

Table – allows selecting a table to refer to from the list of all tables in the database.

Column – allows selecting a column to refer to from a list of all columns of the table selected on a previous step. 

Sort values – if checked indicates if the entries should be sorted.

 

Calculable

 
Calculable is used display data that is a result of some expression calculation. More information on available functions and fields that can be used in formulas is available here: http://helpcenter.perpetuumsoft.com/kb/a601/the-list-of-available-functions.aspx
 
The following Calculable properties are available:

Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description. Expression – sets formula that needs to be calculated to display the value in this field. 

Format – sets format of the calculated value. If a user selects some value different from “None” additional options become available. It’s offered to select Number or Percentage Format and Decimal numbers.

Prefix – will add some data before the calculated value (for example currency sign). 

Postfix – will add some data after the calculated value (for example currency sign).

Presentation – sets type of the calculated value. The default value type is Text.

 

Location

 

Location is used to enter and display coordinates of a place. Coordinates can be entered manually in the following format: 53.389175;83.745387, or you can get your current coordinates with GPS and add them to a card . Users are also able to view the place specified by the entered coordinates on the map  .

The following Location properties are available:

Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description.  

 

Nested table

  

Nested table is used to insert a child table into the card. This is very convenient for storing additional data that is related to a definite entry but adding it to the card would overload it and make unreadable.

The following Nested table properties are available:

Caption – sets name of a field visible on a form and in the table caption.

Name used in formulas – sets name of a field that is used to refer to this field in formulas. We recommend giving meaningful and informative names. It will help you select the needed field name when writing formulas. For example, if your field is used to display product description, set name for formulas as product_description. 

Show as link – if checked a nested table will be represented by a hyperlink.

Columns settings – provides access to the list of columns where a user can manage columns visibility and order.  

Nested table layout and columns are created and managed in the same manner as the parent table. Users can access nested table designer in two ways: by tapping the icon in the designer.

 

Related fields

These are the common field types. Below the list of these fields you will see a list of all fields from the related tables referred by field caption. You can simply drag and drop any such field to the form. A calculable control with the pre-set expression will be added. The expression has the following look:  client.email, where client is a name for use in formulas of the Table relation control that makes reference to the selected table and email is name of the column (field) in this table.  Such fields have all properties of a Calculable field.

Confirm all changes by tapping the icon and proceed to adding entries.

 

Add Feedback