Help building out a base

Hi everyone! Were trying to build out our company database and are stumped on a couple things.

  1. We do one invoice item by zip codes which are broken down into 8 different zones. Based on the user form input how can we match that zip code to the zone and retrieve the price for that zone.

  2. How should we setup at table for products that contain unique access codes. So the product is the same, however each client receives a code to access the prodcut after purchase, that code can only be used once. What is your suggestion on how to setup this in Airtable?

Thanks!

Hi Chafen,

  1. To better answer your first question, I need to understand how you assign the zone. Can you please explain that a bit more?
  2. For this, I recommend setting up a table where the access code is the first column or “Name” of the record. That provides a unique identifier for each record. Then use the product and client as attributes.

Let me know if you want more help on this topic or would like to work through this together.

Chris