ISFIELDSET

Syntax

ISFIELDSET ("field_name")

Description

ISFIELDSET checks to see if the field is returned by the Connector.

Arguments

field_name

The name of the source field.

Returns

If the field specified by field_name is returned by the Connector, returns a Boolean True.

If the field specified by field_name is not returned by the Connector, returns a Boolean False.

Remarks

Note: Since the field name must be in quotes, if you change the name of the Connection that is the source for the field name used in this function, the name change does not propagate to the field name. If you change the Connection name, you must manually update this function.

Field name must be in quotes. Using a field name without quotes prevents the associated flow from preparing and saving correctly.
For all Block types except Build Reply, the field name used in the formula must be mapped elsewhere in the flow. If the field is not mapped in another field in the flow, ISFIELDSET evaluates to False.
The formula can only be used in fields that support booleans, such as boolean, string, or integer data types. A validation error is generated if this formula is used in a datetime or date field.
If you are using a SQL Connector, at least one mapped property must return a value for the property in the ISFIELDSET formula to evaluate correctly when the property in the formula returns a NULL value.

Examples

If the current record of MyEntity.Customer is returned as part of the result set then the following formula:

IF(ISFIELDSET("MyEntity.Customer"), "Data was returned", "Data was not returned")

Note: MyEntity.Customer does not have to contain a value to evaluate to true. The property itself, MyEntity.Customer must be included in the information returned.

Returns:

"Data was returned"

If the request does not contain the field, then:

IF(ISFIELDSET("MyEntity.Customer"),"Data was returned", "Data was not returned")