- Local time
- Oct 22, 2019
I helped the company of a friend of mine with the creation of a heavily customized Excel sheet where they can keep track of the invoices they've sent to their clients. It's a logistics company so they constantly have a couple hundred currently open invoices that have to be paid (mostly) as soon as they are due. As they rarely are, they hired my friend to track down those clients and get the money.
My Excel features a suite of VBA and non-VBA customizations to help them work together on the cases (case creation based on open invoice, commenting on a case-by-case basis, automatic sending of template e-mails based on current case status, and others). It's a useful dashboard and I am proud of the work I've done, but as their company grew, so did the volume of invoices and people that need to work on that file.
Back when I made it for a single person to work on their own laptop, it worked very well. Now, however, there are at least three people working on the thing at once, while the worksheet is somewhere on a shared drive located in a different country. I feel sorry for that poor Excel worksheet.
This was never supposed to be a permanent solution but they've come back to me to ask if there was a possibility of some kind of a local intranet web app. I'm 100% I could build it for them but I have 0 experience with web apps.
Are there any resources/tutorials or frameworks I can study for this type of work?