Note: Nintex Apps data centers are located in West US and Australia (AUS). In-region processing of Nintex Apps data is only available in these regions.

Using Fields

Creating a model to call and hold content is only the first step to accessing the content in an external service's data object. With some Nintex Apps components, you need to indicate which of the object's fields to display.

How do fields fit into the picture?

  • Most objects collect records related to a specific data category or topic, for example, business contacts, a company's accounts, technical service cases, a folder of business documents and spreadsheets.
  • Records are related information about a single entity within that object: a specific company in the list of accounts; an individual contact; a single service request.
  • Fields are pieces of data that have specific values. Collectively, records contain one—and usually more—fields. A particular contact record, for example, has name, address, and phone fields containing values for that contact. A record for a different contact has the same fields, but the values for name, address, and phone are different.

Field Origin

Some objects have predefined fields—fields that are standard (and in many cases cannot be deleted from the object). Even if a field is predetermined by the database's schema, builders are not required to use it in their Nintex Apps pages.

Custom fields are builder-defined within the object and usually created to address specific data needs. (These fields can be deleted from the external object.)

Field Types

Depending on the external service, the model will have access to the fields types such as the following:

  • Picklist fields and multi-select picklists

The Salesforce connector [[]]

When using dependent picklists with the Salesforce connector, be sure to include the controlling field in the model.
  • String fields
  • Date and datetime fields
  • Number/integer, and currency fields
  • Address and phone fields
  • Text and textarea fields
  • URL fields
  • Boolean fields
  • And many more ...

Specialized fields

In addition to standard fields like those indicated above, Nintex Apps uses the following specialized field types:

Reference fields

Reference fields (sometimes called "lookup" fields) represent a relationship between different objects. For example, individual contacts, opportunities, or service requests are usually associated with a client company; that company has a record in the account object. So, an accountID field included in a contact, opportunity, or service case object connects those objects to the record for the associated account in the account object. That accountID field the contact object is a reference field: it "references" the account's record in the account object.

image0

Because reference fields provide a list of values from other objects, users can access and select from those values at runtime. For example, a user adding a contact can click the new record's empty Account field and start typing; Nintex Apps autofills from the list of available accounts. ( Users can also click the magnifying glass within the field to see a modal listing all account values, and select the correct account there. )

Reference fields also allow builders to:

  • Add search capabilities within the field, which allows end users to search for content from within the model.
  • Use the reference field as a link to the referenced record's detail page.
  • Create filters to limit the searched and returned content from reference fields.
  • Use display logic to determine conditions under which the reference field values display.

Template fields

Template fields provide a way to display text or HTML alongside field data. Template fields are "containers" that allow builders to combine two (or more) fields into a single field entity using merge syntax. This saves space, and can also be used to establish relationships.

For example, to create a column in a table that displays both the record's creator and the date created (two separate fields) in that single column, add a template field to the table that displays CreatedById and the CreatedDate fields, separated by a comma and a space: {{CreatedById}} , {{CreatedDate}} .

image2

Template fields can be useful for:

  • consolidating address fields into a single (template) field
  • incorporating html into display fields

For additional information, see the Text component topic.

Adding template fields

Add template fields to a Table or Form component from the Add fields dropdown on the component.

Note:  You can only select fields that are already included in the model.

Then adjust the Template's properties:

  • Use the field picker on the Template property to select fields to combine within the template. The fields selected display in the property surrounded by double curly brackets {{field selected}} .

    • Make any spacing adjustments (add spaces, dashes, or commas).
  • If desired, modify the field's Label. This will re-name the field label (or the column heading in a Table component).

Template fields in runtime

Users can double-click on a template field to open a popup where they can see the fields the template includes and edit them (if applicable).

If no fields are included in the template, then clicking the field does nothing.

Using HTML in fields

When the Allow HTML property is checked, any HTML markup within the field value will be parsed and rendered per the markup.

This can be useful for introducing paragraph formatting in large text fields, or templates that include combinations of fields using merge syntax, such as a mailing address:

Copy
<p>{{Name}}</p>
<p>{{MailingStreet}}<br>
{{MailingCity}}, {{MailingState}} {{MailingPostalCode}}<br>
{{MailingCountry}}</p>

It's also possible to use this feature for other, more advanced HTML elements.

Important:  While using custom HTML can allow for powerful customizations, it can come with risks. Custom HTML is not officially supported and can result in unexpected behaviors. If you do use custom HTML, test your pages thoroughly in a sandbox environment after each Nintex Apps update.

UI-Only Fields

UI-Only fields ("user interface-only") are builder-determined "container" fields for "as-needed" data. These fields work with values that are input by users in runtime, values that result from data queried by the user, or values predetermined by the builder.

Think of UI-Only fields as "temporary": the data in UI-Only fields is not stored in a data object, and if the page is refreshed, the data in a UI-Only field does not persist.

To learn more, see UI-Only Fields and Models.

Field Metadata

Metadata is data about data, information that describes the data itself. Think of field metadata as a kind of "summary" of what the field's data is. Every field has standard metadata properties. Learn more in Field Metadata Overrides.

Properties

Fields

Once fields are added to the Table or Form component, each has a specific set of properties. These properties vary, depending upon the component and field type. Click on the field within the table to reveal and edit its properties.