Clicky

Showing 24 Result(s)

Add a table to an application

Log into the application using your username and password Open the Application drop down from the top menu and choose the application you want to work on Look towards the bottom left corner and look for a blue button with a white + sign in it. Click this button Enter a name for the new table and …

Setup a foreign key on a column

Log into the application using your username and password Open the Application drop down from the top menu and choose the application you want to work on Navigate to the table you want to work on using the tabs at the bottom of the page Click on the second tab (labeled “Table columns“) Find the …

Hide/display columns

Log into the application using your username and password Open the Application drop down from the top menu and choose the application you want to work on Navigate to the table you want to work on using the tabs at the bottom of the page Click on the second tab (labeled “Columns“) Use the checkboxes …

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

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 …

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 …

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 …

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, …

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 …

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 …

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 …

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 …

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 …

How to export data

Log into the application using your username and password Open the Application drop down from the top menu and choose the application you want to export data from Navigate to the table you want to export data from using the tabs at the bottom of the page Click on one of the export buttons