Best answer

Take topmost record from airtable view?


Userlevel 3
Badge

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 :)

icon

Best answer by Troy Tessalone 6 May 2021, 23:19

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Userlevel 3
Badge

nope, it’s working, thank you!

Userlevel 3
Badge

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?

 

Userlevel 7
Badge +14

@jtoeman 

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

 

Userlevel 7
Badge +14

@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.

 

Userlevel 3
Badge

@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!!

Userlevel 7
Badge +10

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

Userlevel 7
Badge +14

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