We print 4 catalogs each year (Spring, Everyday, F...
# general
k
We print 4 catalogs each year (Spring, Everyday, Fall, Christmas). We have a custom field for each Catalog season, where we input the year (so the field CatCodeSpring would show 2023 if a particular item appeared in the 2023 Spring catalog). When building a saved search, is there a formula or easier way to look at a year's worth of catalog items, rather than having each CatCode as a separate criteria or filter field? #savedsearch ETA: This seems to be working - CASE WHEN {custitem_mhi_catalog_code_spring} like '%23' OR {custitem_mhi_catalog_code_everyday} like '%23' OR {custitem_mhi_catalog_code_fall} like '%23' OR {custitem_mhi_catalog_code_xmas} like '%23' then '1' else '0' END
a
Is this a multi select field or single select drop down?
k
It's 4 fields, one for each season. Migrated from our old system (we went live with NS this past Nov).