Board logo

IT / database / Boffin help
locoboy - 23/7/15 at 12:59 PM

Collective folks........

I work for a breakers and I would say that 70% of our phone calls result in us saying, sorry we do not have that part at the moment.

I need to think of a way that we can capture all these requests in a nice simple, concise and searchable manner so that every time we get a new breaker in I can search the enquiries for anyone that has asked for parts from that make and model of car.

Easy enough to do in excel, I get that but the problem we have is that we are not office bound so one minute I could be on the fork lift, the next on the mezzanine floor, then back in the office.

Is there a way to have something on a tablet or phone that me and a couple of others can access one central place and add enquiries as and when they come it.

It needs to be a minimum of name, phone number, a few key words about what they want, Date of enquiry and make and model and year of vehicle it is for.

I need to be able to fill it in in the office, on the yard, on the gritter, or in the workshop.

Any suggestions / help/ advice or personal experiences welcomed.
Thanks

BenB - 23/7/15 at 01:08 PM

Is it not possible via Office365 or GoogleDocs?

locoboy - 23/7/15 at 01:18 PM

I don't know, I know what I want but don't know if something is already commercially available or not.

I see it working like this
Answer phone
Don't have the part for the customer
Open app on phone/device
App auto date stamps it.
I fill in Name, Contact details, key words of the parts the customer wants and the make and model of the vehicle (maybe on a drop down menu to avoid an spelling errors or inconsistencies to make searching more fool proof later)

Then I click submit etc and it saves it 'somewhere'!

Then when I next get an austin Maxi or what ever in for breaking I can search all enquiries that have the make = Austin and model = Maxi to bring up all the folks that were after bits and call them all back.

This will hopefully save me time listing on ebay and the associated ebay/paypal fees as I can sell it direct to the guy who enquired about it.

Cheers
Col

Slimy38 - 23/7/15 at 01:36 PM

I'd agree with Office365, Microsofts standard hosting is plenty for a single document to be shared on all locations. I personally use OneNote to track my car mileage on my phone, then it's instantly available on my laptop when I make my expense claim.

All it needed was an email address.

r1_pete - 23/7/15 at 01:58 PM

MySQL - freeware relational database, access it wireless from you cabs etc. from any browser.

Loads of online help, forums, and the like, and easy to learn.

locoboy - 23/7/15 at 02:12 PM

^^^^^^ Is that even English??

Slimy38 - 23/7/15 at 05:23 PM

quote:
Originally posted by locoboy
^^^^^^ Is that even English??


I'm starting to get an idea of the level you're aiming at...

Kdempsie - 23/7/15 at 06:03 PM

Microsoft OneNote would do this for you.

02GF74 - 23/7/15 at 06:14 PM

For 1 user, yahoo mail?

Write info, save as draft, then move to folder.

Yahoo mail can search.

Actually for more users, crrate new mail account and share it.

ste - 23/7/15 at 10:24 PM

have a look at zoho's software.

https://www.zoho.com/creator/

I used their invoice software and it is web based, so is ideal for on your mobile, tablet, pc etc

That should be free for a single use

Hodor - 23/7/15 at 11:08 PM

How about a forum type repository for all your info? Each enquiry could be a new thread. All searchable, cloud based (like this forum is), easy to set up and free from here

One draw back is not being able to view all the data in one view, like you can with a spreadsheet, but access wise from a phone or tablet whilst out and about its probably way easier. Looking at data on spreadsheets on a phone or tablet is a shitty affair and best avoided.