Hello! I want to search a google sheet (or a Zapier table if that helps), but I want to sort it before I search to ensure I grab the data with the the highest value in a certain column. Is there any way to do this?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
An alternative would be to use Airtable.
Airtable has Views.
Views can have sorts.
You can search for a record in a View and it will return the first matching record.
https://support.airtable.com/docs/sorting-records-in-airtable-views
+3Hi
+14- Zapier Orchestrator & Solution Partner
I don’t think the Zap action for Zapier tables - Find Record supports choosing a View yet.
+11- Community Manager
Hi folks! 👋
Troy is correct, it’s not currently possible to select a sorted view in a Find Record (Zapier Tables) action. .
If you’d prefer to do it in Google Sheets then again, you’d need to submit a feature request to our Support team as it’s not possible to select a sort order in Google Sheets search actions.
Sorry to not have a more immediate solution to suggest. Do let us know if there’s anything else you’d like some help with in the meantime. 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.