Database Connect for Work Request Screen

Manager SE Settings, Defaults, Database
Locked
krismj
Member
Posts: 2
Joined: Wed Mar 26, 2014 8:28 am

Database Connect for Work Request Screen

Post by krismj »

We are looking to potentially purchase Mitchell1's Manager SE. Prior to that decision we need to know if we can build a work request screen, access the database tables and use them in the work request then process them into a work order.

The other question I have is whether everything that goes into SE needs to be a vehicle or can we use it for our "random" equipment as well (forklifts, Kubota's, mowers, etc)?
KGA
100 Club: Active Contributor
100 Club: Active Contributor
Posts: 121
Joined: Wed Apr 03, 2013 9:49 am
Location: Surrey, BC, Canada
Contact:

Re: Database Connect for Work Request Screen

Post by KGA »

I can answer your second question based on experience. We have customers with trailers, etc that we enter manually into our vehicle fields and never have an issue with it saving the information. It does not have to be vehicle information that populates that area. Hope that helps.
User avatar
Johnny5
500 Club: Champion Contributor
500 Club: Champion Contributor
Posts: 654
Joined: Wed May 26, 2004 2:03 pm
Location: John Dwulet

Re: Database Connect for Work Request Screen

Post by Johnny5 »

krismj wrote:We are looking to potentially purchase Mitchell1's Manager SE. Prior to that decision we need to know if we can build a work request screen, access the database tables and use them in the work request then process them into a work order.
What sort of data elements would this 'work order request' screen include?
John Dwulet AKA: Johnny5
Retired - Mitchell1
krismj
Member
Posts: 2
Joined: Wed Mar 26, 2014 8:28 am

Re: Database Connect for Work Request Screen

Post by krismj »

I'd like there to be a work request screen with various boxes such as: "Is this a vehicle? Yes/No' If yes, choose vehicle (pop up list of licenses from tables). Then the info for other tables will populate based on the license table such as the owner (where they confirm that is the vehicle assigned to them) and then a list of the maintenance or preventative maintenance they need to perform will be a popup. The maintenance info will be the only things that shove back into the database work order screen. everything else will be confirmed to match. that's a 3000 foot view of what we need to build to work with this system if we purchase it.
Locked

Return to “Database + Settings”