{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Connex the Dots: The Business Optimizer","title":"The Nonprofit Grant That Started a Month Late","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/178a1720\"></iframe>","width":"100%","height":180,"duration":1552,"description":"What happens when a nonprofit wins a grant to fix its systems, but the clock starts before the team even knows where to begin?\nIn this episode, Paul Kortman walks through a real client project with a nonprofit serving 600 students a year through music and technology programs. Their data lived across a dozen spreadsheets fed by inconsistent forms, so unreliable that the same student's name could show up three different ways depending on who typed it in.\n\nPaul shows how his team built a single Airtable database by importing the nonprofit's real data as they went, instead of designing the system from scratch. That decision uncovered five years of history nobody had access to before, freed up hours of admin time every week, and let staff get back to actually running their programs.\n\nHighlights \n\n(00:00) A donor story only good data can tell\n(01:30) A grant won a year before anyone answered the phone\n(02:58) Meet the client: a nonprofit serving 600 students\n(04:32) Why nobody owned any of the spreadsheets\n(09:08) One student, three different spellings of their name\n(09:48) The real risk behind bad nonprofit reporting\n(10:25) Why nonprofits almost never get funding for this\n(13:00) Choosing a database and building it a different way\n(15:06) The four objects that ran the whole system\n(19:29) Adding a fifth object at no extra cost\n(23:31) The results: hours saved and $13,000 a year\nWant help finding a quick win like this in your own business?\nhttps://connex.digital/book/podcast","thumbnail_url":"https://img.transistorcdn.com/j_M6K9dRyz1ezNilRDhiRFF71abukeiCtsfQyk96fgY/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9jNGMz/N2NhNjViZGMzNmNh/N2MzYTdiMWUxN2Q4/OTk5Zi5wbmc.webp","thumbnail_width":300,"thumbnail_height":300}