I’m not very clued up when it comes to the more complex features of Airtable so I’m hoping someone in this community can offer some assistance
I managed to solve part of my issue through searching these community forums here
I am using UK postcodes to determine a salesperson’s region. I have a list of these vs salesperson which can be viewed here.
I have a webform that is pulling into Airtable using Zapier so it populates the fields whenever a form is submitted. I’m now adding some extra fields to this so that our sales team can utilise the base as a leads tracker.
I’ve got as far as using a formula to assign a salesperson based on the first 2 digits of the postcode:
And that is working ok, but it leaves me with the issue of when a postcode starts with a single letter as is the case on line 5 here.
I also wondered whether it’s possible to add a collaborator based on the postcode so that they would be notified, but I think that might be a step too far vs what Airtable can actually do.
Thanks in advance for any advice I can get.