You can enable editing for manual, imported and SQL query based tables. As for SQL Query based tables, if the query is pulling data from multiple database tables, editing will probably not be possible.
You can simply click on Allow editing on the Editing tab and you will be able to add or delete rows from your table.
The table from the database needs to have a unique auto-increment column, and that column needs to be selected as the ID column for editing in the Editing tab above the table.
Please note that you can't add any columns to SQL query-based tables.
Hi , I would like to know if there is an option to add or edit the data in a table that was generated with sql query?
Hi Eli
Thank you for reaching out to us.
You can enable editing for manual, imported and SQL query based tables. As for SQL Query based tables, if the query is pulling data from multiple database tables, editing will probably not be possible.
You can simply click on Allow editing on the Editing tab and you will be able to add or delete rows from your table.
The table from the database needs to have a unique auto-increment column, and that column needs to be selected as the ID column for editing in the Editing tab above the table.
Please note that you can't add any columns to SQL query-based tables.