Visual DB lets you build great looking forms that work better than hand-coded forms.
Developing and maintaining internal applications to enter and update records in a database is expensive. With its drag-and-drop interface, Visual DB Forms enables users to build data entry forms in minutes that would otherwise take a small team of frontend and backend developers weeks to months to build.
Visual DB Forms should not be confused with products such as Microsoft Forms and Google Forms. Those products are intended for surveys, not for database data entry. If you want to build data entry forms, you either have to hire 3 to 5 React developers... or just use Visual DB. Forms built using Visual DB are indistinguishable from forms developed from scratch using React.
Unlike some other Forms products, Visual DB forms are not just for creating new records. You can create records, read and display existing records, update existing records, and delete records.
Locating records to update or delete is easy, thanks to Visual DB's support for query parameters and parameter prompting.
Other form builders only allow you to layout input elements vertically, one element per row. This leads to unnatural layouts that are difficult to use. Visual DB allows you to layout elements along two dimensions. You can pack multiple related input elements in to the same row, for example, first name and last name, or city, state and zip.
Visual DB offers autmatic guides and snaps to help you align edges and match widths.
You can customize the type of input associated with a field. If available values are specified (see below), a dropdown is displayed. If a text field is intended to accept a few fixed strings, then you can use a radio input. True/False fields can use a checkbox or Yes/No radio buttons.
You can enable the user to pick a value from a list of offered values, instead of having to type the value each time. You can also specify a default value for new records.
Visual DB allows you to validate input before the form is sent to the server. Visual DB comes with built-in validations such as minimum value, maximum value, maximim length and so on that are dependent on the data type of the field. Furthermore, validations at a higher abstraction, such as those for social security number, email addreess, phone number and so on are also available.
In addition, 'Submit rules' allow you to do a final check, relating multiple fields, before the form is sent to the server.
Visual DB allows you to add logic — without writing code — to disable or hide inputs depending on values entered in other inputs.
To update or delete a record you have to find it first. Visual DB has powerful parameter prompting features that let you quickly locate records. Multi-valued and cascading parameters (where the values seen in one dropdown depend on the value selected in the previous one) are also supported. To insert query parameters, use our easy-to-use query builder. No SQL knowledge is necessary.
When a foreign key must be filled in, Visual DB assists you in finding the foreign record to link to. By default all records from the foreign table are displayed, but you can also specify a query in the case of large foreign tables.
A form can only update fields from a single database table, but it can display fields from other related tables as well. Data from related tables are displayed as read-only.
Visual DB is designed from the ground up for multi-user databases, and it will not overwrite changes made to a record by another user.
Try it today with your own database.