function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
iaestemaniaesteman 

Compare 3 fields with one other and print value

Hi,

I have 3 fields on one product family called Furniture

User-added image
 

  • Fab.Req m(130) : 4.3
  • Fab.Req m(140) : 4.0
  • Fab.Req m(150) : 4.0
and I have a field on different product family called Fabric
  • Fabric Width: 140

What I want to do is compare the field Fabric Width with the 3 other fields labels and based on that label the defined value to be showned.

How can i achieve this ? Is it possible to do it with a formula?

Thanks,

Darko

RD@SFRD@SF
Hi Darko,

Is there a link between both the product family?
iaestemaniaesteman

Hi RD@SF,

Both are Products under same object Products and they have different product families: Furniture and Fabric.

I want to achieve this in a bundle so when i pick a furniutre product it will filter all fabrics that are in that coleration above.