I’m juggling spring palettes where peonies vanish by week 22, and I need a clean way to track stem counts and auto-suggest substitutions (e.g., Icelandic poppies to ranunculus) by color and season… Has anyone compared Details vs Curate for this, or found a Notion/Airtable setup that handles 60cm vs 40cm rose pricing and waste? I care about the look first, so seeing recipe-to-palette visuals alongside availability would be a dream.
40cm rose pricing and waste? I care about the look first, so seeing recipe-to-palette visuals alongside availability I handle this in Airtable by making length-specific SKUs with waste% and week ranges, then a gallery view next to the recipe shows in-season, color-matched swaps. Small caveat: Details does cleaner one-click substitutions if you don’t want to build it — do you need per-vendor 40/60 pricing too?
Short answer from my side: I’m seeing the same pattern — one concrete thing that helped was writing down the exact handoff and timebox it to 15–20 min. Does that match what you’re running into?
Details nails the recipe-to-palette view, but for true auto-swaps I’ve had better luck in Airtable: link each variety to a Substitutes table filtered by Color family + Season window and use WEEKNUM({Event Date}) so peonies past week 22 auto-surface ranunculus/poppies by price and stem length. Curate’s counts/purchasing are solid, but color-based suggestions felt manual for me. Want the tiny formula + length-SKU fields I use, @danielle_s88?
Set a ‘Week 22’ blackout for peonies, then auto-swap by color + stem length; add 10% waste on 40cm roses.
I’d stop chasing exact stems and map each flower to a ‘visual unit’ (e.g., 1 garden rose = 1, peony = 1.2, ranunculus = 0.4) so when peonies vanish in late May the swap keeps the silhouette, not just the color. In Airtable I multiply counts by that ratio and recalc cost by grade (60 vs 40) with separate yield/waste; a view surfaces the top 2 substitutes by season — @danielle_s88’s relation setup plus a vendor lead-time tiebreaker. Want it to auto-apply or pause for approval?