EasyCatalog’s Furniture features allow you to populate a box with data for the first or last item on a page after pagination. Sometimes, however, it’s necessary to display both the first and last records in the same furniture box. To do this, custom fields must be created to determine which records are on the page and pick out the first and last.
- Create a new custom field that can be updated with the page number each record is placed on.
- Create a custom field that will pick out the first record for each page:
1 | GROUPFIRST('Page','Manufacturer','Manufacturer') |
- Create a custom field that will pick out the last record on each page:
1 | GROUPLAST('Page','Manufacturer','Manufacturer') |
- Finally, create a custom field that will concatenate the ‘first’ and ‘last’ fields together if they’re different, or just the ‘first’ field if they’re the same:
1 | IF(FIELDSTR(FirstOnPage),=,FIELDSTR(LastOnPage),FIELDSTR(FirstOnPage),CONCAT(FIELDSTR(FirstOnPage),' - ', FIELDSTR(LastOnPage))) |
- This final custom field is the one that should be used in your master page’s furniture:
- After pagination, the ‘Page’ field needs to be updated with the page number each record is placed on:
- Now, the furniture needs to be updated using the “Update Furniture” option. Scripting Module customer can automate this process so that the page number update and the furniture update are automatically executed after pagination.