Ever need to get the count of how many records are from a given year? Or quarter? Or month? Take a look at this sample base that uses a few formulas and a simple Automation to automatically link records from one table (i.e. "Log") to all the relevant report records in a dedicated table.
​
Since records are linked to one or more report records, you can use apps like Page Designer or Documint to export all the records from "October 2021" in a PDF! Plus, you can make use of Airtable's native Lookup and Rollup functionality to get the sum, count, or average of data across your chosen time intervals!
​
The base comes with a Log table which can be adapted to be whatever you need it to be (customer interactions, sales transactions, etc.) and has a single formula ({Report Period(s)}) that converts a date field into a string of relevant time periods. When you load the base the formula will output any valid date into its year, quarter, month, and week. This formula can be customized to add or remove time intervals that you need (and a Script App is included to help you create the relevant formulas as well!).