Insert Definition Configuration Panel - Advanced Database Form Builder

Definition Name

Display Title

Operation Mode

Target Table

Choose the table where records will be inserted

Table Schema

Selected table fields will determine available configuration options

Key Generation & Reference Handling

Always generate unique key

Automatically create unique identifiers for new records

Auto-generate required reference records

Create missing reference records automatically during insertion

Allow new reference record creation

Enable users to create new reference records when needed

Key Field Handling

Fields Configuration

Field Name

Label

Default Value

Actions

ItemCode

Item Code

Auto-generated

Description

Item Description

-

Price

Unit Price

0.00

Drag to reorder fields • Click Edit to configure field properties

Field Configuration

Field Name

Display Label

Visibility Rule

Default Value Expression

Required field

Read-only

Data Value Options

Value Source

Auto-determined from context Static value Copy from another field Constructed expression

Static Value

Copy From Field

Expression Builder

Show list of values

Limit by Field Dependencies

Reference Record Handling

Reference Record Behavior

Use default insert definition for reference records Use custom insert definition for reference records Allow new reference record creation

Custom Reference Definition

Auto-generate required reference records

Reference Validation

Reference Record Options

Configure how reference records are handled during data insertion

Currency Settings

Enable currency field

Allow currency selection for monetary values

Default Currency

Currency Field

Exchange Rate Source

Allow currency override

Validation Rules

Validation Level

Strict - All validations enforced Moderate - Essential validations only Minimal - Basic format checks

Custom Validation Rules

Validate required fields

Check unique constraints

Validate reference record existence

Error Handling