Online Help Center

Views can be based on one or multiple tables.  They can include all or some of the fields of the base table(s), and through filtering criteria they can include all or some of the data of the base table(s).  

Here is how you make a View:

1. From the File menu select New View, or in the Views view click on the toolbar.  This brings up the View Wizard.

2. Enter a name for your View.  Use only letters and numbers (no special characters, spaces, or punctuation) and begin the name with a letter.  Click Next.

3. Select the desired table(s) from the provided list. Click Next

4. If multiple tables are selected in the View, you need to join the tables.  Choose matching fields from each table’s dropdown list and click Add.  Note that the data types of joined fields must be compatible.

   • Every table used in the View must have at least one join with another table.

     You have the option to make one of your Tables editable in Datasheet and DataPages. Select your desired Table from the Table drop-down list and click Next.

   • Only one table from a View can be editable in Datasheet and DataPages.

5. On this screen you can configure View data by including or excluding desired fields, and/or choose to filter the View data by field(s).

   To include a field in the View, check the “Include field in View” box and set up field names.

   • Each field name in the fields list is prefixed with its Table name followed by a dot. Example: Customer.Name.  

   • A field alias in a View is equivalent to a Field name in a Table.

   • Caspio Bridge automatically creates aliases by using Table names followed by an underscore and the field name. Example: Customer_Name.

You have the option to set field criteria to filter data in the View so that only desired records are shown. Choose the desired field(s) and select “Filter data by this field” to define the filter criteria.


Click Finish followed by Close