Hello, I have a seemingly simple question that I’m struggling to solve. I want to count records meeting certain criteria - for example, how many records generated within the current month.
(the end goal is for records to have an autogenerated field that is year.month.sequentialnumber – the year and month are easy, the sequential bit should be a simple matter of # existing records + 1…)
If all those records shared a common link to another table, I know I could use that to generate a conditional “count all” rollup field. But it seems totally redundant to make a separate table, with a single record, and link all my original records to that, JUST to obtain my number.
Isn’t there any other way?
NOTE: so far my Airtable usage has not required me to learn scripting. Very open to it, if that’s an option, but - go easy on me…