Introduction

ZenBase is a light-weight online data management and application builder for non-coders such as sales staff, customer service reps, accountants etc, and technical people alike. It provides the tools for users to create powerful online applications quickly through its simple user interface.

Create Application

Applications

ZenBase can be used to either manage existing applications or to create and manage new applications. If you logged in for the first time, you will be able to create your first ZenBase database application in the dashboard.

To create a new application, navigate to the application section (click “Applications” from the top menu and then click “Create Application“). You will now see all applications in your account (or none if there aren’t any applications created yet).

Alternatively, click “Create Application” in the dashboard to start.

You can select from one of the many existing templates to jump-start creating your new application:

or create one from scratch.

Note that application name should not allow space or any special characters such as @,# \ etc.

Add Table

To create a new table, click “Add Table” button, or the button with the white “+” in front of your table tabs at the bottom of the window (in the bottom left corner). If you’re not seeing this button, this means you don’t have permission to create new tables and you should contact the application’s administrator.

 

Create table by importing

Data are the backbone of your application. They hold all of your data and are the starting point of your application. The first step in creating a database-driven web application is to hook data. Data are represented in the table in rows and columns. Each row is called a ‘record’. Data can be submitted to them through web forms or imported from external files. Data can also be exported.

At the moment of this writing, ZenBase supports importing of comma-separated values (CSV) files only. If you have Excel sheets you’d like to import into ZenBase, you should export these as CSV files from Excel first after which you can import the data into ZenBase.

Note that table name should not contain space or any special characters.

After clicking the button, you should start off by entering a name for your new table. Note that the name should only contain only alphanumeric characters: a-z, 1-9, underscored and dashes, NO SPACES.

Next, you should choose the file you’d like to import. When importing a CSV file, it’s possible that your file contains the column names on the first line of the file, if this is the case, make sure you tick the checkbox labeled “First row contains column names“, this way ZenBase will use those column names to create your new table.

Primary key

ZenBase requires all tables to have a primary key set, it will add a primary key column to your imported data as well. It will first detect whether the first column contains unique values, if it does, ZenBase will set this column as the primary key.

If the first column does not contain unique values, ZenBase will add an additional column to your table which will function as the primary key (which will be set to auto increment).

Importing data into an existing table

The second way to use the data import function is by importing data into an existing table. To do this, bring up the table into which you’d like to import data. Next, click the grey button labeled “Import data” which will bring up a popup. In this popup, you can choose your CSV file and upload it.

PLEASE NOTE:
When importing data into an existing table, it’s critical to make sure the structure of your CSV files matches with the structure of your table! If you have 10 columns in your table, you’ll need to have 10 values per row in your CSV file. If the structures don’t match, the import will probably fail and ZenBase will show you an error message.

Columns

A column is similar to a database table column in which a set of data values of a particular type, one for each row of the table. Users can add a new column or edit existing ones.

In the modal window, users can set column properties including column name, column type, default value, index, and position.

At the time of this writing, ZenBase supports the following column types:

  • Numbers (up to 11 digits)
  • Decimals
  • Small text (up to 255 characters)
  • Large text
  • Date
  • Selection
  • Binary (file or image)

Roles, Users and Permissions

ZenBase is built with user roles in mind. This means that you define a certain role (for example Sales Rep, Customer Service or Accounting) and setup permissions for this Role. Next, you assign a Role to a user account which will determine what the user can or cannot do.

For each Role, permissions are set on an application level AND on a table level; meaning different applications and different tables can have different permissions.

When a new user account is created, ZenBase will automatically send a notification email to the user’s email address with the login details.

Users and Roles can be managed by users belonging to the Administration group or users who have been assigned the permission to manage Users and Roles by an Administrator.

ZenBase comes with built-in password recovery as well. If you or another user forgot his or her password, simply click the “Forgot your password?” link on the login page. This will send out an email with a link to the password reset page on which a new password can be created.

Administrator (AKA Super User)

The user who signed up for the ZenBase account automatically has the “Account Administrator” role. This role cannot be modified or deleted to make sure admins can always access the application. The Admin User can create new role and users for the same account. One account is limited only to one administrator.

Revisions

ZenBase automatically stores old values of records and individual cells which can be restored at any given moment. When a cell or record is updated, the previous values are stored and can be accessed through the “Revisions” tab.

Both the Cell and Record popups have the Revisions tab, allowing to restore single cells or entire records.

There is no expiration date set for Revisions, meaning all revisions are stored indefinitely. You can, however, remove Revisions manually for any Cell or Record.

Relational Data

ZenBase allows for a column in a certain table to be connected to a second table, which means that the first column will hold the value from the second table.

Foreign keys will have to be declared within the application before ZenBase will be able to use them.

To set up a foreign key on a column, you will need to have permissions to modify tables in the database based on Role. An administrator can manage the user roles in the Roles page.

Once declared properly, ZenBase will automatically present a drop-down box displaying the allowed options when editing a single Cell or Record.

Notes

ZenBase allows users to attach notes to Columns, Tables, and Applications. These notes can serve to describe what certain items are for and how certain items should be used.

When looking at a table screen, you’ll find a tab named “Notes“. In here, notes for the current table can be created, edited or deleted.

When editing a column or Cell, notes can be attached to the Column through the “Notes” tab in the popup.

When editing a Record, notes can be created, edited and deleted through the “Notes” tab.

PLEASE NOTE:
ANY user can create notes, no matter what permission this user has. Administrators can edit and delete other users notes as well as their own.

Table List

The available Tables are displayed through tabs at the bottom of the screen when working on an application.

Application Database Schema

ZenBase has an easy-to-use and navigates application database schema viewer. Click on any of the schema navigation icons to navigate. You can also navigate using the keyboard.

Click a table in the schema diagram to go to its content.