This interactive app prompts the user for key fields to lookup a database record and displays the results
Last updated on October 30, 2020
Database Table Lookup Template
This template provides an example of a simple database inquiry and the use of database-driven
Database Driven Auto-Complete
The customer number textbox provides auto-complete functionality that shows available customer
numbers, along with the corresponding customer names. The user simply starts typing into the box
to see available choices.
This functionality is accomplished using the database-driven
widget capabilities found in Profound.js. The textbox widget has the following properties set for
choices database table
choices options field
choices value field
Other properties can help further refine the auto-complete functionality:
choices selection criteria
choices parameter value
Retrieving Full Customer Information
Customer information is retrieved using actions in a routine. Routines can be found under the Logic tab in the Visual Designer.
Widget properties on the screen can be bound to dynamic fields that are accessible by your routines. For example,
the "visibility" property of the widget that shows the Invalid Customer Number message was bound
to a boolean field named invalid. This makes it easy to trigger the message from our routine
just by setting invalid to true or false.