Tables

The Tables connector enables using Nintex’s secure data storage solution within app pages. This connector has a single connection: the tenant’s Tables instance. This connection requires no configuration in Nintex CE Platform.

 

Jump to: 

Terminology

Tables objects can be accessed within an app page through a model. While doing so, keep in mind the following terminology:

  • Page Designer considers tables to be objects
  • Page Designer considers table columns to be fields

These terms are effectively interchangeable, though this topic primarily uses object and field terminology.

Usage notes

  • Tables do not currently support reference fields in Aggregate models, so these field types cannot be used when building aggregate models on app pages.

  • The automatically generated created-by or edited field value when a user makes a change in a table is the Federation Id, not the Apps user Id, because the metadata is shared across both Nintex Workflow and Nintex Apps. For example, if you are filtering data records to only display records created by the running user, then the running user attribute is the federation Id.

Create a model

To create a model and select the preferred table as the model’s object:

  1. Set Model Id and Model description as needed.
  2. Set the Connection to Tables.
  3. Set Object to the desired table.

Tables models can be basic or aggregate.

  • Any Tables model can sort by a maximum of 1 column at runtime.
  • Table metadata (its fields/columns and their settings) can be updated from the Tables page within the App Designer or the Tables section of Nintex CE Platform. For information about configuring Tables, see Tables.

Multi-select option filter behavior for Tables

For Tables sources, the multi-select option filter has the following behavior for each filter method:

  • Server: Returns options that match any selected rules, using OR logic.

  • Client: Returns options that match all of the selected rules, using AND logic.

For more information, see the General tab under Nested elements in Filter Set.