Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Simply put: trying to make a Zap that automatically pulls in data from whatever is the topmost row in a (grid) view. FWIW the Airtable view automatically sorts itself based on a set of criteria, so what I want is when the Zap is triggered, it just grabs whichever one is currently on top.

I did try using Airtable’s “Autonumber” field, with the intent to simply do a Find Record and grab #1, but I can’t get the Autonumber to update post-sorting on its own.

So as far as I can tell, I either need to find a way to make the Autonumber thing work, OR do a Find Record and force it to either select All and use the first record OR some way to force it to Find the 1st row. OR maybe use Code and force it via Javascript, but that’s a little beyond my capabilities.

Any help would be lovely :)

Hi @jtoeman 

This can be done using the Airtable API which can be used in a Zap action step via the Webhooks app with a simple GET request.

Airtable API: https://airtable.com/api

Webhook: https://zapier.com/apps/webhook/integrations#triggers-and-actions

 

 

@jtoeman

Actually try this which is simpler…

In your Zap, Action: Airtable Find Record and use the Search Formula field.

The idea would be to search for criteria that will always return a result, such a field is not empty. (e.g Name!="") )That means to search the ‘Name’ field for a record that is not null/empty/blank]

This will only return 1 record, the topmost record in a View.

 

@jtoeman

Actually try this which is simpler…

In your Zap, Action: Airtable Find Record and use the Search Formula field.

The idea would be to search for criteria that will always return a result, such a field is not empty. (e.g Name!="") )That means to search the ‘Name’ field for a record that is not null/empty/blank]

This will only return 1 record, the topmost record in a View.

 

Will try it tomorrow and report back, thank you!!

Thanks @Troy Tessalone - this does seem to be working so far, BUT, it’s not helping with the Sorted view. Do you know of any way to incorporate that?

 

@jtoeman 

Make sure to select the desired view as part of the Find Record step.

 

@jtoeman 
Just checking in to see if you still need help with this? 

nope, it’s working, thank you!

Terms & Conditions