Beezr Docs
Platform Documentation
Docs › App From Sheet
App from sheet

This feature allows you to use your current excel workbook as a blueprint to automatically build your application. To use this feature, follow the following steps:

Step 1: Prepare your workbook
 


















The main purpose is to define your sheets/tables and columns.
  1. Each sheet in your workbook is a module and each column is a field in Beezr.
  2. You have to remove any merged columns or title rows; this might cause issues while the engine is parsing the workbook.
  3. Formulas will not be detected; they will be defined at a later stage inside Beezr.
  4. Try to remove replicated/redundant information in the tables. For example, if you have the customer’s name replicated from the customer sheet and in the sales sheet; then remove it from the sales sheet as it will be detected automatically in a later stage.
Step 2: Upload your prepared workbook
 

 
Step 3: Choose which sheets you would like to include
 
  1. When the engine validates and analyzes the workbook, it will present all the detected sheets.
  2. You have the freedom to drop any sheet you don’t want to include in the build.
  3. You can also change the name of the sheet to be better represented in the application.

Step 4: Configure your fields
 
  1. In this step, the columns are detected from each sheet.
  2. Choose the proper field type that represents the data inside this column.
Step 5: Defines how your sheets are connected
  1. The final step is to configure how your sheets are related to each other.
  2. Simply select the sheet you want to link with and how would you like this relationship to be represented. In the example above, we are connecting the sales with customers to show the customer name.