Rent equipment by lot or by unit

1549 3
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there,

I need to organize rental of equipment by lot and by unit. The use of the lots are to make it faster sometimes to rent a batch of equipment that is often rented together. The difficulty is that the units in the lots can also be rented by unit (the units can be divided).

I’m having trouble wrapping my head around this. I have tried to 2 solutions, none being really satisfactory.

To start with, I have a table for the Equipment and one for the Rentals.

Trial #1
In the Equipment table, I created a “Lot” field and filled it for each item of equipment.
The problem with this configuration is that I can’t find a way to select the lot from the Rentals table and that I have to add every unit of the lot one by one.

Trial #2
I created a table for the Lots and linked it to the Equipment table with multiple entries.
Then I added a field Lot in the Rental table. The problem in that configuration is that I didn’t find a solution to make sure we would know in the Equipment table what units are then rented.

I hope this is clearly explained, it’s always hard to take a step back when you’re elbow deep in the project.

Do not hesitate to ask precisions if needed.
I would love to hear from you guys!

3 Replies 3

Hi @Claudia_Leduc - does this work for you?:

I have an “items” table and a “lots” table:

Screenshot 2019-06-18 at 08.40.35.png

Screenshot 2019-06-18 at 08.40.43.png

Lots and items are linked. I’ve also got a “rentals” table where you can choose an item to rent OR a lot to rent:

Screenshot 2019-06-18 at 08.43.16.png

With some lookups, rollups and formulas on the Items and Lots tables, I can show when an item has been overbooked at the item level (same item twice), at the item + lot level or the same lot twice.

Screenshot 2019-06-18 at 08.47.37.png

You can also see if an item or lot is currently rented (“not available”) or not.

Hope this helps


Wow, thanks a lot Jonathan. Will definitely look into this!

Ho this is great, I helps me a lot!
Thanks so much JB!