UK Postcode Area Lookup

I’m from the UK, I want to store contacts including their post code. I want to somehow have the table display the area in which the contact lives based off the first part of their postcode. So for example if I have John Smith who lives in PL5 9KG, I want a formula to display only the ‘PL5’ part of his postcode, and then somehow have the next field then look this PL5 up in another table and then display ‘PLYMOUTH’. This would need to work for other, longer post codes too like PL21 or TR58. I already have the formula "LEFT(Postcode,4) to get the first 4 characters of the postcode field (Including the space if it’s only 3 characters at the start), but that’s as far as I have got.

I have looked at various threads on here but can’t seem to work it out!

Hi @Sean_Robinson,

Adam from Airtable here.

I made a short video for you hear describing how you might approach this:

The key is:

  1. A robust formula field
  2. Properly linked tables
  3. A well designed trigger that will prevent triggering the automation at an unexpected time.

Hope this helps~~

2 Likes

Great video, @Adam_Minich! :cowboy_hat_face: :raised_hands:

1 Like

Thanks, @ScottWorld!

1 Like

Absolutely fantastic! That works just as I need it to. Thank you so much!

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.