We would like a FileMaker application developed to help our company. We buy, sell, and refinish heating radiators. It is very difficult to keep track of all the radiators, to schedule them for pick-up or installation, or to select a radiator from our inventory that is the correct size for a customer who needs a radiator. The job information would have to be imported from ServiceM8 via API.
The database would consist of a photo database, job information imported from ServiceM8, and a map on which all the locations are pinned.
It has 5 components:
We purchase used radiators. We need to annotate the price, quantity, and location so we can efficiently pick them up. Includes photos on occasion.
We have customers who need replacement radiators. We need to keep a database of what they are looking for with photo, description, and location so we can match a used one from above and eventually install it (schedule together with other nearby radiator jobs)
We have a radiator inventory in our shop that is for sale. Ideally these would all be listed in our website shopping page as well (integration). We need to keep track of it with photos.
We refinish radiators. We remove them from their location, take to the refinisher, then return to reinstall. These refinishing jobs need to be plotted on a map so we can efficiently pick them up and return to reinstall in conjunction with 1 & 2 above if other jobs are nearby or on the way.
5. A 5th (and complicated category) is we have people who want their radiators refinished and who need replacement radiators. The replacements have to be found before we can pickup for the refinishing. So 1st the job goes to replacement, then when replacements located, it goes to Refinishing.
The main points are:
Keeping track of everything: Who needs what, what we need to find, what we have, where everything is, and when we are schedule to do what.
Seeing everything on a map so we can schedule our workers and their routes in a geographically efficient manner. A specialized vehicle is used for this work, so when it goes out with 2 men it can only do radiator work.
[login to view URL]
[login to view URL]