Simbla's data table web widget allows you to draw whole tables of data from your online database and present them on your page with different styles and editing options.
Click here to view a live example of data table widget. The table's permissions are limited for the example so you won't be able to add, edit or delete records, you will be able to view a live database table and the way the form is built.
After placing your widget a window will open with four tabs:
4. Data options
Under the database tab you will choose the table you would like to draw the data from and select the fields you would like to present in your table.
Rename your columns as how you want them to show on your page.
Filter allows you to set a filtering method for your table, you can choose from two options:
2. Filter the data by a set criteria- by filtering by criteria, the table will appear to the user already filtered.
In the next example we will filter our "Cars" table to only present cars with a model year greater than 2015:
Data options will allow your users to perform actions on the table that will affect both the database in the background and the presented table on page.
The available actions are :
1. Delete - delete a database record.
2. Edit - Edit a database record.
3. Create - Create a new database record.
In addition, you will be able to choose which columns the users will be able to perform the actions on.
The actions are allowed for all users that meet the tables permissions. For example:
If your table permissions don't allow public users to edit, create and delete records, but do allow members to do so, only members will be able to perform actions while public users will get an error message.