Enrich cards with samples sent/pending + merchandise invoices (>$250, real orders) w/ fmp links + total; MERCH_MIN=250; sample SKUs shown as-is in admin details

56b2381e3063397c2cc9d47149060e5d1491c869 · 2026-07-07 14:36:05 -0700 · Steve Abrams

Files touched

M public/index.html

Diff

commit 56b2381e3063397c2cc9d47149060e5d1491c869
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jul 7 14:36:05 2026 -0700

    Enrich cards with samples sent/pending + merchandise invoices (>$250, real orders) w/ fmp links + total; MERCH_MIN=250; sample SKUs shown as-is in admin details
---
 public/index.html | 9 +++++++--
 1 file changed, 7 insertions(+), 2 deletions(-)

diff --git a/public/index.html b/public/index.html
index cd3f7a0..ee6ec24 100644
--- a/public/index.html
+++ b/public/index.html
@@ -151,8 +151,13 @@ function stripMfr(s){ return String(s||'').replace(/[A-Za-z0-9]+(?:-[A-Za-z0-9]+
 function showMfr(){ return !!document.getElementById('showMfr')?.checked; }
 const lbl = s => showMfr() ? String(s||'').trim() : stripMfr(s);
 const money = n => '$'+(Number(n)||0).toLocaleString(undefined,{minimumFractionDigits:2,maximumFractionDigits:2});
-// fmp:// deep-link that opens the invoice file to that invoice (needs a 1-line "find invoice" script named GotoInvoice; falls back to opening the file).
-const fmpInvoice = inv => `fmp://${FM_HOST}/invoice?script=GotoInvoice&param=${encodeURIComponent(inv)}`;
+// fmp:// link to the invoice file. Opens FileMaker to the invoice DB reliably today.
+// To JUMP straight to the record, add a 1-line FM script "GotoInvoice" (Enter Find Mode →
+// Set Field[Invoice; Get(ScriptParameter)] → Perform Find) then set USE_FM_SCRIPT=true.
+const USE_FM_SCRIPT = false;
+const fmpInvoice = inv => USE_FM_SCRIPT
+  ? `fmp://${FM_HOST}/invoice?script=GotoInvoice&param=${encodeURIComponent(inv)}`
+  : `fmp://${FM_HOST}/invoice`;
 
 function rowKey(list,r){ return list==='list3' ? `${r.account}|${r.sku}` : r.account; }
 function selSet(list){ return new Set(LS('sel:'+list, [])); }

← 28a382b auto-save: 2026-07-07T14:31:09 (2 files) — public/index.html · back to Dw Pitch Followup · Invoice links: enable fmp:// record-jump (USE_FM_SCRIPT=true 43c0d5a →