I have recently begun my coding journey here for a specific reason; I am trying to solve a problem at work.
I work in clinical research and we have multiple studies with different requirements, labs, visits, etc. I know pretty advanced coding in excel which has allowed me to create inventory, patient tracking, and scheduling spreadsheets, and have them communicate with each other, but it feels like a temporary fix.
What I would really like to do is be able to build a desktop app (we use Windows) that contains a database of patients with their information, functions to be able to schedule them, and an inventory function. For instance, right now I have an inventory spreadsheet that communicates with the patient tracking spreadsheet so when we schedule a patient for a visit, we will know if we have the necessary kits.
I’d like to be able to add multiple studies and define the number of visits, when they should be, and be able to assign patients to those studies.
This will sort of work something like a CRM/study management/project management application, and I understand it’s a BIG undertaking, and could take me a long, long time to learn what I need. That’s why I’m wondering where to start.
I’ve learned some C# and it’s come pretty easy to me, I’m almost through the Learn C# course here. When I ask my friend who has a CS degree what I should be learning, he said C# is a good start but there would be probably a few different languages/technologies I would need to learn to be able to build something like that.
This is something I am doing in my free time and don’t expect it to come quick, but I love what I’ve been learning so far, I didn’t realize how much I would enjoy learning this.
Any direction would be helpful! Thanks in advance!