The Database Editor application allows to create, import, export and store database sheets on your site.
You may enable the add-on, via the available option in the left menu. Depending on your current plan you can select from Lite or Premium version. The Lite version includes read only mode with options to export and import CSV files, while the Premium additionally allows inline editing.
Most applications, such as the News & Events, Media Library and Appointment Scheduler, store their data in databases within the Database Editor. This give an additional option to alter the data of your add-ons. The Form element has the capability to store data from the submitted forms in databases as well.
Exploring the Database Editor
To view all databases on your site go to the manage option, available from the left menu. The Databases interface will open, listing all available databases on your site and information for each database - description, number of rows, file size, date created and date modified.
Rollover a database to view the options to edit, delete and the duplicate, export or import options available via the dropdown under the cogwheel.
When you choose to export a database from your site, a pop-up will open and you will be prompted to download the file in csv format.
Choosing the import option will open the following pop-up, prompting uploading the desired file:
The duplicate feature could be useful if you are to manually alter a database and later replace the original one with the updated. Alternatively, you can create a new database via the Add New Database button, located at the bottom, and start from scratch.
Editing databases
You can manage your databases via the option available in the left menu. Selecting the Edit option for a certain database would load the database in a separate pop-up, where you can apply the necessary changes.
To add a new record to your database, double-click on a cell to type inside it, click on the green + New Record button at the top of the Database Editor or click on the green + sign at the bottom of the editor. Right-click on a cell allows you to cut, copy, paste or clear cell.
To add a new column, click on the icon 'Add New Column' at the top. The following column types are supported: Text, Number, Dropdown, Multichoice, Combo, Number, Password, Date, Rich Text, File, Float, ID. Column types correspond to the text fields types in a web form, configured to send to database, and to the select field, checkbox field and radio fields. When adding new column to a database connected to a web form, It is important to keep the column type consistent with the type of textfield in the form.
Right-click on the column allows you to cut, copy, paste, to move or insert, delete, clear, sort A-Z or Z-A. Right-click on the column and select 'Properties' to edit its properties and view and edit type.
Most columns can be set to unique, meaning data in its cells cannot be doubled. Mandatory columns are marked with an asterisk.
Columns of type File and Appearance set to Preview allow for images to be uploaded in the database, and their width and height is customisable. Columns of type Rich Text open an edit box for typing and inserting rich text.
To access the Database Editor's preferences (customise rows' height and fonts size), select the row header and click the Preferences gear icon, available at the top right corner of the pop-up.