anygridjs

AnyGrid Documentation

AnyGrid offers a powerful, flexible data grid system with built-in form integration, pagination, sorting, modals (with functional edit and delete capabilties), and more — all without having to touch any HTML or CSS.

While the library is built for the Semantq JS Framework - AnyGrid is framework agnostic and can work with any JS Framework and vanilla JavaScript.

Feature Overview

Data Handling & Display

• Flexible Data Presentation:
  • Pagination: Easily navigate large datasets with configurable items per page, ensuring optimal performance and user experience.
  • Search & Filtering: Empower users with an integrated search functionality for quick and efficient data filtering.
  • Sorting: Enable data sorting by specific columns, with options to configure which columns are sortable.
• Advanced Column Management:
  • Custom Column Display: Choose precisely which columns from your form data to display in the grid.
  • Joinable Columns: Combine data from multiple columns (e.g., name and surname rendered as fullName) for enhanced readability and visualization.
  • Custom Rendering: Deploy custom JavaScript functions or inject HTML directly into data rendering, allowing for highly flexible and dynamic cell content.

Customization & Theming

• Effortless Theming:
  • Built-in Themes: Apply predefined visual themes by simply defining your preferred theme (e.g., theme: 'blue') in the features object.
  • Custom Theme Colors: Override built-in themes or define a unique aesthetic by specifying a custom main color using a HEX code (e.g., themeColor: '#4f4f4d') in your features object.
• Action Handles: Integrate custom action buttons (e.g., "Edit," "Delete") directly within table rows, providing interactive functionality.

Interactivity & Modals

• Grid Modal for Detailed Views:
  • Row-Click Modal: Enable a gridModal option to allow users to click on any row and view the full record details in a dedicated modal window.
  • In-Modal Editing & Deleting: The modal mode provides options for record editing and deleting. This is particularly useful for use cases where you want to disable inline editing/deleting (e.g., for lower-level users or front-end displays).
  • Seamless API Integration: Grid Modal editing and deleting (including a confirmation step for deleting) are backed by a fully functional API. You simply need to pass your record editing and deleting endpoints in the features object. e.g. dataApiEndPoint: 'http://localhost:3000/product/products',
  • Dynamic UI Updates: All modal editing and deleting features occur on-screen without a page refresh. AnyGrid seamlessly updates the data grid and the modal itself after record modifications, ensuring a smooth and responsive user experience without page reloads.

Integration & Deployment

• Easy & Quick Deployment: AnyGrid is designed for rapid deployment. All you need is your $data object, column definitions, and an optional features object to get started.

• Multiple Grid Capability: Implement the capability to display multiple independent data grids on the same page, each with its own data and configurations.

• Formique Integration: Works seamlessly with Formique, a robust code, low-code/no-code JavaScript-driven form builder, enabling you to write complete forms with robust inbuilt form submission logic without touching HTML or CSS.

• On-the-Fly Export: Optionally enable CSV and Excel export formats for your data directly from the grid interface.

• Sticky Table Headers: Keep headers visible while scrolling for better usability.

• Framework Agnostic: Works with any JavaScript framework (Semantq, React, Angular, Vue, Svelte etc.) or vanilla JS.

• Modularity and Features Optionality: Choose only the features you need for a lightweight and tailored implementation.

Why Choose AnyGrid?

• Vanilla JS: No dependencies, works with any JavaScript framework or vanilla JS
• Lightweight: Minimal footprint, optimized for performance
• Customizable: Adapt the library to fit your project's unique needs
• Responsive: Tables adapt to various screen sizes and devices
• Flexible: Integrate with your preferred framework or use with vanilla JS Get Started
• Extensible: you can extend the features nd functions of the library
• Minimal Configs: all you need is a div with anygrid or custom id name, a json data object, column definition, features object (optional) in your app.js or via script tag directly on the html. See usage section below.

Installation & Usage

Installation

npm install anygridjs

Import into your project:

import AnyGrid from 'anygridjs';

Usage

• html: insert this containter somewhere in your html (before the js script tags html mark up shown in step 2)

<div id="anygrid"></div>

You can also use any id that you prefer e.g.

<div id="users"></div>

In this case, you will have to define the target container id in the features object as shown below:

const features = {
gridContainerId: 'users'
}

If the id of your target grid container is 'anygrid' then you do not need to define the gridConatinerId in the features object.

• Get the AnyGridCSS via the cdn link.

  <link rel="stylesheet" href="https://unpkg.com/anygridcss@1.0.1/anyGrid.css" anygrid-style>

• Add your js markup in the html just before the html </body> tag:

<script src="https://unpkg.com/AnyGrid@1.0.9/anygrid.global.js"></script>
 <script src="app.js"></script>

app.js

const data = [
 { id: 1, name: 'John', surname: 'Doe', age: 30, role: 'Developer', salary: 50000 },
 { id: 2, name: 'Jane', surname: 'Doe', age: 28, role: 'Designer', salary: 45000 },
 { id: 3, name: 'Jack', surname: 'Smith', age: 34, role: 'Product Manager', salary: 60000 },
 { id: 4, name: 'Emily', surname: 'Jones', age: 27, role: 'Marketing Specialist', salary: 47000 },
 // add more records 
];

 const columns = [
 { name: 'id', header: 'ID', render: (value, row) => `<a href="/user/profile/${row.id}">${row.id}</a>`, sortable: true },
 { name: 'fullName', header: 'FULL NAME', joinedColumns: ['name', 'surname'] },
 { name: 'age', header: 'AGE', sortable: true },
 { name: 'role', header: 'ROLE' },
 { name: 'salary', header: 'SALARY', render: '<strong>R{salary}</strong>', sortable: true,

   actions: [
     {
       label: 'EDIT',
       url: 'edit/{id}',
       class: 'edit',
       id: 'edit-{id}',
     },
     {
       label: 'DELETE',
       url: 'delete/{id}',
       class: 'delete',
       id: 'delete-{id}',
       confirm: true,
     }, 
   ], 
 },
];

const features = {
initialItemsPerPage: 30,
csvExport: true,
excelExport: true,
theme: 'pink',
gridModal:true,
modalConfig {
 editable: true,
 deletable:true,
 nonEditableFields:['id']
}
}

const dataGrid = new AnyGrid(data, columns, features);

NOTE that the features object is optional so you can invoke AnyGrid without the features object as shown below:

const dataGrid = new AnyGrid(data, columns);

The data object

// data object (JSON)

const data = [
  { id: 1, name: 'John', surname: 'Doe', age: 30, role: 'Developer', salary: 50000 },
  { id: 2, name: 'Jane', surname: 'Doe', age: 28, role: 'Designer', salary: 45000 },
  { id: 3, name: 'Jack', surname: 'Smith', age: 34, role: 'Product Manager', salary: 60000 }
  // Additional data trimmed for brevity
];

Column Definition

const columns = [
  { name: 'id', header: 'ID', render: (value, row) => `<a href="/user/profile/${row.id}">${row.id}</a>`, sortable: true },
  { name: 'fullName', header: 'FULL NAME', joinedColumns: ['name', 'surname'] },
  { name: 'age', header: 'AGE', sortable: true },
  { name: 'role', header: 'ROLE' },
  { name: 'salary', header: 'SALARY', render: '<strong>R{salary}</strong>', sortable: true,

    actions: [
      {
        label: 'EDIT',
        url: 'edit/{id}',
        class: 'edit',
        id: 'edit-{id}',
      },
      {
        label: 'DELETE',
        url: 'delete/{id}',
        class: 'delete',
        id: 'delete-{id}',
        confirm: true,
      }, 
    ], 
  },
];

// create a new instance of AnyGrid

const dataGrid = new anyGrid(data, columns);

Default Features

AnyGrid has these in built features enabled by default: search/filter, sort, actions (row actions like edit or delete), pagination, items per page, dynamic headers and initial items per page. Therefore you do not need to declare them in the features object. However, AnyGrid gives the option to disable these features if you don't need them. Below is an example of how you can disable these features.

const features = {
  search: false,
  sort: false,
  actions: false,
  pagination: false,
  itemsPerPage: false,
  dynamicHeaders: false,
}

Styling (Optional)

AnyGrid is a headless JS library - meaning the library can still work without any CSS and the styling is entirely up to you. However as an option we offer a basic and high end css themes to enhance the look and feel of your data tables. If you want to use the provided css just deploy anyGrid.css via this cdn link:

Place this somewhere in the head section of your html.

  <link rel="stylesheet" href="https://unpkg.com/anygridcss@1.0.1/anygrid.css" />

Color Themes

AnyGrid css offer these color themes: default (dark), light, blue, pink, dark-orange, green and indigo. You can define your prefer color theme on the features object this way:

const features = {

theme: 'pink'

}

🌐 API Integration with smQL

Use @semantq/ql for fetching and submitting data efficiently.

Install

npm install @semantq/ql

Import

import smQL from '@semantq/ql';

Fetching data:

const records = await new smQL(API_END_POINT); 

smQL handles GET, POST, PUT, DELETE behind the scenes and simplifies async handling. It's recommended to declare API_END_POINT (e.g. http://localhost:3000/product/products) as a constant or environment variable for maintainability.

Here’s a refined and more professional version of your explanation:

Edit & Delete API Structure in SemantqQL

In the SemantqQL full-stack project, the API routes for editing and deleting records follow a consistent structure:

{server_url} / {model_name (lowercase)} / {route_name}

For example, if you're working with the Product model, the API endpoint for editing or deleting records would look like:

http://localhost:3000/product/products

You can always confirm or modify these routes by checking the semantQL/server/routes/modelRoutes.js file.

Advanced Usage

Column Definition and Feature Configuration

const features = {
  initialItemsPerPage: 5,
  csvExport: true,
  excelExport: true,

  theme: 'indigo', // Optional: Built-in colour themes like 'indigo', 'teal', 'slate', etc.
  themeColor: '#556B2F', // Optional: Custom HEX colour to override built-in theme

  gridModal: true, // NEW: Enables row-click modal interaction
  modalConfig: {
    editable: true,                  // Show "Edit" button in modal
    deletable: true,                 // Show "Delete" button in modal
    nonEditableFields: [            // Optional: Fields excluded from edit view
      'id', 'uuid', 'status', 
      'sortOrder', 'createdAt', 'updatedAt'
    ]
  },

  dataApiEndPoint: 'http://localhost:3000/product/products', // For update/delete actions
};

New Feature Explanations

gridModal (Default: false)

• When enabled, clicking on any row opens a modal displaying full record details.
• This modal is useful for CRUD-lite use cases where inline editing is disabled.
• Controlled via modalConfig:

Option	Description
editable	Enables "Edit" button inside the modal
deletable	Enables "Delete" button inside the modal
nonEditableFields	Prevents editing of specified fields

dataApiEndPoint

• Sets the URL for update and delete operations (used by the modal).
• Automatically appends record ID to the endpoint for PUT and DELETE requests.

// Example:
PUT    /product/products/6
DELETE /product/products/6

themeColor

• Accepts a custom HEX code (e.g. #556B2F) - this will override the theme if a theme is also defined in the features object.
• Affects button backgrounds, hover states, modal accents, and more.

If you want to use the default/dark theme then you don't need to define the theme parameter in your features object.

Block Table Style Mobile displays

AnyGrid styles and themes come with block table style for mobile screen displays. See example below:

AVAILABLE IN BUILT THEMES (List is to be extended)

• default or dark
• Light
• Pink
• Indigo
• Blue
• Dark Orange
• Green

Using Custom Containers (useful for multiple data grids)

By default, AnyGrid will place your data grid in the element with the id: anygrid eg:

 <div id="anygrid">Your data grid will be displayd here</div>

However using custom container ids can be useful particularly if you want to display more than one data grids on the same page. See below.

• Define your custom container

<div id="users"></div>

Having defined your data and columns for your AnyGrid instance you can then invoke the AnyGrid class with the custom container id parameter:

const containerId='users';
const dataGrid = new anyGrid(data, columns, features);
//or without the features object
const dataGrid = new anyGrid(data, columns);

You need to use this approach for every instance of AnyGrid you need to implement on your page.

Laravel Implementaton Guide

Contribute

AnyGrid is largely an open-source project. Contributions, issues, and feature requests are welcome!

License

AnyGrid is licensed under the MIT License.

Keywords

• JavaScript data tables
• JS data grid
• Table pagination js
• Table column sorting js
• Searchable data table js
• JS data tables with column joining
• JS data tables with action handles
• JS data tables with URL definition
• Framework Agnostic js data tables
• Vanilla JS data tables
• Lightweight JS Library data tables
• Customizable js data tables
• Responsive Design js data tables
• Front-end Development js data tables
• Dynamic JS Data Tables
• Interactive Data Tables
• Datagrid Modals
• DataGrid Crud
• Datagrid with edit and delete options

For more details, visit:

• AnyGridJS GitHub Repository
• AnyGridJS Documentation

Additional Resources

• AnyGrid Main Documentation

• Laravel Basic Integration Guide

• Laravel Eloquent ORM Integration Guide

• Mastering Obect Relational Mapping In Laravel: Spotlight On AnyGrid JS

Danko! Ngyabonga -:)