Accepting vs rejecting based on airtable data

hey guys, fairly new to make and some expert advice would be incredibly appreicated.

I have a webhook thats sending postcode and suburb data to make. im trying to create a setup where these suburbs and postcodes are received, the airtable is analysed to detect for the presence of elligible suburbs/postcodes, then filtered and qualified as ‘within area’ or ‘out of area’, so the informaiton can then be passed. Im curious as to what kind of set up and modules i need to make this work.

Thanks

Hi @Josh4,

awesome! You probably have a table in airtable which contains all the postcodes and suburb data that you server/ that are valid?
I’d probably receive the data, search for the postcode/suburb in the table and if I find a value it means that the postcode is valid. If I don’t find a value, it’s outside the area that is being served :slight_smile:
You’d use the ‘Search Records’ module for this.

Does this already help you?

Best,
Richard

Hey Richard, thanks for sharing your thoughts. Right now i understand i need webhook to receive the data (postcode /suburb) –> air table search record to see if the postcode/suburb are present –> and then because im sending it to vapi i think i need to have it as JSON so it understands what its reading. How do i set it up so airtable/sees or doent see a record and then transaltes that into something i can send to vapi?

I hope that makes some sense.

I think you’ll give it some sort of trigger. This could be a select column which you change to “Check Availability” or maybe a button that you click and it sends a webhook. It really depends on your business logic in this process.
Where does the postal code/suburb come from?

Vapi has a Make App too so maybe you can simply use that? Would possibly make it easier for you than sending a JSON (also completely doable but if you’re new to Make, APIs, JSON…):slight_smile:

I’ve written an article about ways to watch changes in Airtable here.