Managing Your Data

Add, edit, and delete records directly in the Sticklight interface. No SQL knowledge required.

Who can do this: Owners, Admins, and Editors can add and edit records. See Roles and Permissions for details.

Adding Records

1. Open the Data Dashboard
2. Select your table
3. Click New item
4. Fill in the form fields
5. Click Save

The form automatically shows fields based on your table structure.

Editing Records

1. Find the record in the data table
2. Click on the record to open it
3. Modify the fields as needed
4. Click Save

Changes are applied immediately to the database.

Deleting Records

1. Find the record in the data table
2. Click Delete
3. Confirm the deletion

Owners and Admins can delete any record. Editors can only delete records they created.

Note: Deletions are permanent. There is no undo, so delete carefully.

Bulk Operations

For multiple records, use chat:

“Delete all contact submissions older than 30 days”

“Mark all draft posts as unpublished”

“Update the price of all products in the sale category”

Form Field Types

The edit form adapts to your data types:

• Text fields – Standard text input
• Number fields – Numeric input with validation
• Boolean fields – Toggle switch
• Timestamp fields – Date/time picker
• Long text – Multi-line textarea

Data Validation

Sticklight enforces:

• Required fields must be filled
• Numbers must be valid numeric values
• Dates must be valid date formats
• Unique fields cannot have duplicate values

Viewing Record History

Currently, record history is not tracked. For audit trails, consider adding an updated_at timestamp field that updates on each edit.