Tagging products by hand works fine on day one. But a week later, nobody remembers to remove the "New Arrival" label from something that's been sitting on the shelf for a month, and a genuine discount goes unnoticed because whoever entered the price forgot to also check a box somewhere else.

In this tutorial, we'll build an Auto-Tagged Product Catalog — a table that labels each product as "New Arrival," "On Sale," or both, based purely on when it was added and whether a discount price is set. No one has to remember to tag anything ever again.

---

Table Columns

Here's what we're working with — a Product table with a Name, Image, Price, Discount Price (optional), and Date Added field.

Product table columns showing Name, Image, Price, Discount Price, and Date Added fields

---

Step 1: Add Your Products

Add a handful of products with different Date Added values and Discount Price statuses, so we can see how the tagging behaves once it's built.

Product table populated with sample products including a candle, a backpack, and a water bottle

For this walkthrough, assume today is August 24, 2026, and we have:

• Cedarwood Candle — added August 20, 2026, Price $22, no Discount Price set
• Trailblazer Backpack — added June 1, 2026, Price $60, Discount Price $45
• Steel Water Bottle — added July 15, 2026, Price $18, no Discount Price set

Right now, none of these products say anything about themselves — you'd have to remember which one is new and which one is discounted just by looking at the raw fields.

---

Step 2: Flag New Arrivals

Since a plain column can't be converted into Custom Logic after the fact, create a brand new column and set its type to Custom Logic from the start.

Adding a new Custom Logic column for the New Arrival flag

Describe the rule — if Date Added is within the last 7 days from today, mark it "New Arrival"; otherwise leave it blank.

Describing the logic to flag products added within the last 7 days as New Arrival

Confirm the clarification screen, checking that it measured "last 7 days" against today's date, not a fixed date.

Clarification screen confirming the rolling 7-day window logic for New Arrival

Save it, and the flag fills in instantly:

• Cedarwood Candle → New Arrival
• Trailblazer Backpack → blank
• Steel Water Bottle → blank

Product table showing New Arrival flag filled in only for the Cedarwood Candle

---

Step 3: Flag Items on Sale

Add a second Custom Logic column. Describe this rule separately — if Discount Price is filled in and is lower than Price, mark it "On Sale"; otherwise leave it blank.

Describing the logic to flag products with a Discount Price lower than Price as On Sale

Confirm the clarification screen, checking that it treated an empty Discount Price as "not on sale" rather than as zero.

Clarification screen confirming the On Sale condition checks for a filled and lower Discount Price

Save it, and the second flag fills in too:

• Cedarwood Candle → blank
• Trailblazer Backpack → On Sale
• Steel Water Bottle → blank

Product table showing On Sale flag filled in only for the Trailblazer Backpack

---

Step 4: Watch the Catalog Relabel Itself

Let's test both flags reacting to change at once. Add a brand new product, Canvas Tote Bag, added today, with Price $25 and Discount Price $18.

Adding a new product Canvas Tote Bag with today's date, regular price, and discount price

The moment it's saved, both flags apply themselves without you touching either column:

Canvas Tote Bag → New Arrival and On Sale, simultaneously

Canvas Tote Bag showing both New Arrival and On Sale flags applied automatically

Now let's check the other direction — what happens once a product ages out of the "new" window. Edit the Cedarwood Candle's Date Added, moving it back from August 20, 2026 to August 10, 2026, simulating what it would look like 10 days later without needing to wait for time to actually pass.

Editing Cedarwood Candle's Date Added field to a date more than 7 days in the past

Cedarwood Candle changes from New Arrival → blank, immediately, with no one touching the flag itself.

Cedarwood Candle no longer showing the New Arrival tag after its Date Added moved outside the 7-day window

---

Step 5: Build a View for What's Currently Promotable

Tags are only useful if you can act on them quickly. Create a new view, filter where New Arrival is not blank or On Sale is not blank, and save it as "Feature on Homepage."

Saved filtered view named Feature on Homepage showing only products flagged as New Arrival or On Sale

Now marketing can open one view and immediately see everything worth promoting today — nothing stale, nothing missed.

---

Recap

1. A Product table with Price, Discount Price, and Date Added
2. A Custom Logic field flagging New Arrival based on a rolling date window
3. A Custom Logic field flagging On Sale based on the presence of a lower Discount Price
4. A live demonstration of tags applying and expiring without manual edits
5. A filtered view surfacing everything currently worth promoting

This same self-tagging pattern applies well beyond retail catalogs — flagging overdue tasks, highlighting recently updated records, or marking anything that only matters within a specific time window can all be built the same way.