← All Tools
fat.silverfam.net
Flight Advocacy Tracker · v3

Lead → Case Converter

Convert a qualified Lead into a Case and create the initial External Claim.
⚙ Settings & Credentials
Stored in localStorage. Never transmitted except to api.airtable.com.
No PAT configured.
1
Look up Lead
Format is typically PNR-N (e.g. HOBJOC-1).
2
Review & Edit Case Details
Auto-filled from Lead
Manual entry needed
Flight & Booking
Will be matched to Airlines table on submit.
Used to derive compensation tier.
Disruption
Only if Delayed/Diverted.
Case Management
Hold Ctrl/Cmd to select multiple. Linked to Countries table.
The jurisdiction currently being actively pursued.
Auto-calculated by Airtable formula. Shown here for reference only.
Deadline for the next action on this case.
Expected Compensation
EC261: <1,500 km → €250 · 1,500–3,500 km → €400 · >3,500 km → €600. Auto-fills when distance changes.
Notes
3
Initial External Claim
Defaults to operating carrier if found in the table.
Creates a Case record, updates the Lead to Converted, and (if checked) creates the initial External Claim — all in one step.
--:--:--Ready. Configure PAT and load a lead to begin.