The Effective Capacity can only take numbers it cannot take text, what i was looking for was a field that can take a text entry. The fields that I am after in addition to what you have are
- Product type - text field , indicates the product that the vehicle is carrying eg Petrol, HCL, Caustic Soda Liquid, General Freight etc
- Max Gross Weight (Kg) - numeric field, this is the total weight of the fully loaded vehicle. The vehicle and its load cannot exceed this value
- Tare (Kg) - numeric field, this is the unloaded weight of the vehicle.
- Net Weight (Kg) - numeric Field, this is the maximum weight that can be loaded on to the vehicle
I would like to be able to filter by product type so in the unit list for example show all vehicles that are used for product type Petrol or have a Tare above 4500kg.
The same with the reports, I want to see for example the trips for all of the vehicles that were carrying Petrol as a product type for the last three months. Or, show me the Eco Driving reports for all drivers that drove vehicles that carried Petrol or Diesel in the last 6 months
Let me know if you need more detail
Mobile Visible Secure
Specialists in data acquisition and analysis for mobile and fixed assets. Integration in to content management systems is a specialty we have.