An internal website gives people inside an organization one shared place to find and use the information needed for a specific part of their work. That is exactly what I wanted to create with ChatGPT Work and Codex.
Our 13-person department manages 2,369 material records, updated monthly and still growing. Previously, checking one component took about five minutes. People had to search different files, verify descriptions and prices, compare the latest price with previous records, and repeat the same calculations. These small tasks added up across every person, component, and month.
I described our real workflow, data structure, and business rules to Codex in plain language. I shared screenshots, reviewed each version, pointed out incorrect matches, and kept refining the experience based on how our team actually works.
Together, we built “Baibaoxiang” (“Toolbox”). Its stable V97 version has become a practical inventory and price tool for our daily work.
V97 brings all 2,369 records into one consistent interface. Teammates can search for materials instead of manually checking multiple spreadsheets. Even when columns arrive in a different order each month, the app recognizes the corresponding fields and organizes them correctly.
For each material, we can review its description, latest price, price change, previous price, unit price, category, lifecycle, EOM, EOP, EOS, and other available information in a consistent order. Historical price and trend views show changes over time, including increases or decreases in both amount and percentage.
The dashboard summarizes the latest data and changes from the previous period. Search, selection, filtering, field visibility, and price-color settings help different users focus on the information relevant to their work. Release notes record each version, date, and update so the team always knows what changed.
Most importantly, V97 is a standalone HTML file. It requires no installation or server, and its dependencies are embedded for offline use. We can open it without an internet connection and share the working version with the people who need it.
Its real value is not one feature, but how the features work together to reduce repeated searching, matching, checking, and calculation. A lookup that once required several files and about five minutes can now be completed through one consistent interface. Everyone sees the same structure, price comparisons are clearer, and the time saved multiplies across the whole team.
V97 was already stable and useful. V98 is simply an extra improvement built on that foundation. Before going to sleep one night, I wondered whether the same price lookup could work naturally on a phone. That idea led to a mobile-friendly interface for meetings, travel, or any moment when opening a computer is inconvenient. Offline support means a weak network does not stop the lookup.
Codex has become part of how I work. I use it remotely during the workday and continue improving the project at home. I even bought a monitor and a Mac mini to make this workflow more efficient.
My biggest lesson: start with one clear, recurring problem. Describe the real workflow, preserve the important business rules, review every result as a user, and improve it through practical feedback. A focused internal tool that saves a few minutes on one repeated task can create meaningful value for an entire team.
#ChatGPTWork #Codex #ChatGPT
Sending lots of love to the Apple community on my last day as CEO. My title changes tomorrow, but the love I have for the Apple community never will. Thank you for being a constant source of inspiration. My gratitude is endless, and I’m excited for the next chapter!
Sending lots of love to the Apple community on my last day as CEO. My title changes tomorrow, but the love I have for the Apple community never will. Thank you for being a constant source of inspiration. My gratitude is endless, and I’m excited for the next chapter!