I've now added table view layouts to 5 tables in a development version of Studio Manager. The results are even better than expected. Using tables with multiple subsummaries with sort and find buttons delivers an incredible browsing experience.
FileMaker is the king of the hill in the end-user database game. Excel database and standard Excel is no competition for the masters. The ease of putting buttons on the screen and making them do simple finds and sorts is unmatched. You get column resizing and reordering. You get adding columns from data in your database without going into Layout mode.
I've never experienced data browsing like this in my 25 years of building databases. One of my practices in building FileMaker systems is to have a list screen for every table in the database. I've used the List View for these so that I could label my columns the way I wanted. However, I may be replacing the list screens with my new Table Views because they are so much more dynamic and useful for quick analysis and reporting. [Part 1]
3 replies on “FileMaker 10 Subsummaries in Table View, Part 2”
Janet,
This is very cool, but how did you get anything to display in the subsummary? I can’t get field values or merge fields. So what’s your trick!?
Thanks,
Denis
I echo Denis’s question. It doesn’t matter what I do, I can only get the break field itself to display in the subsummary part. I can’t get a summary field to display, as you’ve managed with your record count in the first post. When does/doesn’t this work?
Top 5 iPad/iPhone Filemaker Database Applications:
1) Healthcare Practitioners –
A recent government demonstration of iPhone applications for Electronic Medical Records (EMR) allows patients to control their health records and gives doctors expedited access to those records.
Federal financial incentives for medical practitioners transitioning to EMR is expected to additionally drive the market for mobile data devices such as smartphones and tablets that enable consumers to take healthcare into their own hands,”
Doctors can now securely review or share e-health records with patients, hospitals, clinics, and emergency rooms. Significant Federal incentives are also encouraging hospitals and doctors to centralize patient information to save money, time and improve medical outcomes.
2) Field Sales & Services – Perfect for presentations and demonstrations on the go. Immediately respond to customer questions about product information, order status or detailed pricing. No more “I need to call the office,” or “I’ll get back to you on that.”
3) Corporate Commuters and Travelers – The world is full of corporate employees who spend a large percentage of their time driving, walking around the corporate campus, attending meetings, making presentations, reviewing documents or lugging a laptop to the airport. Enter the iPad!
4) Mobile IT Pros – Who says IT pros have to be boring? Carry around an iPad, and presentations, image and effectiveness with end users takes a new turn.
5) Remote and Mobile Workers in all Walks of Life – Finally, whether you’re a field utility worker, salesperson, doctor or anyone who works remotely and needs “always-on” access to your data, an ACG Database Mobility app can help you Go!
ACG Technologies’ Database Mobility Practice:
An Apple-Aligned Mobile-Data Solution for:
Accessing Filemaker Databases on iPads and iPhones
To learn more:
Please call toll free 888-689-7677 x109
or visit: http://www.acgtechnologies.com/acg_database/db_filemaker.aspx