Request Fulfilment System for Television

This system is developed in FileMaker for television show production house. This system is cross platform compatible and developed to be used by both FileMaker Pro and IWP users. During the show building process there are requirements for supporting assets such as graphics, videos, animation, stills, for the show which the producer makes a request to the production house or creative department to build the asset for them.

This system keeps track of the tactics or requests made by different departments such as production, advance services, marketing, programming departments, etc. It provides a request or tactic form to the requesting departments to make a new request to other fulfilling departments. The system then redirects the requests to their respective fulfilling department managers. The managers can then assign staffs or resources to the tactic, who are going to work on the request and fulfill the requirements of the requesting department. The system has a communication portal built within it that will allow the resources and the fulfillment managers communicate with each other by sending messages and attachments on a particular tactic during the processing period which helps them. The system has user dashboard feature implemented in it which shows the lists of jobs assigned to the current user. It has an audio and visual alert on the user’s dashboard if there is any new message for the user and also for a new message which comes in to user’s dashboard. The resources can send message to requesting person asking for some other required detail to fulfill the request and vice versa. Once the resources finish their job, the system will automatically indicate the requesting persons or fulfilling managers that their request has been fulfilled and ask for their approval. It has the graphical chart feature implemented that draws the bar chart for the manager on the work progress of all the staffs and the staffs can see a graphical chart of their assigned tactics and their progress. The system has a section which allows Admin to manage the system configuration. It has a Contact Management module which stores all the contact details of the employees of the company. This system has the user’s login via active directory groups. It has the report generation and printing the reports feature implemented for both FileMaker Pro and IWP users.