Dec 21, 2022 03:24 PM
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.
Dec 21, 2022 04:27 PM
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?
Dec 21, 2022 08:45 PM
You should be able to use the "Update Record in Airtable" action for this. I've included a screenshot that should help clarify things