Skip to main content

Using Builder Studio

Following sections help you to understand & use Builder Studio. Follow these steps for a successful app build.

Connect - Import​

  1. Connect to Db Sources and import Tables/Views (via metadata information).

  • Databases supported are MySQL, PostgreSQL, Oracle, MS SQL Server.

    • On request: We will enable other db sources in studio. Runtime supports more dbs for generated projects.

    • For runtime, Databases supported are MySQL, MariaDB, PostgreSQL, Oracle, MS SQL Server, Azure SQL, Snowflake, (DB2, H2, HSQLDB).

    • Compatible Databases: Below Postgres or other compatible databases should be able to be used for Import and runtime deployment: Aiven PostgreSQL, Google AlloyDB Postgres, AWS RDS | AWS Aurora - MySQL and PostgreSQL, Azure Cosmos DB for PostgreSQL, Azure Postgres database, Crunchy Postgres, DigitalOcean Postgres, ElephantSQL Postgres, EnterpriseDB (BigAnimal) Postgres, GCP Cloud SQL database - MySQL PostgreSQL and SQL Server, Heroku Postgres Database, Neon Postgres, Railway Postgres, Render Postgres, Supabase Postgres, Timescale Postgres, Yugabyte Postgres, Citus Postgres Distributred Db, CockroachDB.

  1. Import from multiple Db Sources / multiple Db types.

Manage Tables​

Manage Tables With DATA Table Explorer

  1. View imported tables and their details.
  2. Create/Define New Tables in EM Studio via No-Code methodology.
  3. View all details on Tables, Fields via Metadata menu section on left side.

If Required:

  1. Verify/Validate/Amend table details like Key Columm (1st Column), make amendments.
  2. Table field level Verify/Validate/Amend - Hide fields, data types, set properties, Label text.

Project - Configure​

info

Note: Project Configuration are applicable to all build selection methods.

Project Settings (Defaults)​

View/Update below Project Settings Before Generate Code. Default values are given below.

  • Exclude FILE|STREAM field types: ❎
  • Date Format : yyyy-MM-dd (2021-12-31)
  • Time Format : HH:mm (14:35)
  • Locale: en_US
  • Configure Tables - Enable ? : ❎
  • Table Relations - Enable ? : ❎

Configure Tables & Fields​

Configure Tables & Fields Via DATA Table Explorer : Use Table Level Rt side menu links for below.

  • Configure Table BuilderProp Via Table Form
    • See details below.
  • Table Relations|Joins
    • See details below.
  • Key Column
    • Verify/Set Key Column. 1st column is key column. Move position if req.
  • Fields
    • Edit/Add Fields after import
  • Field Prop - Hide
    • Hide fields from code generation

Configure Table BuilderProp Via Table Form​

Global Default Form Properties - BuilderProp​

View/Set Global Default Form Properties - BuilderProp. Default values are given below.

info

Global Properties override Table Level properties.

Builder Properties (Configure Tables)

  • Skip FE Frontend ? : ❎
    • Skip Code Generation for Frontend
  • Skip BE Backend ? : ❎
    • Skip Code Generation for Backend
  • Do NOT Skip BE - EM Lib Based ? : ❎
    • Do NOT Skip Code Generation for Backend BE - EM Lib Based, Can be set for Global Level or For Table Level Table Object, WPJ Level not available.
info

Below are Coming Soon! Values are captured but not implemented.

  • (Coming Soon!) Skip Code For 1) Tech or 2) Table/Screen Parts ? : Multiple Settings Chart
    • Skip Code Generation for 1) Selected Tech or 2) Checked Table/Screen Parts in Both Frontend & Backend
  • (Coming Soon!) Custom Label:

Configure Relations | Joins​

Configure Tables Relations | Joins Via DATA Table Explorer : Use Table Level Rt side menu link Table Relations|Joins

  • First Setup Table Joins between 2 tables with relationship like: 1x1, 1xM, MxM.
  • Then Setup Table Relations (Multi-Table Relation) by creating it from table join starting point.
caution

Please check out Table Relation and Joining Tips and FAQs

Follow them to avoid compile errors in generated code.

Build - Selections​

View currently Selected Tables via Menu option [Build - Selection]. Shows Session bookmarks and All bookmarks.

Selection Types (Ways):

  1. Select tables for build project (generate code) via -

    A. Studio Menu - Bookmarks.

    B. Or Use Generate For All Tables menu option.

Studio Menu - Bookmarks - How To ?

  1. Click Bookmark for table or folder level (Icon Link is at the end of list item).
  2. You can Use Session bookmarks or All bookmarks (cumulative) features while generating project code.
  3. Clear previous bookmarks via Studio header section menu links [ClearSend: Sess All]

Project - Explorer​

Following features are planned and coming soon in builder. Please accomplish them via low-code customize post generating code. Or Hire Our No-code developer to get these done for you.

Configure Common Features and Plug-ins:

  1. Enable Security For Frontend - To Backend Calling
  2. Enable Security For Frontend App - Sign-Up, Login, User/Role based Auth - Screen/Widget Data Access

Configure Screen/Widget Flow

  1. Select Ordering Of Tables Sequence
  2. Select SideNav Entries
  3. Customize Table Names For SideNav, Forms or Display Screens

Build - Project (Generate Code)​

  1. Build - Project - Generate Code via - Generate Menu options

    A. Generate For All Tables [Generate Apps APIs]

    B. Generate For BookMarks [For Session BookMarks] | [For All BookMarks]

    • Choose options

      • Exclude FILE|STREAM field types : [ ]
      • Date Format:
      • Time Format:
      • Locale:

    • Submit to Generate Code

  2. Details on Generated Project - Build Generate Number e.g. (WS_10005) and all Files generated is listed.

  3. Download Generated Project zip - From [List Builds] menu, for given number e.g. (WS_10005).

List Builds​

  1. View List of previous project builds via Generarted Folders menu.
  2. Download Build (Project Bundle zip).
  3. Options available to view builds - expanded folder contents.
  4. Separate menu options available to Delete builds.

Run Build​

Following features coming soon for users! Hire Our No-code developer to get these done for you.

  1. Online Run Build - Run App with Live Data available for high end Plans.

How to Run Build ? On-premise on Your Computer - DIY Steps:

  1. Download Build (Project Bundle zip). And On-premise Compile, Deploy, Run.
  2. Extract zip. Navigate to projects for Flutter App or APIs spring. Open project in IDE and Compile/Run.