Show/Hide Toolbars

PerfectApps ® Help Guide

icon Connect

The Connect command is a behavior object found in the integration toolbox.

 

Details

 

The Connect command can trigger a background look-up into a third-party data source. Data sources can include databases, directory services, Web Services, other PerfectApps apps, CSV files and, at an extra cost, Google spreadsheets.

 

tipbulb

Filters can be utilized to return specific records of data or multiple records of data can be returned to populate drop-down or table objects.

flag_green

In order to use the Connect and Connect and Search commands with databases, text files and LDAP (Active Directory) connections, you must first install and configure the Connection Agent.

See: Steps to integrating your apps

 

Populating Drop-down and List objects

Populating Drop-Down & List Objects

(5 min)

An alternative to the Connect & Search option is to populate drop-down or list objects with data from the data source in run-time and then allow the app user to select from that up to date list.

Populating Tables

Populating Tables

(3 min)

Watch this tutorial to learn how to populate data from an external data source into multiple columns in a table object.

Linked Connections

Linked Connections

(4 min)

If the data you need to display in your app comes from different data sources, or if a selection in the app is necessary before more data can be returned then it might be necessary to link connections together. Watch this tutorial to see an example of how that can be managed.

Insert Connection

Insert Connection

(5 min)

The Insert Connect command will, as its name suggests, insert a new record into a data source. The data source could be any of the different types, from database through to CSV files. Watch this tutorial to see how to specify the Insert command when designing your apps.

Update Connection

Update Connection

(3 min)

Watch this tutorial to see how to specify the Update command when designing your apps.

Delete Connection

Delete Connection

(2 min)

Watch this tutorial to see how to specify the Delete command when designing your apps and to see an example of the Insert, Update and Delete commands.

 

For full details on the Connect command properties CLICK HERE.