The internal marketing department at a large company contacted the team at LuminFire to build a custom application based on BrilliantHub for Creative Teams. They were using Salesforce in an attempt to manage complex job workflows and work requests. Even after going through several revisions, the Salesforce system still had a rigid job structure. Charged on a per user per month basis, the system was also costing more than the client thought was reasonable.

We proposed a new FileMaker system based to completely replace the Salesforce system. The primary investment would be in custom development up front with minor ongoing costs for hosting and licensing. To meet internal requirements and budget constraints we were tasked to complete the development in less than two months. Replace Salesforce in under two months? This task sounded nearly impossible but the team took on the challenge and completed all primary development on-time and in-budget.

The Right Tool for the Job

We understand that sometimes Salesforce may be the right choice to solve some problems, but in many other situations FileMaker is the best choice. At LuminFire we have experience with multiple technologies so we can choose the right one for the situation. We’ve even written a WordPress plug-in for Salesforce that populates leads from an online form.

In this marketing/creative department case, we determined that FileMaker/BrilliantHub was the better solution. An analogy may help. Think of Salesforce as a hammer and FileMaker as a screwdriver. If you try hard enough, you can pound in a screw with a hammer, but the results will be ugly and the screw won’t work as designed when you try to take it out again. As Maslow’s saying goes, “When all you have is a hammer, everything looks like a nail.”

In reality, most people are not able to choose the right tool without the help of a trusted advisor as they don’t have enough experience using different tools to make an educated decision.

Custom Modules and Reporting

We custom built many modules to track information for the project including Contacts, Jobs, Job Templates, Activities, Documents, etc. The way we were able to implement the job templates allowed for total flexibility for different types of jobs…something that they were unable to achieve with their Salesforce solution. We also provided flexible reporting with many options including export of information to Excel for additional analysis and formatting, direct printing to PDF, screen dashboards, and emailing of information.

Integration

We utilized WordPress to build the structure around the website submission form. It provided a pre-built theme and form creation tool so that we could connect it to FileMaker directly. We specialize in FileMaker integration with WordPress at all levels. Integration was made easier with BrilliantSync that acts as a translator between the two systems.

Security

Some IT professionals are hesitant to move the hosting in the cloud or move data out of their office environment due to security concerns. The opposite is true. Often your data is more safe and secure in the cloud than at your office. The application is hosted from a highly secure data center that has many more physical controls on the hardware and access than most office server rooms. Taking advantage of all modern security options such as SSL, EAR (Encryption at Rest), encrypted data transmission, audit logging, etc. this solution is now fully HIPAA compliant and meets the strictest security standards. Most creative departments may not require this level of security but it is good to know it is there if needed.

Overall Benefits

With the FileMaker solution utilizing BrilliantHub for Creative Teams, the client got a custom flexible job tracking system built to their exact specifications where they can have varying types of processes for each job and reporting as required. They did not have to try to fit their processes into a generalized system that was not designed to support their needs. The solution creates competitive advantage for them.

Conclusion

For the 60+ users of the system, the estimated return on investment is about $150,000 annually. All users are operating more productively and effectively than before. Total development costs were more than paid for in the first year of use.

The system is flexible and the client can enhance the solution however they want to in the future. On launch day the client expressed their appreciation for our work:

“Thank you cannot begin to express my appreciation for everything you’ve done – and are still doing – to get BrilliantHub up and running. Your patience, flexibility, and insight have been unwavering. We certainly couldn’t have launched today without you. LuminFire has been wonderful to work with, and you are truly appreciated.”