Was wondering if appsheet can do the following.
I have 2 google sheets as data sources.
1. Google sheet number 1 is static with specific locations and lat/longs and called Venues in appsheet.
2. Sheet number 2 is updated constantly adding incidents (with lat/longs) and called Incidents
The acceptance criteria would be When a new incident is added IF the LatLong is Within 10 miles of any of the Venues (latlong) send out notification with a link to the Venue in question in the app.
When a new location is added to data source number (incidents)
LinkedIn
Twitter
