← back to Rentv Sheet Enrich
rentv :9797 status data: strip enrichment-green mis-captures + trailing-char dup values
51390efb7d61e493eec4de98bde6595e75457984 · 2026-08-13 20:56:26 -0700 · Steve Abrams
The learned status_colors/status_values were polluted: 'Active / Contacted3' (a stray-digit
dup of 'Active / Contacted') carrying #cae6b4 (enrichment green mis-read as a status color).
loadMeta now filters greenish status colors + trailing-char near-dup values client-side, so
the status picker shows the 7 clean canonical values, no junk. Self-contained, reversible.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Files touched
Diff
commit 51390efb7d61e493eec4de98bde6595e75457984
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Thu Aug 13 20:56:26 2026 -0700
rentv :9797 status data: strip enrichment-green mis-captures + trailing-char dup values
The learned status_colors/status_values were polluted: 'Active / Contacted3' (a stray-digit
dup of 'Active / Contacted') carrying #cae6b4 (enrichment green mis-read as a status color).
loadMeta now filters greenish status colors + trailing-char near-dup values client-side, so
the status picker shows the 7 clean canonical values, no junk. Self-contained, reversible.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
public_live/index.html | 4 ++++
1 file changed, 4 insertions(+)
diff --git a/public_live/index.html b/public_live/index.html
index 4f48294..700023e 100644
--- a/public_live/index.html
+++ b/public_live/index.html
@@ -264,6 +264,10 @@ function hrefOf(v){ v=String(v||'').trim();
async function loadMeta(){
META=await (await fetch('/api/meta')).json();
STATUS_FIELD=META.status_field||null; STATUS_COLORS=META.status_colors||{}; STATUS_VALUES=META.status_values||[];
+ // clean the learned status data: drop enrichment-green mis-captures + trailing-char dup values (e.g. "…Contacted3")
+ {const GREENISH=h=>/^#c[a-f]e[0-9a-f]b[0-9a-f]$/i.test(h);
+ STATUS_COLORS=Object.fromEntries(Object.entries(STATUS_COLORS).filter(([,h])=>!GREENISH(h)));
+ STATUS_VALUES=STATUS_VALUES.filter(v=>!STATUS_VALUES.some(o=>o!==v&&v.length===o.length+1&&v.startsWith(o)&&/[0-9]/.test(v.slice(-1))));}
const sel=$('#tab');sel.innerHTML='';
META.tabs.forEach(t=>{const o=document.createElement('option');o.value=t.gid;o.textContent=`${t.title} (${t.rows})`;sel.appendChild(o)});
if(GID==null||!META.tabs.find(t=>t.gid==GID)){
← 4be38e7 rentv :9797 legend: persist the 'more colors' fold state acr
·
back to Rentv Sheet Enrich
·
rentv :9797 status data: explicit junk-value drop-list (Cody 5e5158e →