Hello! I have access to ignition through my work, and I’ve been given a project but I don’t know whether Ignition would be appropriate for it.
Scope of Project:
I need to create a system that will allow me to track battery and center ride ( don’t worry about not knowing what this is, not important) usage across my plant. There are no sensors or data acquisition devices involved with this project, all data would need to be manually inputted via google forms. The google forms would collect five pieces of data: date of battery change, time of battery change, which shift did the change, the vehicle number that the battery went into, and finally the battery’s number. I’d like to create a system where I can analyze the trends for the batteries and the vehicles.
For the Batteries
I want to count the number of times a battery appears in a 24 hour period, and if it shows up more than X number of times, automatically flag the date, time, and battery number. I should be able to choose which 24 hour period (which day) I’m looking at, so maybe a drop down menu for that?
For the Vehicles
I want to count the number of times a vehicle appears in a 7-day period. I should be able to select what week and what vehicle I’m looking at (i.e. Week 1, Vehicle B or Week 1, Vehicle C, etc.). I’d like to know what time specifically a vehicle appears as well and flag it if the difference in time between its first and second appearance is greater than Y hours.
The idea is that as a person enters data via google forms, the system will update with it. I have zero experience with Ignition, so that’s why I’m asking here if this project is even in the capabilities of Ignition. If any of that was confusing, please let me know and I’ll try to clarify.