Help

Re: UK Postcode Area Lookup

Solved
Jump to Solution
863 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Sean_Robinson
4 - Data Explorer
4 - Data Explorer

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!

1 Solution

Accepted Solutions
Adam_Minich
Airtable Employee
Airtable Employee

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

See Solution in Thread

4 Replies 4
Adam_Minich
Airtable Employee
Airtable Employee

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

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

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