Skip to main content

Good day everyone, I need some help on how to create a script coding that Fill in the state name in a table cell when a customer fills in the full address in an Airtable form. This is not linked to an Automation, just an independent script that can be run anytime to any table, that also goes with the free geo api nominatim.

Thank you.

Hmm, what issues are you facing?  Could you post what you’ve tried so far?


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 formcreate custom PDF files from a form submissionaccept 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.

    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