The NF Reg Field Is the Most Underappreciated Cell in Your Weekly Routine
The NF Reg field renders a formatted string: $2.49 reg price $1.79 flyer price. One glance. No mental arithmetic, no toggling between the flyer app and your notes. Every item in this database carries that same formatted summary for all three retailers—NoFrills, Walmart, Metro—stacked in parallel sections within the same record.
That is the entire thesis. The raw price fields (NF Reg Price, NF Flyer Price, WM Reg Price, WM Flyer Price, MT Reg Price, MT Flyer Price) are hidden input cells. The rendered JS fields are what you actually read while standing in the Frozen aisle debating whether the High Liner fish fillets are worth the trip across town.
What Happens When Your Grocery Intelligence Is Scattered
The flyer comes out Thursday. You screenshot it. Then you forget which store had the Ocean Spray deal and which had the Cheemo perogies at a multi-buy minimum of 3. By Sunday morning you are standing in NoFrills with a vague memory that Walmart had the Palmolive cheaper, but you are already here so you buy it anyway. This happens every week. The cumulative cost is invisible until you actually track it.
The Department field—Grocery or Frozen—sorts your in-store route. You are not zigzagging. You pull up the filtered view for Frozen, grab everything in that section, then switch to Grocery. The Barcode field means you are not typing anything in the store; you scan, the record opens, you check quantities and prices, you move.
How the Automated Search Links Cut the Prep Time
The trigger scripts are where this template stops being a list and becomes an intelligence tool. When you create a new entry, Trigger 1 fires immediately: it reads the SKU and Website fields, concatenates them into a NoFrills search URL (website + "/search?search-bar=" + sku), and writes the hyperlink into the NoFrills URL field. The Walmart action script uses /search?q= as its query parameter. The Metro script uses /en/search?filter=. Three different URL structures, three action buttons, one entry.
This matters when a new item enters your rotation. You add the SKU from the package, set the base website for each retailer, run the three action scripts, and the search links are live. Next week when you are building your list, you tap the link, the retailer's website opens filtered to that product, and you record the current price. The whole price-checking workflow takes under two minutes per item.
The Multi Buy fields—one per retailer—display the minimum purchase quantity for the promotional price: "Minimum of 3." This is the deal-breaker field. A $1.89 flyer price on Campbell's soup means nothing if you need to buy six to get it, and you only need two.
The Buy Qty fields (Buy Qty NF, Buy Qty WM, Buy Qty MT) are your confirmed purchase quantities per store for this week's trip. You fill these once the flyer intel is in, then your shopping trip becomes execution rather than decision-making.