Skip to main content

Image formulas: Check whether S/B/T is set for a specific image

To find out if the second image has the options small/base/thumb set, we need to create 6 different columns, each with a different formula. How these columns have to be named and which functions the formulas have is explained here:

1. Thumbnail image | Formula: =BILD.HOLEN([@Bilder];1)

  • Function: gets the image with thumbnail set. Needed for comparison, more on that later.

2. Small image | Formula: =BILD.HOLEN([@Bilder];2)

  • Function: gets the image where Small Image is set. Needed for comparison, more on that later.

3. Base image | Formula: =BILD.HOLEN([@Bilder];3)

  • Function: gets the image where Base Image is set. Needed for comparison, more on that later.

**1. All images ** | Formula: =BILDER.HOLEN([@Bilder])

  • Function: retrieves all images of the product. Is needed to locate the 2nd image of the product. (see next column)

1.1 Image from "All images" | Formula: =TEIL([@[Alle Bilder]];SUCHEN(";";[@[Alle Bilder]])+1;SUCHEN(";";[@[Alle Bilder]];SUCHEN(";";[@[Alle Bilder]])+1)-SUCHEN(";";[@[Alle Bilder]])-1)

  • Function: This formula returns the value between the first and the second semicolon, i.e. the second image.

2. Is set? | Formula: =UND([@[Thumbnail Bild]]=[@[2 Bild von ''Alle Bilder'']];[@[Small Bild]]=[@[2 Bild von ''Alle Bilder'']];[@[Base Bild]]=[@[2 Bild von ''Alle Bilder'']])

  • Function: The last formula compares the columns (small, base, thumb) with the second image to make sure that all 3 options are set. This way, the image name is used to check if the same image is present everywhere. If yes, then you get TRUE back, otherwise FALSE.