I am using airtable for invoicing for a transportation company, and we bill by mileage. Ultimately, when billing, I want to be able to choose an origin point from a drop down, choose a destination from another drop down, and have airtable fill in the number of miles between the two locations in a third field.
I’m a bit of an airtable newbie, so I’m struggling to figure out how to set this all up. My current base is set up as follows:
Table containing a record for each item/route to be billed
Table for customer information
Table for invoices
Currently I am typing in the number of miles for each item to be billed. The routes we run have a finite number of origins and destinations, so it feels feasible (if a little arduous) to calculate up how many miles there are between each origin and each possible destination and store them in a table. I’m just not sure how to set that table up and how to connect it to my first table, especially by being able to select the origin/destination via dropdown.
Any help would be very appreciated!