Find Record

Easily update all records matching a criteria.

Chat icon
Transcript

How to Use

Find Criteria

  • After selecting the desired trigger, in the action step select “ Find Record
  • Select the Application and List you’d like to find the record in
  • Click the “ New Field” next to find by, you will be presented with a list of fields that belongs to the list 
  • Select the field you’d like to use for the search criteria
  • Then Select the operator you would like to use for comparison:
    • Is operator will look for an exact match of the selected fields value
    • Contains operator will look for a partial match of the selected fields value, only available for linked list fields.
  • Then Select comparison type:
    • Dynamic will let you compare the Find By field to a field from the triggering record or an incoming webhook property.
    • Static will let you compare the Find By field to a static value that you can manually input
    • Formula will give advanced comparison options based on the output of the formula you create.
  • From “ Found Records” you can select to apply the action to:
    • Only the first record found based on the search criteria
    • Apply it to the first x records found based on the search criteria, this is limited to 5000 records max.
  • After your done setting up your find criteria, you can continue to select the action you’d like to apply to the found record

Sub-action

  • Now that our find criteria is set-up we can proceed to build the action we’d like to apply to the found record/records
  • Under Find Record Click “Add Action”
  • Select the action you’d like to take, in this example we will select update record
  • In “ The Record To Update” drop down you will find 4 options
    • Triggering Record: this will select the record that triggered the automation.
    • Triggering Record - Linked: this will open a drop down of the Linked List field of the record that triggered the automation.
    • Output Trigger: this will select the record that was found based on the Find Criteria in the previous step.
    • Output Record - Linked: this will open a drop down of the Linked List field of the record that was found based on the Find Criteria in the previous step.
  • After selecting “ The Record To Update” you can select the fields you’d like to update
  • If you select Dynamic you will be presented with the fields from both the Triggering Record and the Output Record to select from
  • Once you’re done selecting the fields you’d like to update, click Done, Save the automation, and you’re good to go.

Important Note 🔴

  • Each action executed under the automation will count as an execution and it will be reflected to the automation quota accordingly.
  • E.g. if find criteria was set to find 100 records and execute 5 different action for each record this will count as 500 execution
  • I.e. Number of found records  x  Count of Actions per record
Search icon

Looking for something else?

Search by entering some keywords such as; 'email automation', 'linked list'...
Email icon

Still need help?

If you could not find the answer to your question, please contact the support team using the chat box.