Help

How to get ONE record from "Find records" step?

Topic Labels: Automations
8872 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Kamil_Lelonek
5 - Automation Enthusiast
5 - Automation Enthusiast

Is there a way to fetch just one record or take the first/last one from the returned list?

In table A I have a record with an email.
In table B, I also have records with their emails.

I need to update A record with B attributes but they come from different sources and are not associated - they just have the same emails.

10 Replies 10
alexh
5 - Automation Enthusiast
5 - Automation Enthusiast

I'm trying to do something similar with automation here, but I'm getting stuck in the Update Record step. I'm using the "Find Records" function to gather available options but am having trouble selecting just one and then inserting it into another record in a different table. 

In case it's helpful, this is my issue: https://community.airtable.com/t5/automations/automation-updating-record-with-just-one-item-from-ano...