UK Postcode Area Lookup

[Sean_Robinson]

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!

[Adam_Minich · Accepted solution]

Hi @Sean_Robinson,

Adam from Airtable here.

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

share.getcloudapp.com – 18 May 21

Screen Recording 2021-05-18 at 09.16.05 AM

Shared with CloudApp

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~~

[ScottWorld]

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

[Adam_Minich]

Thanks, @ScottWorld!

[Sean_Robinson]

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