Designing a Repeater to show a field only once per grouping

Ask the community
,
1

Hi everyone, I’m building a menu page that displays a database [“Brand”,“Category”,“Flavor”,“Description”] and I have another database that includes all the brands. I was able to build a repeater that displays all the info, but I don’t want to display the Brand for every list item. Instead, I want all the items in the database to be grouped by the brand. Is this possible to do without a filter?

In the image I posted, “Juice Man” should only appear at the top of the list, and all the flavors that correspond to “Juice Man” should be listed under that. Once the next brand appears, then the title should re-appear.

335×758 11.6 KB

2

Yes, can be done, you need to compare current description with the one above and if the same, clear the description, like so (piece of my own code inside a repeater):

// level break on descripton
 if (index > 0) {
 const data = $w('#repeater1').data;
 //          console.log("data in onitemready=" + JSON.stringify(data));
 if (data[index - 1][strUnitDescr] === itemData[strUnitDescr]) { // if last one is same as this one
                $item('#txtUnitName').text = ""; // don´t show it
            } else {
                $item('#txtUnitName').text = itemData[strUnitDescr]; // else do show it
            }
        } else { $item('#txtUnitName').text = itemData[strUnitDescr] } // and always show first one (index 0)