FileMaker 10 Subsummaries in Table View, Part 2

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.

SM10_Contacts_Table_View 
In the example of my Contacts Table View, I have  subsummaries for industry and company. Sorting by Industry, Company with the button provided at the bottom of the screen yields this readable and still editable view of contacts.

Clicking the Industry column heading yields a subhead for each industry, but does not put in company headings. Clicking the Company column head shows Company headings with the employees in that company listed beneath it. The user chooses the sort and view that helps with the work at hand.

Excel vs. FileMaker 10 Table View. Move over Excel, Table View goes you one better in many situations. Excel's strength is ad hoc analysis with calculations involved. We know that lots of people use Excel as a list manager. It will even ask you if you want to make a list and switch into a lightweight database.

SM10_Invoices_Table_View

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 thoughts on “FileMaker 10 Subsummaries in Table View, Part 2

  1. Denis

    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

    Reply
  2. WilliamCB

    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?

    Reply
  3. Leesweeney123

    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

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *