# Can I calculate the distances between 2 tables in Glide

**URL:** <https://community.glideapps.com/t/can-i-calculate-the-distances-between-2-tables-in-glide/76080>\
**Category:** Ask for Help\
**Created:** [September 3, 2024, 4:27am UTC](https://community.glideapps.com/t/can-i-calculate-the-distances-between-2-tables-in-glide/76080 "2024-09-03T04:27:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Labor\_Coordinator](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/labor_coordinator/32/74006_2.png) [@Labor\_Coordinator](https://community.glideapps.com/u/Labor_Coordinator)\
**Post date:** [September 3, 2024, 4:27am UTC](https://community.glideapps.com/t/can-i-calculate-the-distances-between-2-tables-in-glide/76080/1 "2024-09-03T04:27:36Z")

</div>

Good evening, fellow Gliders! I need help with something relatively simple, but I’m having trouble figuring it out.

**Background:** I am working on a scheduling app that assigns technicians to various venues.

To schedule technicians (from a Technicians table), I create a schedule (on a Schedules table) that references a venue (from a Venues table). Within that schedule, I then create shifts (on a Shifts table) that reference the Schedules table. These shifts are assigned to a technician (from the Technicians table). This process works fine, and I have no problems with it.

Let me explain my issue:

To increase the efficiency of the scheduling process, I would like to determine which technicians are closest to the venue before assigning them to a shift. This way, I can list them by their proximity to the venue.

I am able to calculate the distance once I assign a technician to a shift by using the distance column with relations/lookup between the technician’s address and the venue’s address. But is there a way to reference each technician’s distance from the venue’s address without needing a Shift and Schedule table in between?

---

<div class="post-metadata">

**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\
**Post date:** [September 3, 2024, 9:23am UTC](https://community.glideapps.com/t/can-i-calculate-the-distances-between-2-tables-in-glide/76080/2 "2024-09-03T09:23:33Z")

</div>

There are several methods you could use. Without seeing your exact set up, I’d lean towards using a Single Value column to pull in current/latest Venue address. You could set a helper column (within user’s profile) with the address of current venue you’re creating a schedule for. Then, you can use the [Single Value](https://www.glideapps.com/docs/single-value-column) column on the Technicians table to pull in that address. Use the Distance column to sort the technicians!