Product Ideas and Enhancements

Allow UDF to access information from the previous record

Allow a UDF to access data from the last record for use in a calculation. For example, calculate the number of days between the Inspection Date and the Inspection Date of the previous inspection record. Would allow user to run a report showing the "elapsed time" between readings for a given facility.

Great suggestion! We have included this concept in our upcoming Axis 1.14 release. We will actually provide a system field called "Most Previous Inspection Date" that will auto-populate for locations with previously captured inspections. Creating a UDF using this field along with the current inspection date will enable you to show elapsed time in minutes, hours, days, months or years. Thanks again for the Idea and continued use of PCS!