Customer Inquiry

About This Space

This interactive customer inquiry app prompts the user for key fields to lookup a customer record


Last updated on October 25, 2020

Public Permissions:   View   Open/Fork   Run   Comment  

Database Table Lookup Template

This is 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.

Be the first to comment:      

Comments

Write Preview Markdown: bold italic code link
Post

Filters:

Popular Recent

Demo app to use EJS to display information from a database

5667

0

4

This lab walks you through building a series of Node.js applications that work with employee data.

5471

3

7

A simple Demo of how to deploy EJS templates from a stateful Node.js script

5409

0

6

This space illustrates the simplest way to load a Rich Display grid with data, where all records are sent to the grid in bulk.

4962

0

6

This is a simple demo of Fibers! Fibers simplifies code by avoiding messy code known as "callback hell", "promises hell", or "async/await hell". Once Fibers is setup, you never have to think about callbacks or promises (they are handled automatically for you).

4555

0

5

A simple dashboard example that uses responsive design

4280

0

3

This workspace illustrates the basic setup of an HTML page that includes external JavaScript and CSS files

4009

0

5

This is a full database maintenance CRUD application with view, change, add, and delete capabilities

3857

0

7

This app allows a team to decide where to go for lunch (or dinner) by using acceptance voting.

3425

2

4

This app allows a team to decide where to go for lunch (or dinner) by using acceptance voting.

3277

1

5

Displaying information in grids is fundamental to developing applications. This demo application displays a list of products in a grid.

3155

0

1