"No Holding Back FileMaker Blogging"
|
Navigation:
|
Support this site by clicking on a sponsor below or becoming a patron!
FileMaker 20 Video Tutorials
Become a patron of this FREE web site!
|
|
Recent Blogs:
|
Currency Formatting
|
Gathering Portals
|
Multiple Choice Picker
|
Popups and Pickers
|
Window Locking
|
|
Meta-Consulting
Meta-consulting is a service Database Pros offers to help other developers
over programming hurdles via GoToMeeting. Email John Mark Osborne or call John Mark at (909) 393-4664 to find out more about this service.
|
Beginner, Intermediate and Advanced Video Training
|
Quick Tip:
|
Semi-Sorted A database can either be sorted, unsorted or semi-sorted. The first two are pretty obvious, but it is less clear how a database becomes semi-sorted. A database becomes semi-sorted when a new record is added to a currently sorted database and the option to keep records sorted is unchecked. It can also become semi-sorted if a record is edited -- but only if one of the fields used in the sort is edited. Deleting a record will not make a database semi-sorted. |
|
Create a Password Management solution!
|
Fun Stuff:
|
FileMaker Developer Worthiness Top 10 ways you know your developer is NOT worthy:
- Spells "FileMaker" with a lowercase "m"
- Uses inches or centimeters instead of points in Inspector
- Recommends WebDirect deployment over FileMaker Pro
- Creates a solution with one file for every table
- Doesn't know Claris and FileMaker, Inc. are the same company
- Isn't certified for latest version of FileMaker
- Isn't an FBA member
- Charges less than $100.00 per hour
- Uses a rainbow of colors on his interface
- Provides a quote without a requirements document
|
|
Create a Complete Contact Manager
|
RSS Feed
|
|
|
Why then How
|
Level: Intermediate Version: FileMaker 19 Category: General Tuesday, February 16, 2021 |
|
|
|
|
|
I once asked someone on the forums why they wanted a particular solution. I did this because they were asking for a technique that seemed like a lot of unnecessary work. I was attempting to provide a better answer that met their true needs within the abilities of FileMaker. In other words, why give a man a fish when he really wants a fishing pole. The response I received was, "Why is not relevant to how." Wow! This guy couldn't be any more wrong. Such a shortsighted approach to programming is not uncommon which is why I'm writing this article. It's your job as a developer to ask your clients "why"! So... let me tell you why.
The Client Isn't Always Right When your client asks you to be on time to a meeting, he's absolutely right. When a client asks you to program a feature that's going to be slow or unnecessarily expensive, they probably aren't right. It's your job as a consultant to ask your client why they want something. This leads to more client satisfaction rather than less. Your client is the subject matter expert and not the programmer. It's your job to translate their business into electronic form, not their job to tell you how to program FileMaker.
This may sound harsh but it's really the opposite. If you program a database system based solely on input from an armchair quarterback, it's bound to fail in terms of speed, flexibility and/or expansion. This is a disservice to your client. Of course, you need to be able to eloquently describe why a solution is not viable. But, to avoid that conversation with your client cause you don't want to upset them is a dereliction of your duty as a developer. Therefore, you need to be diligent in asking why they want something if it seems different than what you normally do.
Interviewing a Client Most of the time, I ask a client to create an outline of their needs. There's no right or wrong way to format it. It's just a good starting point so I can interview them and fill out the requirements document more quickly. It's your job to dictate the structure and the client's job to provide the information about the problem they are trying to overcome. It's that simple but I see databases on a monthly basis that were essentially designed by the client.
BTW: I also see tons of FileMaker solutions designed by the developer alone. What you are aiming for is a joint effort between the developer and the client.
Reporting Disasters Probably the number one client request that I try to discourage are dashboards. It's one of those buzzwords that a client gets in their mind from some demonstration they've seen. In reality, only a small percentage of the clients I've worked with over the last two decades actually need a dashboard. That's because I ask them why they want a dashboard. Most of the time, they really just want a subsummary report.
Dashboards tend to be slow because they summarize data. This is true no matter how they are designed. If they are summarizing data live then the unstored calculations are slow. If they require a refresh button to update the values then why not just run a standard subsummary report so you are using FileMaker the way it was designed to work. Subsummary reports are easy to design so they often take less time to program. Less time means less money. And, if it gets you the same summarized information, what's the difference?
A lot of people are now using third party products like Tableau. While this technology can do some super cool stuff, you still need to export your summarized data and import it into the third party interface. This also requires licensing another product and likely paying quarterly or yearly rental fees. If you just work within the development environment in FileMaker, it can also do some amazing things with reports and charting that can save your client time and money.
Excel While we're on the topic of reporting, let's talk about the world where most clients come from... Excel. Excel is a spreadsheet but it has been frankensteined to do a lot of the things a database can do. It kinda looks like a database but it's only a flat database. People move from Excel to a database because Excel has been stretched to it's limit. Now they expect FileMaker to work exactly the same. It's your job as a developer to educate them.
One of the most common requests is cross-tab reporting. Sure, you can do this with some workarounds in FileMaker but it requires hard coding the report. In other words, once the report is complete, it's not flexible like a standard FileMaker subsummary report. And what's the difference? Cross-tab reports look like a matrix. FileMaker reports are linear or vertical. I understand the format is different and the client is not used to seeing it the FileMaker way. But, consider the flexibility that a true FileMaker report offers. I think it's worth explaining the change to your clients.
Stories from the Depths of FileMaker Development I have so many stories about clients who I talked out of features over the last two decades. None are really that interesting to recount. I bring it up cause of the frequency. Almost every client asks for a feature that's not advisable. Whether it's mimicking a iTunes interface or building a feature that should be handled by a human, the story is the same. Sometimes you have to convince your client not to program a feature. Do it nicely and factually so they feel good about following along in your direction.
I was just talking to a client last week and they wanted a feature to quickly and easily move players from one team to another in order to balance out teams. His idea was to allow dragging and dropping from window to window. I was able to convince him over a screen sharing session that a subsummary report in browse mode, organized by teams would allow him to move players around just as easily. Now all he does is run the report and popup a menu of teams next to each player to switch. The subsummary report automatically reorganizes the player and he gets a great overview of the entire league so he can get a bird's eye view of the structure.
This report only took me fifteen minutes to create while the client was online with me. I duplicated an existing report layout and a script and modified them to meet the needs of the feature. When I was done showing what could be done, there really was no polishing to be done since I had reused previous work. My point is, you need to understand why your client wants a particular feature. Don't just give them what they request. Fully understand their motivation and you can provide better and less expensive solutions to meet their needs.
Author: John Mark Osborne
jmo@filemakerpros.com
www.databasepros.com
This blog is completely free. Please support it by clicking on one of the advertisers at the left side of the window or becoming a patron. Thanks so much!
|
Comments:
|
|
Elzo Guarnieri
|
02/17/2021
|
|
Well put! There’s a lot of truth to what you said.
|
|
Taylor Sharpe
|
02/17/2021
|
|
Some people are not open to advice or help and they have blinders on to solve a particular problem without looking at the big picture. One response I have to such people is to ask them if they are open to ideas and suggestions before progressing with them because by asking them that way, it tends to open them up to ideas.
|
|
Peter Cross
|
02/17/2021
|
|
The most powerful moment in my FileMaker career was during a presentation you made at ... think it was... Devcon 2003.
You said you relied on a behavior in FileMaker and leveraged how it worked. It was then that I knew that truly great programming comes from understanding the tools.
Never did thank you properly for that. So Thank you so much! I invented some really amazing stuff out of that inspiration. You are the master John.
|
|
|
|