Help

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

Topic Labels: Formulas
1950 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Groupof7
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

Thank you!

3 Replies 3

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

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

Nice, glad I could help!