Json table
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 ☕.