As I made more web apps, I realised the apps often needed a way to interact with a database - create, read, update and delete records, which is known as CRUD.
I liked database interfaces I'd used before, such as Microsoft Access, and I wanted to make a JavaScript library which could quickly recreate a similar interface on a web page.
I called my library "Tablescript". All you need to do to add an interactive table to a web page is make a Tablescript object and decide where to put it. The Tablescript library does the rest!
Here are some of the features of a Tablescript table.
- The table has a "container" which is an HTML element on the page, such as a paragraph.
- The table can be given initial data such as existing rows.
- The table can be set to view or edit, or to only accept a single row.
- Each field has a data type and HTML to display it.
- A field can have a validation rule, for example, only allow numbers 1 to 100.
- A field with a "select" menu can allow the addition of new options in a popup.
- A field can be set to cause default values in other fields.
- The table and any popups can be decorated with CSS.
- When the user clicks the submit button, the table returns a JSON object with its current data.
