Skip to main content
Drupal is a registered trademark of Dries Buytaert
Release: OpenID Connect / OAuth client 3.0.0-alpha9 New alpha version released for module openid_connect (3.0.0-alpha9). Usage Milestone: Google Analytics Module google_analytics crossed 1,000 active installs. Release: GraphQL Compose Codegen 1.1.2 Minor update available for module graphql_compose_codegen (1.1.2). Release: Mapy.com 1.1.3 Minor update available for module mapycom (1.1.3). Release: Ckeditor5 entity browser 3.0.3 Minor update available for module ckeditor5_entity_browser (3.0.3). Release: Ckeditor5 entity browser 3.0.1 Minor update available for module ckeditor5_entity_browser (3.0.1). Release: Ckeditor5 entity browser 3.0.2 Minor update available for module ckeditor5_entity_browser (3.0.2). Release: Teamleader Integration 4.0.2 Minor update available for module teamleader (4.0.2). Release: Change Requests 2.1.9 Minor update available for module change_requests (2.1.9). Module Revived: Entityqueue Buttons 1.1.2 Module entityqueue_buttons updated after 8 months of inactivity (1.1.2).

Json table

75 sites Security covered Drupal 9–11
View on drupal.org

This module allows you to store and display structured JSON data in a MySQL database. It provides a widget for easily inputting data from spreadsheets or CSV files, with shortcuts for common table editing actions. The data can then be displayed as a table or chart using various libraries.

This field will be stored in Mysql database with JSON data type (no test for other like Postgre type jsonB). it will be practice for developer queries with mysql, not like text data type.

Widget/Formatter supports json editor and table input.
Widget:

  • You can paste the table from excel it will autofill.
  • You can load file csv it will autofill.
  • Table you can set default value in field settings, then goto widget setting lock table, by default it uses input text but you can custom with select or textarea in custom configured format.

Shortcut

  • Ctrl + D: Duplicate row
  • Alt + N: New row
  • Ctrl + K: Delete current row
  • Ctrl + ↑ / ↓: Move row to up / down with arrow keys
  • Arrow key 🡠 🡢 🡡 🡣: Move with arrow key

Formatter:
You can display data as table (bootstraptable, datatable ) or chart (google chart or Chartjs)

Support:
some js addon libraries don't mix it in widget and formatter
- gojs Flowchart
- x-spreadsheet
- LuckySheet
/!\ LuckySheet is very heavy and conflicts with ckeditor dialog.jquery-ui. if you use luckysheet in widget and you will need to display in formatter with luckysheet
I highly recommend using x-spreadsheet even though luckysheet has more features

Do you like this module? Show your appreciation by buying me ☕.

Depends on

Dependencies of the latest stable release

No dependencies recorded for this project.

Required by

1 tracked project depends on this one

Activity

Tracked releases
4
Tracked since
Dec 2024
Latest release
10 months ago
Releases (12 mo)
1 ▼ from 3
Maintenance
Slowing

Release Timeline

Releases

Version Type Core Release date
1.0.31 Stable 9–11 Oct 14, 2025
1.0.30 Stable 9–11 Mar 20, 2025
1.0.29 Stable 9–11 Feb 16, 2025
1.0.28 Stable 9–11 Dec 4, 2024