While the query to get items by several values is great for drop-down lists, it can not really be used with numeric or date columns.
This could change if we could use operators in the query to get items:
- where a specific number is the 0 to 6 range (ex: detractors for a NPS score)
- where a specific date is in the last 3 months (or any n hours, days, open days, weeks, months, quarters, .
- where a specific date is higher than 18 years ago (birthdate)
I am sure you can find a lot of other examples in your own use cases.
While I agree we can filter data by code, it would be easier for Integromat or Zapier workflows to have this feature.
Laurent, web dev @ Synolia, platinum partner