Edit Tables | AI JSON CRUD Table Maker Tutorial

Uncategorized9 months ago

Loading the Table

To get started, you first need to load a table. You can either start from an existing JSON array to load a table with data, or start from a schema to create an empty table with your defined fields.

Loading a table by pasting a JSON array or using a schema definition.

Example JSON

[
{
"project_name": "Q4 Financial Audit",
"department": "Finance",
"priority_level": "High",
"is_approved": true,
"budget_estimate": 12000
},
{
"project_name": "Product Launch Campaign",
"department": "Marketing",
"priority_level": "High",
"is_approved": false,
"budget_estimate": 25000
},
{
"project_name": "Server Infrastructure Upgrade",
"department": "IT",
"priority_level": "Medium",
"is_approved": true,
"budget_estimate": 18000
},
{
"project_name": "Supply Chain Optimization",
"department": "Operations",
"priority_level": "High",
"is_approved": false,
"budget_estimate": 30000
},
{
"project_name": "Employee Training Program",
"department": "HR",
"priority_level": "Low",
"is_approved": true,
"budget_estimate": 8000
}
]

Example Schema

project_name: string, department: [Finance|Marketing|IT|Operations|HR], priority_level: [Low|Medium|High]", is_approved: boolean, budget_estimate: number

Key Table Editing Features

01 | Add Record

Insert a new, empty row into your table to input new data.

02 | Delete Record

Remove a selected row from your table.

03 | Edit Record

Open a dedicated editor pane where you can modify the row’s content.

04 | Generate with AI

Use AI to generate new data based on your table’s structure.

05 | Add Record

Sort your data by clicking on a column header.

Data table interface highlighting the Add Record button, edit icons, and delete options.

The Smart Record Editor

String / Number

For these data types, a simple text input box appears, allowing you to directly enter text or numbers.

Text input boxes for string and number data types in the AI JSON CRUD table maker interface.

Selection [A|B|C]

If your schema defines a list of options (e.g., priority:[low|medium|high]), a dropdown menu will appear, allowing you to select a valid option.

Dropdown menu for selecting department options like Finance, Marketing, and HR.

Boolean

For boolean (`true`/`false`) fields, the editor provides a simple checkbox. In the table itself, this will be represented by a checkmark (✅) or a cross (❌) for easy readability.

Boolean field editor showing True and False options with corresponding checkmark and cross icons.

Exporting Your Final Data

Once you are finished editing, you can save your table in either a JSON or CSV file.

Export options for JSON and CSV files in the AI JSON CRUD table maker interface.

Loading

Signing-in 3 seconds...

Signing-up 3 seconds...