Hello! I have a field in every record for zip code (number field) I am looking to have a sheet to count up how many records I have in a specific zip code. Interfaces can give me a chart on the zip count but I can not figure out how to get a table of it. I can group by zip code in the table by I need that data in it’s own table.
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?