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:
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