Question

How do I query Zapier Table using Zapier Interface?

  • 24 January 2024
  • 3 replies
  • 71 views

Userlevel 1

I have zapier tables containing data for clients. Each client might have multiple rows for each time they purchase something, with a column for the “value”.

 

I want to create an interface or view where I can search by client reference and the view then displays the SUM of “value” of all rows that match the client reference.

Its a relatively straight forward request but I’m struggling to find any information or guidance for this? Is it currently not possible ?


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

3 replies

Userlevel 7
Badge +14

Hi @Gwilym 

As an alternative, I know that can be done with Airtable Views (filters) and Interfaces (filters).

 

Zapier Interfaces help for possible guidance: https://help.zapier.com/hc/en-us/categories/14490381804173-Interfaces

 

 

Userlevel 1

Hey, do you mean Interfaces within airtable, or zapier interfaces that query airtable? 

Userlevel 7
Badge +14

@Gwilym 

Airtable Interface and Airtable Base Table Views: https://support.airtable.com/docs/filtering-records-using-conditions