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!
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
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!
Thank you very much for pointing me in the right direction. This works!
Nice, glad I could help!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.