The editable tables are an advanced ability that transforms a table into an interactive interface. Unlike traditional read-only tables, editable tables allow the users you define to modify data directly in each cell, without the need to open additional forms or access an external control panel.
This simplifies the user experience, and significantly improves efficiency in information update processes. It is especially useful in solutions where data must be updated by several actors, such as work teams, or external collaborators.
What is the difference between a standard table and an editable table?
| Standard table | Editable table |
| S | Reading and writing |
| Useful for reporting | Useful for data management |
| Fixed information | Live and updatable information |
With this, from traditional tables that display information from a base, you can move on to editable tables, which constitute a direct information management tool, fully adapted to internal or external processes of each client.
How to set up an editable table from the Wizard for SmartView
Here we show you the detailed process for setting up an editable table using the Wizard for SmartView. This flow requires no programming knowledge, so you can quickly implement it for your clients.
Step 1: Start the SmartView wizard
- Choose "Create new view from the Wizard for SmartView".
- Inserts the "editable table" skill
Step 2: Enter the wizard and connect to a data table
- In the editable table wizard, select the database from which the data will be obtained and to which the data to be updated will be given.
- Make sure it contains the fields that your users should see and edit.
Step 3: Column selection
- Choose the columns to be displayed
nin the table.
- Mark as "Editable" the columns that will allow editing, for example: name, status, mail or comments.
Step 4: Adjust behavior and save changes
- Do you want to allow data export?
- Do you want to enable the creation of new rows directly from the table?
- Do you want to display independent actions per row, such as buttons to send, duplicate or delete records?
- Do you want to set a filter for this table?
After saving the configuration of your editable table in the Wizard for SmartView, define the following permissions
Who can see this table, all authenticated users or only certain profiles?
MasterBase® also allows you to, power of attorney . connect this table with processes to automate the flow of information, e.g.,When editing a cell, an action is triggered that sends a notification email or updates another related database.
What kind of solutions can it be used for?
Editable tables are highly versatile. You can apply them in many types of business or service solutions.as for. Some examples:
- Administration
schoolacademic: Attendance control and grades editable by teachers. Each row represents a student,and each column, a subject.
- Coordination of sales teamsOpportunities tracking by executive. The status of each customer can be updated instantly, without sending emails or using external spreadsheets.
- Production or inventory recordStock update, delivery dates or manufacturing status from the same table, ideal for plants or logistic areas.
- Validation of massive formsUsers can correct their own data without having to submit a new form, reducing errors and response times.
Why include this function skill in your next solution?
Including editable tables in your solutions allows you to offer:
- More autonomy for users, who can correct and update their information in real time.
- Increased operational efficiency by reducing the number of forms or requests by mail.
- Full control over what is defined, without compromising data integrity.
This skill also allows you to create smarter, interactive and adaptable solutions without increasing technical complexity.
And best of all, is that it can be configured in minutes, thanks to the SmartView Wizard, without the need for programming or integration of external systems.
Have questions? Come to the MasterBase® Labs
If you are a creator, remember that you can attend the weekly MasterBase® LabsIn this instance, you will be able to ask configuration questions to a panel of experts, to help you and your customers make the most of this and other MasterBase® functionalities.
