Again I apologize if this is a repeat question, and perhaps someone can provide a link to a something similar if available. What I have done is create an App for new Employee Information. I created a Canvas App where the person hiring a new employee fills out the information, and this information is saved to a Dataverse table. The person hiring fills out what resources the new employee will need, i.e. Computer, dual monitor, etc. I also have an Employee Dashboard where all the information can be viewed by the original person hiring, HR, and the IT Dept.
I have created separate fields for each resource so that IT can simply go to the dashboard and change a value to indicate that request has been fulfilled. An example would be the new employee needs a computer with Office 365 installed. When the computer is acquired, IT will go in and check the Computer fulfilled box, and when O365 is installed, they can check that box off.
What I want to do is have a separate table that keeps a running log saying this person changed this record on this date at this time, which I already have. The feature I want to add is what field the person changed(if they changed more than one, that is fine, I really just want the last field they changed before they saved).
I found an article on here about a JavaScript function I can Embed into the Main Form, but all it does is display an Alert Message. In the main table I have a 'Last Field Modified' column that I want to write the last field that user changed from the Dashboard. I can populate the running log table using a flow, but I need to fill in the 'Last Field Changed' value in the main table each time anything is changed.
Any suggestions would be greatly appreciated, and I attached an image of the Employee Dashboard I created for reference. Thanks!
Kevin
