No-code builder introduction
How to add custom fields, views and forms — without writing code.
Avenit’s no-code builder lets you extend any system entity with custom fields, views, forms and automations — without writing code and without waiting for a developer.
The key difference: real columns
Unlike most no-code platforms, Avenit does not use JSONB to store user fields. When you add a customer_number field to contractors:
- We validate the name (uniqueness, no conflicts with the system).
- We check
pg_catalogto make sure the column doesn’t already exist. - We execute
ALTER TABLE core_contractors_ext ADD COLUMN customer_number text. - We save the meta-definition for the UI and API.
Result: your fields are real PostgreSQL columns — fast, indexable, with constraints and foreign keys.
The BASE + EXT architecture
Every system entity (e.g. contractor) has two tables:
core_contractors -- columns that we, Avenit, add
core_contractors_ext -- columns that you add via the no-code builderA query for the full contractor is an INNER JOIN — added automatically by the ORM. In practice <1ms of overhead.
Field types
Available out of the box:
| Type | Storage | Index | Notes |
|---|---|---|---|
| Short text | varchar(n) | B-tree | 255 chars max |
| Long text | text | GIN (full-text) | Unlimited |
| Integer | integer or bigint | B-tree | Optional range |
| Decimal | numeric(p,s) | B-tree | Financial precision |
| Date | date | B-tree | — |
| Datetime | timestamptz | B-tree | Always UTC |
| Boolean | boolean | none | Yes/No |
| Enum | varchar + CHECK | B-tree | Value list |
| Multi-select | text[] | GIN | Array |
| Entity link | uuid + FK | B-tree | 1:N relation |
| File | uuid + FK to storage | B-tree | S3 integration |
How to add a field
Step 1. Go to the entity you want to extend (e.g. Contractors → ⋯ → Configure fields).
Step 2. Click “Add field”. Pick a type, provide a technical name (snake_case) and a label (visible in the UI).
Step 3. Optionally: set NOT NULL, default value, CHECK (validation).
Step 4. Save. The field is immediately available in all views, forms, and the API.
What’s next
- View builder — lists, Kanban, calendars, dashboards.
- Form builder — drag-and-drop, validations, dependent fields.
- Automations — IF-THEN without code.