We are looking for a freelancer to help us set up a bespoke/custom system using FILEMAKER, so someone with experience using this to a highly customised level is required. We are a printed textiles manufactuer and are looking to streamline our work flow.A brief overview of the type of set up we are looking for is as follows:
- a data base of 'jobs' all of which are categorised by a number, preceded by either LX, RS or D (these refer to the type of job they are) - we currently use google drive for this. When a new job is 'comes in' - we allocate it a number on the sheet. The sheet also shows information such as dimensions, number of colours, who has worked on the job and also which customer it is for etc. We would need to convert/migrate the database as it currently is, to be used in allignment with the next step. We also need to be able to filter by customer.
- from that point, a 'job sheet' is generated in excel - which is filled out manually, using the number allocated on the database. Other information like dimensions, due date etc all go on this ticket. There is also an image of the job. What we need, is for the database and the job ticket to work together, so opening up a new job ticket, automatically allocates the next number on the database And filling in info such as dimensions, number of colours etc, all of this info is duplicated onto the database.
- we would also like fields such as 'due dates' to be on the job sheet. There are vairous due dates for different stages of the process. For example, 'artwork complete' - 'artwork approval' - 'colouration complete' etc. We are also looking for a log of upcoming 'due events' for each job that is in work. So a report which can be generated weekly/daily etc - to show us what is coming up and what needs addressing on each job. These 'due dates' don't need to be duplicated onto the database of jobs, just the log/report.
- as there are different departments in the business, which work on different aspects throughout a jobs 'life' - it would be good if the reports can be ran to highlight 'due dates' which correspond only to those departments.
We can provide visual models in excel of what the job sheets should look like - but the acutal process of creating them and making them work and talk to databases is the part which we need help with. Things like over all layout, colour scheme, inclusion of company logo are minor details which will still need taking into account
A face to face meeting on site to discuss our requirements would be necessary. The nature of the job would be very much similar to building a website - using a platform such as wordpress or drupal, where in the foundation of the tool is there, it just needs to be cusomised to work how we need it to.
About the recuiterMember since Sep 4, 2017 Alianna
from New Jersey, United States