Managing Your Data

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

Adding Records

1. Open the Cloud Database
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

Note: Deletions are permanent. There’s 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 can’t have duplicate values

Viewing Record History

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