You can play with it on their API playground and figure out how to use it. Basically, they represent a list of financial transactions, with their purpose (whether they were donations, material acquisition, etc), their date, and their value.Īirtable automatically generates an HTTP API for each table. The table labels are in Portuguese, translated to English they are: ID, Purpose, Date, Value. Next.js will automatically pick up that value from your. env file with this content: AIRTABLE_API_KEY=api_key To even make it more secure, we created a user that only has read-only access to the respective base.Īfter getting the API key, just create a. If an evil thief gets access to it, all of my bases would get compromised. Each base is basically a project on Airtable so, that way, I avoid using my own API key. I recommend that you create an Airtable bot user, a separate account with access just to the base you need. Then we just need to get an API key on Airtable, you can follow this guide on how to get there but just look for it on your account settings. With Next.js it's pretty easy to integrate with Airtable. We are working with the volunteering team to migrate every single data piece to Airtable (except the copy of the website, which will be kept on Forestry). Currently, the transparency report is being imported from the Airtable, the rest is managed on the CMS side. Show me the code!ĭisclaimer: not all of the Airtable data could be used on the Website. As the site is static, costs would be non-existent or pretty low, and we would not be rate-limited by Airtable at all. Then we would just deploy everything from Github to Netlify. We still plugged in Forestry, a git-based CMS, so the team could edit the website's copy easily. Next.js static site generation abilities were also a factor in choosing it, as we didn't want to manage (and pay for) dedicated hosting. ![]() So, we decided to build the website with Next.js, as most of the developers that volunteered to help had React experience. Unbeknownst to them, Airtable could solve most of these problems directly, because Airtable itself would generate HTTP APIs for each of the tables they had, and we could directly fetch the data from there. The team at the time was hoping that we could set up a CMS to power the website's data and copy, and they would copy over manually some of the data from Airtable to said CMS. What they needed was a simple marketing landing page, with some stats that represented the actual progress of the movement. The volunteers were using Airtable to manage inventories, deliveries, and also transparency reports regarding financial movements, which are required to be public by Portuguese laws. They connected donators of either money or materials, to the organizations in need, handling all of the logistics. ![]() Their operation was relatively simple, in theory at least. They needed a website to help spread awareness of the MinhoCovid19 movement, a group of people trying to supply organizations in need (nursery homes, hospitals, etc) with protective materials built by volunteers. Back in June, we received a request to help build a website for an academic non-profit organization (our friends at AAUM), in Braga, Portugal.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |