apex_generate_crud
Generate a complete CRUD interface for any database table: an Interactive Report list page and a form page with DML processes for insert, update, and delete.
Instructions
Generate full CRUD: IR list page + form page with DML processes for a table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| editable | No | Whether the form page allows editing (default True). When False, form items are rendered as display-only and Save/Delete buttons are omitted. | |
| table_name | Yes | Database table name (case-insensitive, e.g., "EMPLOYEES"). | |
| auth_scheme | No | Authorization scheme name for both pages. | |
| form_page_id | Yes | Page ID for the form (e.g., 11). | |
| list_page_id | Yes | Page ID for the Interactive Report list (e.g., 10). | |
| audit_columns | No | Custom list of audit column names to exclude from forms. If None, uses the default set (English + Portuguese names). Example: ["CREATED_ON", "UPDATED_ON", "CREATED_BY", "UPDATED_BY"] | |
| button_labels | No | Custom labels for CRUD buttons. Supported keys: - "new": Label for the New button on the list page (default "New") - "save": Label for the Save button on the form (default "Save") - "cancel": Label for the Cancel button on the form (default "Cancel") - "delete": Label for the Delete button on the form (default "Delete") - "confirm_delete": Confirmation message for delete (default "Would you like to delete this record?") | |
| form_page_name | No | Display name for form page. Defaults to "Edit {list_page_name}". | |
| include_search | No | Add search bar to the IR (default True). | |
| items_per_page | No | Number of rows per page in the IR (default 15). | |
| list_page_name | No | Display name for list page. Defaults to table_name humanized. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |