Smart Tables

Smart Tables let you display and edit data inline, without writing binding additional functions or code.

Smart Tables provide a quick way to build simple admin panels from just SQL SELECT statements. Smart Tables are most useful when you need to edit a lot of data in your database in a similar way you'd use spreadsheets to do so.

How to use Smart Tables

You can convert to Smart Tables from regular Tables by clicking on the "Convert to Smart Table" button.

Once you've converted Tables to Smart Tables, you can have the ability to edit inline, without additional effort.

Note: Smart Tables only work with Tables bound to SQL Data Fetchers. The SQL Data Fetcher may contain any valid SQL SELECT statement to query data.

tip

For optimal conversion to Smart Tables, uniquely alias/identify each of the columns in your SELECT statement, especially when selecting columns from multiple tables in JOIN statements. If columns have the same name, use aliases to uniquely identify them.