
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 14, 2021 06:12 AM
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!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 18, 2021 09:23 AM
Hi @Sean_Robinson,
Adam from Airtable here.
I made a short video for you hear describing how you might approach this:
The key is:
- A robust formula field
- Properly linked tables
- A well designed trigger that will prevent triggering the automation at an unexpected time.
Hope this helps~~

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 18, 2021 09:23 AM
Hi @Sean_Robinson,
Adam from Airtable here.
I made a short video for you hear describing how you might approach this:
The key is:
- A robust formula field
- Properly linked tables
- A well designed trigger that will prevent triggering the automation at an unexpected time.
Hope this helps~~

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 18, 2021 11:58 AM
Great video, @Adam_Minich! :cowboy_hat_face: :raised_hands:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 18, 2021 12:29 PM
Thanks, @ScottWorld!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 19, 2021 11:57 AM
Absolutely fantastic! That works just as I need it to. Thank you so much!
