CRUD Functions in Quixy define how an application interacts with a data table. They control whether records can be created, retrieved, updated, or deleted, and under what conditions these actions should occur.
In Quixy, CRUD functions act as controlled gateways between applications and data tables. Instead of allowing unrestricted access to data, every interaction is routed through a clearly defined function—ensuring accuracy, security, and predictable behavior.
CRUD stands for:
In Quixy, these are implemented as Data Table Functions, which applications and workflows use to perform operations on table records.
Each function specifies:
CRUD functions help you:
Quixy provides the following CRUD functions for data tables:
| # | Function | Purpose | When to Use | Key Characteristics | Example |
|---|---|---|---|---|---|
| 1 | ADD (Create) | Insert a new record into a data table | Creating new records, submitting forms, capturing new data | Always creates a new row. Does not check for existing records | Submitting a New Customer form creates a new record in the table |
| 2 | GET (Read) | Retrieve existing records from a data table | Fetching data into forms, auto-filling fields, viewing details | Read-only operation. Does not modify data. Can return one or more records | Entering an Employee ID fetches employee details |
| 3 | UPDATE (Update) | Modify an existing record in a data table | Editing records, updating status or values | Requires a condition. Updates selected fields only | Approving a request updates the status to Approved |
| 4 | DELETE (Delete) | Remove records from a data table | Removing obsolete or duplicate records | Permanently deletes data. Usually, permission restricted | Admin deletes inactive user records |
| 5 | ADD or UPDATE (Update) | Add a new record or update an existing one | Synchronizing data, avoiding duplicates | Updates record if it exists. Adds a new record if it does not | If Employee ID exists, update. If not, add |
CRUD functions are typically invoked through:
Note
Applications never directly manipulate data tables—they always act through these defined functions.