Sometimes the process of data entry in an application is so repetitive that you want to provide the end-user a more efficient way of doing it. This can be done by allowing the end-users to create and edit multiple records at once. You can provide this functionality using an Editable Table widget.

As an example assume you have an application to track your daily expenses. Each day you add a few expenses by the end of the day, and you want to be able to do it in an efficient way.

Show and edit multiple records at once

To show and edit multiple records:

  1. Create a web screen;
  2. Add an aggregate or SQL query in the preparation to fetch the results to show on the Editable Table;
  3. Add an Editable Table widget to the web screen and bind it to the output of the query in the preparation;
  4. Drag and drop the Expense entity into the Editable Table;
  5. Create a new screen action to save the record using the 'CreateOrUpdateExpense' entity action;
  6. Bind this screen action in the 'On Row Save' event.

Deleting records

You can also implement the functionality to delete records within the Editable Table:

  1. Create a new screen action to delete the record using the 'DeleteExpense' entity action;
  2. Bind this action to the 'On Row Delete' event.

Adding custom server-side validations

The Editable Table performs automatic client side validations of the inputs ensuring that the information sent to the server, upon the row save event, is valid in terms of data types and mandatory information. You can add your own validations before you send the information to the database.

In the same example above, to validate that the entered date is not in the future:

See Also

About the Editable Table Widget | Input Widget Properties