I created a custom Sharepoint app which our business uses to track projects. I'd like to add to columns to one of the tables, one for last modified and one for last modified by (that will show who changed it last based on login). I figured this would be simple but I can't seem to figure it out.
Can anyone steer me in the right direction?
Every SharePoint list includes CreatedBy, Created, Modified, and ModifiedBy fields by default -- because they are part of the base Item content type. They perform precisely the behavior you're describing.
If you are looking to access them from any of the client APIs the user entities are named Author and Editor respectively, but the date fields are still called Modified and Created
If you're using the REST API you'll have to do something like $select=Editor/Title&$expand=Editor
The CSOM APIs will bring back those values automatically with a request for list items, you just have to use something like item.get_item("Editor").get_lookupValue() to get the users name (note this is a JS Example, although the C# version would be very similar)
