Skip to content

Grid Form Control

👉 gridSettings takes entire IDBMasterConfig object for that grid and it's form.
👉 You can open N number of nested grid and forms.

Example

let dbMasterConfig: T.IDBMasterConfig = {
    form: {
        fields: [
            [{
                label: 'Remarks',
                control: T.EDBMasterFormControl.grid,
                path: 'remarks',
                gridSettings: {

                    jsCode: [{
                        appendTo: T.EDBMasterConfigAppendTo.beforeSaveModalOpen,
                        code: `
                            console.log('hello from beforeSaveModalOpen');
                            formData.remarkDate = new Date();
                        `,
                    }],

                    operations: {
                        add: {
                            enable: true,
                            label: 'Add Remark',
                        },
                        hideAddConfirmation: true,
                    },

                    grid: {

                        operations: {
                            delete: {
                                enable: true,
                                cssClass: 'text-danger',
                            },
                            edit: {
                                enable: true,
                                cssClass: 'text-info',
                            },

                            hideDeleteConfirmation: true,
                            hideEditConfirmation: true,

                            gridOperationsOrder: [
                                T.EDBMasterGridOperationsOrder.edit,
                                T.EDBMasterGridOperationsOrder.delete,
                            ],
                            // actionColumnWidth: '300px',
                        },

                        filter: {
                            // showGlobalSearch: true,
                            globalSearchFields: ['remarkStr'],
                            rowFilter: true,
                        },

                        pagination: {
                            showPagination: true,
                            rowsPerPage: 10,
                        },

                        sortMode: 'multiple',

                        fields: [{
                            header: 'Remark By',
                            path: 'apl_contact',
                            enableSorting: true,

                            dataSource: 'db_data',
                            dbData: {
                                // collection: 'apl_contacts',
                                pkField: '_id',
                                displayField: 'contact_email',
                            },

                        }, {
                            header: 'Date',
                            path: 'remarkDate',
                            enableSorting: true,
                            autoFormatDate: true,
                            dateTimeFormat: 'dd-MM-yyyy',
                        }, {
                            header: 'Remarks',
                            path: 'remarkStr',
                            enableSorting: true,
                        }]
                    },


                    form: {
                        fields: [
                            [{
                                label: 'Remakr by',
                                control: T.EDBMasterFormControl.dropdown,
                                path: 'apl_contact',
                                dropdownSettings: {
                                    showClear: true,

                                    dataSource: 'db_data',
                                    dbData: {
                                        // collection: 'apl_contacts',
                                        select: 'contact_email, _id'
                                    },
                                    optionLabel: 'contact_email',
                                    optionValue: '_id',

                                    filter: true,
                                    // filterBy: 'label,data',
                                    filterBy: 'contact_email',
                                    filterMatchMode: 'startsWith',
                                    // virtualScroll: false,
                                    alwaysGetLatestDataOnFormOpen: true,

                                },
                                validations: {
                                    required: true,
                                }
                            }, {
                                label: 'Remark Str',
                                control: T.EDBMasterFormControl.input,
                                path: 'remarkStr',
                                validations: {
                                    required: true,
                                }

                            }, {
                                label: 'Remark Date',
                                control: T.EDBMasterFormControl.date_picker,
                                path: 'remarkDate',
                                datePickerSettings: {
                                    showTime: false,
                                    showSeconds: false,
                                    // dateTimeFormat: 'dd-MM-yyyy',
                                }
                            }]

                        ]
                    }


                }
            }],
        ]
    }
};

Interface Documentation

/**
 * Form field configuration for UI controls.
 * Defines the appearance, behavior, and validation of individual form inputs.
 */
export interface IDBMasterConfigFormField {
    /**
     * Unique identifier for programmatic element access.
     * Useful for dynamic field manipulation.
     */
    hiddenId?: string;
    /** Display label for the form field. */
    label?: string;

    /**
     * Help text displayed below the control.
     * Supports HTML formatting for rich content.
     */
    helpText?: string;

    /**
     * Database field path where the control value is stored.
     * Supports nested paths using dot notation.
     * @example 'name', 'address.city', 'user.contact.email'
     */
    path?: string;

    /** Type of UI control to render. */
    control?: EDBMasterFormControl;

    /**
     * CSS classes for the parent div wrapping the control.
     * @default 'col-lg mt-4 col-md-{calculated based on columns.length}'
     */
    cssClassDiv?: string;

    /**
     * Auto-focus this control when form opens.
     * @default false
     */
    autofocus?: boolean;

    /**
     * Disable the control or use expression to conditionally disable.
     * When a string is provided, it's evaluated as JavaScript.
     * @example true | false | "formData.type === 'readonly'"
     */
    disabled?: boolean | string;

    /**
     * Control visibility or use expression to conditionally show/hide.
     * When a string is provided, it's evaluated as JavaScript.
     * @default true
     * @example true | false | "formData.userRole === 'admin'"
     */
    visible?: boolean | string;

    /**
     * Nested form fields for complex layouts.
     * Enables hierarchical form structures within this field.
     */
    fields?: IDBMasterConfigFormField[][];

    /** Validation rules for this field. */
    validations?: Pick<IPropertyValidation, 'required'> & {
        /**
         * Dynamic required validation function.
         * Evaluated when form data changes to determine if field is required.
         * Note: When present, this takes precedence over static 'required' property.
         * @example "formData.type === 'individual' ? true : false"
         */
        requiredFun?: string;
    };
    /** Custom validation error messages. */
    validationErrors?: {
        /** Custom error message for required field validation. */
        required?: string;
    };

    gridSettings?: Omit<IDBMasterConfig, 'schema'>;

}


/**
 * Validation rules for schema properties and form fields.
 * Define constraints that values must satisfy before being saved.
 */

export interface IPropertyValidation {
    /**
     * Field is mandatory and must have a non-null, non-empty value.
     * Applicable to all data types.
     */
    required?: boolean;
    /**
     * Minimum allowed value.
     * Applicable to: number, date
     */
    min?: number;
    /**
     * Maximum allowed value.
     * Applicable to: number, date
     */
    max?: number;
    /**
     * Minimum string/array length.
     * Applicable to: string, array
     */
    minLength?: number;
    /**
     * Maximum string/array length.
     * Applicable to: string, array
     */
    maxLength?: number;
    /**
     * Value must be unique across all records.
     * @deprecated API Maker maintains uniqueness internally.
     * Avoid using on tables with frequent updates due to performance impact.
     */
    unique?: boolean;
    /**
     * Validate email address format.
     * Applicable to: string
     */
    email?: boolean;
    /**
     * Custom validation function.
     * Return true if valid, false or error message if invalid.
     */
    validatorFun?: Function;

    /**
     * Enumeration constraint - value must be from this array.
     * @example ['active', 'inactive', 'pending']
     */
    enum?: any[];
}


export enum EDBMasterGridAppendTo {
    visible = 'visible',
    disabled = 'disabled',
}


/**
 * Available form control types for UI generation.
 * Each control type has specific settings and behavior.
 */
export enum EDBMasterFormControl {
    /** Single-line text input. */
    input = 'input',
    /** Numeric input with spinner buttons and formatting. */
    inputNumber = 'inputNumber',
    /** Text input with pattern-based masking (phone, SSN, etc.). */
    inputMask = 'inputMask',
    /** One-time password multi-character input. */
    inputOtp = 'inputOtp',
    /** Password input with visibility toggle and strength meter. */
    password = 'password',
    /** Date and/or time picker with calendar popup. */
    date_picker = 'date_picker',
    /** Multi-line text input. */
    textarea = 'textarea',
    /** Rich text WYSIWYG editor. */
    editor = 'editor',
    /** Binary checkbox (true/false). */
    checkbox = 'checkbox',
    /** Radio button group for single selection. */
    radio = 'radio',
    /** Color picker with multiple format support. */
    color_picker = 'color_picker',
    /** Dropdown select with single selection. */
    dropdown = 'dropdown',
    /** Autocomplete with type-ahead search. */
    auto_complete = 'auto_complete',
    /** Multi-select dropdown with chip display. */
    multi_select = 'multi_select',
    /** File upload with validation. */
    file_upload = 'file_upload',
    /** Nested data grid for one-to-many relationships. */
    grid = 'grid',
    /** Visual separator line. */
    divider = 'divider',
    /** Star-based rating input. */
    rating = 'rating',
    /** Circular dial for numeric input. */
    knob = 'knob',

    /** Collapsible accordion panels (field container). */
    accordion = 'accordion',
    /** Tabbed view for organizing fields (field container). */
    tab_view = 'tab_view',

    /** Clickable button with custom actions. */
    button = 'button',
    /** Image display with preview. */
    image = 'image',
    /** Custom HTML content. */
    customHTML = 'customHTML',
}

export enum EDBMasterCustomActionButtonAppendTo {
    click = 'click',
}