Count Records By Zip Codes

Hi JJ, if I were you I’d duplicate the zip code number field, and then convert the duplicated field into a link field to a new table. Then I’d create a “Count” field to get the count

I’ve set it up here for you to check out

Thank you for setting this up to show! My concern is getting the records into the count field. I would have to add each record with that zip code? I have thousands of records and always adding more daily. I am looking for a way for them to automatically add them or count them?

Hey JJ, we could do this with an automation that pasted the value from the zip code field into the linked field maybe? Depending on the Airtable plan and how many zip codes we enter a month, this may not work though; for example, the free plan only has 100 automations a month

Unfortunately, I don’t think there’s any other way to have this data automatically counted and output into a table. I guess we could possibly change the workflow to populate the linked field instead of the number field, but just imagining doing that makes me tired

If you only need to see the counts and don’t need to manipulate them, maybe we could use the pivot table app?

l with the HMH Reading Counts