Help

The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

Re: Lookup Record by Field based on Value with Script

Solved
Jump to Solution
963 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Cameron_Mason1
4 - Data Explorer
4 - Data Explorer

I would like to use a scripting automation to check if a record exists. i.e. Does John Doe exist already in the Name column?

The results should be simply yes or no.

I’m not great at scripting and am looking for some fast track help!

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

Welcome to the community, @Cameron_Mason1! :grinning_face_with_big_eyes: This can be done without a script. Use the “Find records” action to search for a record with a matching name. In a conditional branch, execute the actions you desire if the count of records found from the “Find records” action is 1.

See Solution in Thread

1 Reply 1
Justin_Barrett
18 - Pluto
18 - Pluto

Welcome to the community, @Cameron_Mason1! :grinning_face_with_big_eyes: This can be done without a script. Use the “Find records” action to search for a record with a matching name. In a conditional branch, execute the actions you desire if the count of records found from the “Find records” action is 1.