At times, we need to keep track of information and a good choice for this is using a MobiDB database designer application. Whether it is a list of students or members of a team, a collection of your books and discs, or simply the database to store your personal contacts, a MobiDB makes it easy to enter, store, and find specific information. The following Getting Started guide is meant to describe the basic steps a user should take in order to get acquainted with the application capabilities.
Step 1. Creating a database
To create a database tap on the Add icon in the bottom right corner of the databases window and select Create new database option.
In database selection window tap on the Blank database icon to create an empty database.
Set your Database name and click OK.
The new empty database will be created under the default application path. If you would like to create a database under a custom file system path, you can use More options button and select a custom path to save your database to.
Step 2. Creating a table
To create a database table, tap on the Add icon in the upper right corner of the Database1 window.
Enter table name and press OK to confirm.
What you see next is the database designer window that is used for creating or modifying a layout of your data table.
The database designer consists of the Toolbox panel to select the required fields and the working area grid to the right of the Toolbox, where the selected controls will be allocated. The fields can be added to the working area grid by simple drag-and-drop action. Next to Toolbox you can find an Outline tab that represents a descriptive view of controls placed onto the working form.
Step 3. Creating a card layout
Let’s assume we are creating a database that will contain product name, quantity and image fields. Thus, the fields we select for use in our sample would be as follows:
String (product name), Integer (quantity), Picture (product image).
After adding the controls to the form we can modify their properties. To do this, select the control in the working area grid by tapping it, and then use an Edit element properties button below the selected table element to open the Edit control properties window.
Press Save icon in the upper right corner. All your changes will be saved and you will see the Card view window that is used for filling in your table with data.
The figures above display the process of creating a card layout by using a tablet designer.
Creating a card layout using a designer optimized for phones is slightly different, but the idea remains the same.
After the table is created, a user should tap the sign to see the Toolbox.
Tapping the control will add it to the form.
Step 4. Adding data
After finishing filling in the first card, you can add a new record by simply tapping on the Add record icon in the upper right corner of the Card view window. All data added to the table is saved on the fly, that's why there's no need to save the changes during data input phase.
Switching between the Card view and the Table view is done with the help of Switch button. Simply tap the Switch icon in the upper right corner to switch to Table view layout, or tap icon to return to Card view.
Note: You can increase or decrease the width of any of your fields by tapping the column border in a Table view layout and move it left or right while holding it pressed.
Step 5. Filtering and sorting data
It is possible to filter the table data and sort the output data order. To do this, switch to Table view layout and press the menu icon in a column header.
In opened menu you can set sorting order. The available values include None, Ascending and Descending data output order. Clear sorting will reset sorting. Advanced sorting offers setting up sorting by multiple columns.
Setting the filter option is performed by selecting a query criterion. If a table value matches the pattern you enter, it appears in the query results. It is possible to set only one query criterion for each individual column at a time. None is the value used by default.
Step 6. Application Menu settings
The Application Menu is composed of a drop-down button control that displays a menu containing commands that expose additional functionality. The available options depend on the view layout the menu was called from.
For example, if the menu was invoked from the Database view layout the available options will be different from options displayed in Tables Collection view or Table/Card view.
Below, you can find more detailed description of all commands in alphabetical order.
Duplicate record - duplicates the selected record.
Edit table view settings - allows changing the order of the table columns and their visibility. To change the column order you will need to tap on the 'four-way arrow' sign and move the column up or down while holding it pressed.
Export - offers the ability to export a table to PDF or CSV.
Print - offers the ability to print a table.
Share - allows saving your database to a DropBox folder.
Reset all filters - resets the set filters in the table.
Import CSV - imports data to a separate table from a CSV file.
Create shortcut - allows to create a shortcut on your home screen tapping on which you will get directly to the certain table.
Step 7. Using table references
Table references make it much easier and more intuitive to work with table data. Table reference is represented by a control with drop-down list of values. Each value corresponds to the value of a referred column.
To add a table reference, place Table reference control to a designer form and configure its settings. Select the name of the referred table from the list of available tables and specify the column name you would like to refer to.
Table reference can also work as a link that provides access to corresponding data of the fields in the referred table. To get the data from any of these fields it is necessary to add a Calculable control to a form and specify its expression as tablename.referencename.fieldname.
Step 8. Field data types
Below, you can find more detailed description of available field data types in alphabetical order.
Text - used to add text values to the database, for example names, products, description, services. Any text information can be added.
Label - 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.
Float - used to enter and display decimal numbers.
Integer - used to enter and display integer values.
Bool - 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.
Date - used enter and display dates. A user is able to select some date by selecting it in the date picker.
Time - used to enter and display time. A user is able to select time by selecting it in the time picker.
Hyperlink - 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.
Email - 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.
Phone - used to enter and display phone numbers. Upon pressing the icon in a card a user is able to dial the number via one of the dialer apps.
Picture - 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.
Attached file - used to attach a file to the database entry. The attached file is stored in the database, can be opened for viewing and saved outside the database for further use. Please note that editing of the attached filed from the app is not available.
Rating - provides an intuitive rating experience that allows users to select the number of stars that represents their rating.
Address - used to enter and display physical address information.
Currency - used to enter and display money units.
Table reference - 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 icon in a card, edit some information and get back to the table he was working with.
Calculable - 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 in the corresponding KB article: List of available functions.
Location - 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.
Nested table - 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.
Dropdown list - used to select an item from a predefined list. No multi-selection mode is currently supported.