I mentioned in my last post (six months ago) that I was taking a break and working with an NGO as part of my Masters in Public Administration program.
As it would have it, I ended up on a SharePoint Online / Office 365 project. Of course, I could have taken on the development myself but decided that it made more sense for the NGO to take on a local company to impelement the custom SharePoint development. I have managed many software development projects in the past and thought that this would be a breeze.
I am taking a few months off from coding and working on a research project with an public health NGO in India to fulfill a requirement for a graduate degree program. At this organization, there are at least a half dozen people hired to do what might be considered low paid, menial jobs.
As you may know, a Google Docs Spreadsheet acts almost exactly like Microsoft Excel but is completely web-based. In addition, it automatically saves the changes to a cell once the user has exited the cell. So the features that I am going to demonstrate are:
- Creating the basic html table
- Highlighting editable cells when moused over
- Adding a textbox to make cells editable
- Making the textbox invisible
- Adding an MVC Action method to save the changes
- Report that the changes were saved
I have been doing SQL development for at least 15 years now but with the advent of Object Relational Mapping (ORM) frameworks like ADO.NET Entity Framework, I have had to write fewer complicated queries in recent years.