Assigning a product to a shipping box based on the product dimensions

[Groupof7]

Hi, I’m looking for some help please to write a formula that assigns a product to a particular shipping box based on dimensions of the product.

The products have a height, depth and length, The boxes have minimum and maximum dimension thresholds for height, depth and length.

How do I created a formula that assigns each product a box (or multiple boxes?) based on its dimensions?

I created a demo of the Product and Box tables:

Airtable

Product - Shipping Base - Airtable

Explore the "Product - Shipping Base" base on Airtable.

Thank you!

[TheTimeSavingCo]

Hm, I think you might be able to do this just via automations really

Here’s the documentation

You’d create an automation that would trigger in the Products table when the link to the Box table is empty, and it would have a Find Record action to find a box that would fit the product based on the size, and you’d have an Update Record action after that to link the Box record to the product

[Groupof7]

Thank you very much for pointing me in the right direction. This works!

[TheTimeSavingCo]

Nice, glad I could help!