Airtable Geocoding Cronjob [Stretch] #41
Description
We need a cron job set up to run on our airtable to ensure every postcode in the database gets converted into a geocode (latitude and longitude).
We can assume that David won't be adding Geocodes and that future projects that submit their details via the form will want to just put in a postcode. We can use a cron job to check every few hours and update and projects that don't have a geocode.
- - check airtable for any missing geocodes
- - Take a postcode from project and retrieve the geocodes
- - write to the airtable the geocode details
- - schedule task to run regularly (every 3 hours)
For reference
https://github.com/alexanian/airtable-last-updated-hack