Welcome to Catalog Tips
Search more than 200 articles to learn more about creating and automating your product catalogs
Tip: Start typing in the input box for immediate search results.
GROUPISLAST – Identify last n records
Overview
This Custom Field returns TRUE for a record in the last n positions of a group.
Syntax
GROUPISLAST(GroupPath,SortField,Positions)
| Element | Description |
|---|---|
| GroupPath | Group path delimited by colons. |
| SortField | Field used to sort records by within the group. |
| Positions | Optional field. The number of positions to be recorded. Defaults to 1. |
Examples
GROUPISLAST(Parent Category:Child Category,Colour,2)
| Colour | GROUPISLAST |
| Red | FALSE |
| Green | FALSE |
| Red | TRUE |
| Yellow | TRUE |
GROUPISLAST(Parent Category:Child Category,Colour,3)
| Colour | GROUPISLAST |
| Red | FALSE |
| Green | TRUE |
| Red | TRUE |
| Yellow | TRUE |
EasyCatalog Panel Example
GROUPISLAST(Category1ID:Category2ID:Category3ID:CollectionID,Colour,2)
Records 7 and 8 return TRUE as they are the last 2 items in the CollectionID group.
| # | ProductInstanceID | Category1ID | Category1Name | Category2ID | Category2Name | CollectionID | CollectionName | ProductID | ProductCode | ProductName | Colour | Height | Width | Price | GROUPISLAST |
| 1 | 2344 | 23 | Hardware | 454 | Brass | 2767 | xxxx | 15068 | A1234 | 16mm screw | Red | 25 | 3 | $1.50 | TRUE |