PowerTable lets users add new columns to the source database directly through the app. This feature eliminates the need for users to engage with the database directly, enhancing security and efficiency.
Please ensure you have the required permissions to the database you are connected to, as you are adding a column directly to the source database.
Let us consider the example below where we will add the approver details column to the Product SubCategories table.
1
To add a new column to the source, click on Add Database Column.
Add Database Column
2
Enter the column name and its data type.
You can optionally make it a non-nullable column and assign a default value. Then click Save.
Here, we have added the Approvers column with the data type VARCHAR.
Add column name and data type
3
Configure the column properties for the newly added column.
Configure the column properties for the newly added column, as you would for any other columns, and then click Save.
Configuring the added column
4
View and update the newly added column.
Now you can view the newly added column in the app, where you can start updating the details. The newly added column as well as the changes are synced with the source database.
Update details
Please exercise caution when adding columns. Once created, they cannot be modified or deleted from the app directly—you must access the database to do so.