Hi Alek,
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
Phoenix Solusi
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.