AppSheet icon

AppSheet

Interact with the AppSheet API to add, read, update, delete records, or invoke a custom action on table records.

Actions7

If Exists

AI-generated

Summary

Checks whether at least one record matching specified conditions exists in the given AppSheet table and returns existence details.

Inputs

  • region — AppSheet region domain (e.g., www.appsheet.com or eu.appsheet.com) used in API URLs.
  • tableName (required) — Name of the AppSheet table (URL-encoded if needed).
  • existsCombine — Logical operator to combine multiple existence conditions (AND or OR).
  • existsConditions — Array of condition objects, each specifying a field, operator, value type and value to test for record existence.
  • locale — Locale for formatting dates and numbers in requests (default en-US).
  • location — Geolocation coordinates used for location‑based formatting (default 47.623098, -122.330184).
  • timezone — Timezone identifier for date/time formatting (default Pacific Standard Time).
  • actionProperties — JSON object of additional properties to pass to the AppSheet action (relevant for invoke).
  • runAsUserEmail — Email address of the user under whose identity the action runs (optional).
  • userSettings — User settings to apply during the request (optional).

Output shape

object with properties exists (boolean), count (number) and records (array of matched records)

If no records match, exists is false, count is 0 and records is an empty array; the object is always returned.

Examples

Example 1: Check if any client record with email 'client@example.com' exists

Set Table Name to 'Clients', add one condition: Field='Email', Operator='Equals', Value='client@example.com', Value Type='String', then execute the If Exists operation.

Example 2: Verify that at least one task with status 'Pending' or 'InProgress' exists

Add two conditions (Field='Status', Operator='Equals', Value='Pending') and (Field='Status', Operator='Equals', Value='InProgress') with Combine With='or', then execute If Exists.

Links

Discussion