I hope you will be so kind as to give us a full report on your experience with hiring a Filemaker designer and how the end result is working for you.
I've been using the filemaker solution for about 3 weeks now, so far its just me and 1 other person in the shop using it while we iron out the bugs. I'm hoping to be able to roll it out fully in the coming weeks.
The system currently handles order entry and project workflow/management. We have a customer centre that allows you to view all past workorders for each customer, you can search for them based on a bunch of criteria (job name, po#, job # etc.) There is also a thumbnail photo of each job so you can find it quicker (I'm a visual person)
From the customer area, you can create a new workorder using templates, we currently have 5 preset templates set up, engraved tags, large format printing, bronze plaques, ada Signage and generic. Each template uses drop downs for things like materials, for example the large format has drop downs for media, laminate, substrate, single or double sided, finishing and a bunch more, this allows us to create an order extremely quickly.
Once an order is created, it's assigned a status, waiting for client, parts to order, waiting on materials, in production, waiting to install, ready to invoice and archive, you can then view the jobs by either status or by machine on a trello like job board.
Overall I'm very happy with the system, I'm excited to add on to it in the future and be able to manage even more with it.
We hired a developer from the UK on upwork he has even really good to work with, extremely responsive and he makes small changes to the system even now after he has been paid if we notice something. If anyone is interested I can DM you his info.
The hardest part was trying to communicate all the ideas in my head to someone who wasn't in the sign industry, but he did a really good job, everytime I asked if something was possible, the answer was yes.