Nightly database normalization: consistent statuses, filled-in fields

Every night the scenario brings your records to a consistent shape: fixes statuses, builds short keys, fills in empty fields and logs a run summary.

  • One status, one spelling — no more 'in progress / WIP'
  • Only the records that need fixing are touched
  • A run summary stays in the database
  • Runs at night — clean by morning
Notion