About This Space

Test


Last updated on May 26, 2021

Public Permissions:   View   Open/Fork   Modify   Run  

Database Table Lookup Template

This template provides an example of a simple database inquiry and the use of database-driven components.

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.

Screenshot

This functionality is accomplished using the database-driven widget capabilities found in Profound.js. The textbox widget has the following properties set for auto-complete:

  • choices database table
  • choices options field
  • choices value field

Screenshot

Other properties can help further refine the auto-complete functionality:

  • choices selection criteria
  • choices parameter value
  • max choices
  • contains match
  • case sensitive

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.

Controlling Visibility

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.

Comments have been disabled for this space.

More Spaces By ecseage (@ecseage)

Filters:

Popular Recent

Advanced CRUD application

3350

0

0

alskjdf;

2718

0

0

Button focus example.

3397

0

Cancel button test.

3238

0

Example of how to use JavaScript to change field properties inside of a grid using JavaScript.

2826

0

0

Work-around for getting a column number from a grid when clicked on.

3397

0

0

CRUD Test

2031

0

Database-driven Select Box Test

3360

0

0

This is an example for a few ways you could set up a grid to be able to scroll/have any row at the top of a grid.

2771

0

0

An example of how to get the row of a clicked button from a grid and change the properties of other fields on that row.

3133

0

0

An example of using buttons to scroll through a grid widget. This grid also includes a row selection button on each row that allows users to select the row via a button.

2957

0

0

Testing

3348

0

0