TL;DR - trying to determine best way to notify users as new locations come online within their specified location radius.
More context: I created Charity Makeover and am in process of building an Airtable app to enable people in other cities to run these events. It’s similar in concept to Startup Weekend only focused on building stuff for local charities. I’m essentially looking to replicate some of the functionality of Meetup in that I want to give prospective volunteers the ability to get notified when a new Charity Makeover event happens within their locale.
My question is: is there a simple way to accomplish this type of pub/sub setup with geolocation or does it need to be created from scratch? I’ve been researching terms like geofencing and proximity-based notifications to try and find some SaaS based way of accomplishing this rather than developing it. I have to imagine this is a common need with geo-based searches… Haven’t found a “packaged” way to do it yet so am now going down rabbit hole looking into GIS spatial index capability like exists in MySQL. Does the equivalent exist in Airtable? Most ideal would be a no-code way of handling this but second best would be a field type that expresses locational data and can be queried efficiently… thanks