• After 15+ years, we've made a big change: Android Forums is now Early Bird Club. Learn more here.

Apps Creating a Job Card app! Where to start

B

B4DG3R88

Lurker
Hi people of android forum

Thanks in advance for any help offered.

I am currently learning python and getting on very well with it! I have decided to try and lighten my workload and make my life easier at work.

I want to create an app that will link do 2 databases which also need to be created and I'm not sure where to start.

The first database will be a machinery database containing the machine number, make model, year serial number etc! I do already have this as an excel spread sheet!

The second database will be a parts/stock database containing part description, part number, machine it goes on! You get the idea which again I have as an excel spreadsheet.

The hard part is the app. I want to create an app which operators can book a machine in with a fault. They will select the machine from the machine list (connected to the machine DB) and give a description of the fault. It will then create a job sheet and hold that job sheet live. My staff will then be able to open said live job sheet, view the fault and once the job is repaired they can update the job sheet with how the fault has been rectified add the parts fitted (connected to the parts DB) I then want this to deduct the stock count from the stock DB.

When the job sheet is finished I then want the app to send the job sheet to the computer and file it in the correct place.

Does this sound unrealistic for a beginner programmer! I was thinking of trying to create it with python and cross platform it using something like KIVY!

Or am I better off trying to learn and build it in java!

Any help or someone who can point me in the right direction to start I would greatly appreciate

Thanks

Matt
 
Hi. Welcome to Android Forums.

You've picked a challenging first project. The first question you should ask yourself is, do I need an app for this at all?
Assuming that the databases are located on a central server, then probably a simpler solution would be to implement a website. Particularly as you already have experience with Python. You could use this to implement the back-end server/database aspect of the system.
Your user interface would then be the web pages. Doing it this way also means that you have plenty of cross-platform flexibility - web pages will work on any system (mobile, desktop) that has a web browser.

There's nothing wrong with writing an app, but its interface to the database server will be different. You will likely have to implement some web services to handle requests for data. There are quite a few moving parts to this, and if you don't know Java, it will be a steep learning curve.
 
Thanks LV426

I never thought about trying to do it with a web page! I just had the idea of using a tablet in the workshop as it's mobile not massively expensive! And I assumed being android I could create an app!! Creating a web page could work quite well as I wouldn't have to learn another language yet!!

Thumbs up mate!

Thanks
 
No problem. Also consider that you might need to develop different variants of your web pages, to work on desktop vs mobile devices. You might not though, some full screen pages often work ok on a small screen device. Depends on the page content.
 
You must log in or register to reply here.
Back
Top Bottom