I am working with a SP 2010 list. The list is of systems that require an annual inspection. Users are able to enter their inspections to an SP Library, through an InfoPath form. That process sends me an alert that new inspections have been uploaded.
At that point I open the SP 2010 list. The list has columns that include 'Date of Inspection', 'Date of Next Inspection', 'Compliance'. I am currently performing the calculations outside of SP, using and excel spreadsheet, and then cutting and pasting that information back to the SP 2010 list, which queries the data and displays it on a user InfoPath form that allows the user to know whether a system is 'Compliant' or 'Noncompliant' with the annual inspection requirement, based on the current date.
I am looking for a way to perform the calculations in the SP 2010 list, rather than in the excel spreadsheet. Is there a process that would allow me to have an SP 2010 list perform and display the compliance calculation, rather than having to export/import the data in and out for the calculation?