When you fetch related records will you respect the existing order they’re in or will you want to reorder them by a field in the related table?
Will pages themselves be mapped to airtable records via their URL? Or will you use code on each page to request a specific set of records based on some other field? If you have WYSIWYG editor do you need shortcodes to fetch specific data or will you always use PHP in a template file? Will you use views to manage what’s visible online or checkboxes called ‘Enabled’ (or something similar). One of the most complex issues you’ll discover is how you should map your pages to your data. Wordpress is nice because it’s already such a full featured framework that allows for custom fields on posts and has wp_remote_get, transients, etc. I’ve integrated Airtable data into Wordpress and CodeIgniter. Regarding Wordpress vs something else, it depends on what you’re already familiar with. Simply storing data doesn’t mean you can “simply” display data.
AIRTABLE API PHP HOW TO
Creating the two fields in Airtable was easy, figuring out how to store/convert the origin/destination timezones and calculate the resulting difference was a fair challenge. Seemed easy enough but then I was asked to calculate flight duration based on those two fields.
You’ll also end up figuring out caching, error handling, date conversion, and writing all the helper functions you’ll discover you need.įor example, an itinerary management solution I created for a travel agency required departure and arrival date/times. Short of fully exposing the Airtable API to your website user, you’ll need to create some sort of “model” that translates your user requests into appropriate Airtable API calls. While querying data from Airtable and displaying it on a website is pretty straightforward, figuring out which data to retrieve and how to display it can become extremely complex. This question is basic like the tip of an iceberg is small.
0 kommentar(er)
