I need to create a zap that will run daily, but the meat of it is i need to count how many entries occurred within the past 7 days of a sheet with multiple singular entries (each row is an entry), and then out put that number?
Im not sure which combination of formatter and sheet actions i need to properly perform this?
Best answer
Is it possible to count how many entries in the past 7 days
Best answer by GSIAlex
An alternative would be to use Airtable.
Airtable has the ability to link records across Tables.
Concept would be to link all records to a “Dashboard” Table.
Then you can use a Count field type and configure the field settings to only include records within the past 7 days.
That allows you to check a single “Dashboard” Table record to get the current count by using this Zap action: Airtable - Find Record
Thanks tony, the only issue im really having is the filtering option here. It seems ive figured this out, just now, but im cheating...decided to use a central bot lol.
I appreciate the help, i got sick of messing with filter for 3 hours to figure this out, the bot took 3 minutes.
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
Which sheet app are you trying to use in the Zap?
+14- Zapier Orchestrator & Solution Partner
Hi
May depend on how your GSheet is configured and what data points are logged.
There would need to be a data point to use to find rows by such as a date value.
Zap action: GSheets - Lookup Rows
+14- Zapier Orchestrator & Solution Partner
An alternative would be to use Airtable.
Airtable has the ability to link records across Tables.
Concept would be to link all records to a “Dashboard” Table.
Then you can use a Count field type and configure the field settings to only include records within the past 7 days.
That allows you to check a single “Dashboard” Table record to get the current count by using this Zap action: Airtable - Find Record
An alternative would be to use Airtable.
Airtable has the ability to link records across Tables.
Concept would be to link all records to a “Dashboard” Table.
Then you can use a Count field type and configure the field settings to only include records within the past 7 days.
That allows you to check a single “Dashboard” Table record to get the current count by using this Zap action: Airtable - Find Record
Thanks tony, the only issue im really having is the filtering option here. It seems ive figured this out, just now, but im cheating...decided to use a central bot lol.
I appreciate the help, i got sick of messing with filter for 3 hours to figure this out, the bot took 3 minutes.
+6- Zapier Staff
That’s great news
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.