Hello
it is possible to select in a google sheet rows whose current date is between a start date and an end date (the start and end date are included in the rows of the table)
thanks
Hello
it is possible to select in a google sheet rows whose current date is between a start date and an end date (the start and end date are included in the rows of the table)
thanks
Hey
Unfortunately this is not possible on Zapier. We can lookup only for exact values with Google Spreadsheet action.
Hi
There are advanced workarounds using filter/query formulas but there are limitations to be aware of, such as the number of rows that can be returned.
Perhaps consider using Airtable: https://zapier.com/apps/airtable/integrations
Airtable has an API that can be used: https://www.airtable.com/developers/scripting/api
Again, there are pagination limitations to be aware of such as 100 records per page.
thank you for your answers
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.