Skip to main content

A number of other services that I've worked with (Tadabase, Knack, SmartSuite to name just three) have a field type called 'Address'. This streamlines the entry of addresses (by autocompleting) and at the same time validates the address. Is it possible to do this in Airtable? There's an extension in the extension "store" called LOB but I can't get it to work. And that's it. Is there a way to use a Zapier automation for example to do the validation at least, even if it's not possible to help with autoentry?

This is a huge deal for my users, who spend a lot of time entering addresses — often making mistakes that cause problems down the road. 

I just used Zapier to link one of my bases to BytePlant's Address Validator tool. It seems to work when I test it in Zapier: I get an "OK" response in the Zapier zap editor (at the end of the action). But I can't figure out how to capture that value and bring it back into Airtable. I have not used Zapier a lot and don't think I've ever used it for a "round-trip" automation, where I data from Airtable to an external service, and get a response back. Can anybody please throw me a clue? 

I just used Zapier to link one of my bases to BytePlant's Address Validator tool. It seems to work when I test it in Zapier: I get an "OK" response in the Zapier zap editor (at the end of the action). But I can't figure out how to capture that value and bring it back into Airtable. I have not used Zapier a lot and don't think I've ever used it for a "round-trip" automation, where I data from Airtable to an external service, and get a response back. Can anybody please throw me a clue? 


You should be able to use the "Update Record in Airtable" action for this.  I've included a screenshot that should help clarify things

You have 2 very easy options for this:

  1. For auto-completion of addresses WHILE USERS ARE TYPING ADDRESSES into Airtable, your best bet for this is to use Fillout’s advanced forms for Airtable, which offers Google Maps Autocomplete.

    Fillout also offers hundreds of other advanced features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, display Airtable lookup fields on forms, create new linked records on a form, control access to a form via SSO or email domains or a list of email addresses stored in Airtable, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

    I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

    • Using Fillout to create an eSignature approval process with PDF file creation
    • Using Fillout to create an order entry form with line items.
     
  1. For address validation AFTER ADDRESSES HAVE ALREADY BEEN ENTERED INTO AIRTABLE, your best bet is to use Make’s Byteplant Address Validator, which can easily be integrated & automated with Make’s Airtable automations & integrations.

    You mentioned Zapier in your post above, but I would STRONGLY recommend AGAINST using Zapier. Make is INFINITELY more powerful & customizable than Zapier, yet it is SIGNIFICANTLY CHEAPER than Zapier. I wrote an entire post here comparing Make vs. Zapier. If you've never used Make before, I've assembled some Make training resources in this thread.

    If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.

Hope this helps!

If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hey 👋

I am probably a bit late but I am sure it might be helpful for others in the future.

Here is a plugin I built to handle address autocomplete in Airtable.

You just need to connect your Airtable account, then select your base, table and address fields.
The plugin will then give you a "formula" that you can put inside of a button.

It uses Google Autocomplete API so it should work worldwide with a good accuracy

Hope it might be useful to others!

Terms & Conditions