Jump to content

Kevin Frank

Members
  • Content count

    104
  • Joined

  • Last visited

  • Days Won

    3

Kevin Frank last won the day on February 22 2017

Kevin Frank had the most liked content!

Community Reputation

15 Good

1 Follower

About Kevin Frank

  • Rank
    grizzled veteran

Profile Information

  • Gender
    Male
  • Location
    Humboldt County, California

Contact Methods

  • Website URL
    http://kevinfrank.com

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Kevin Frank

    Fast Summaries Re-revisited

    My recent “Virtual List on Steroids” presentation at DIG-FM, and the preparation of a revised version to give at dotFMP next week, has prompted me to reconsider certain assumptions re: optimizing performance both locally, and across a LAN and/or WAN. Specifically, there are two things we’re going to look at today. First, a way to […] View the full article
  2. Kevin Frank

    Virtual List on Steroids, part 2

    Here are files that may be demoed or referred to during my “Virtual List on Steroids” DIG-FM presentation on Thursday, May 10th, 2018 (VLR = “virtual list reporting). Demo Files Step One – Admitting There’s A Problem VLR, part 2 (on Steroids) VLR + JSON Array, v1 [new] VLR + JSON Array, v2 [new] VLR […] View the full article
  3. Kevin Frank

    Thinking About JSON, part 1

    I’ve been working on a couple large JSON projects over the last few months, and with the one year anniversary of FileMaker having built-in JSON capabilities just around the corner, this seems an opportune moment to share some reflections and opinions (some of which may contradict JSON-related opinions I have expressed previously). Demo file: json-sandbox.zip […] View the full article
  4. Kevin Frank

    Custom Field-Based Value Lists

    Introduction Does this sound familiar? You’ve rolled out a solution that includes a single-record Settings table where authorized users can enter/update various system-wide settings, including one or more fields where the items will appear in popup menus… and then comes the inevitable question: Why don’t items in popup menus appear in the order I entered […] View the full article
  5. Kevin Frank

    Exposed by Tableau

    Editor’s note: today we have a guest article written by John Weinshel, who has been quietly contributing to the FileMaker community for 20+ years. John’s thoughtful postings have helped developers at all levels of expertise, and I’m pleased to present his thoughts on Tableau here on FileMaker Hacks. Demo files: exposed-by-tableau.zip (6Mb, contains two .twbx […] View the full article
  6. Kevin Frank

    Sorting on a Field Rep > 1

    Recently, in a virtual list report, I had a need to sort on rep number 2 of a repeating field called cell_text_r. FileMaker does not offer an obvious way to script a sort on a field rep > 1, and I had worked around the problem in the past by A. defining some special non-repeating […] View the full article
  7. Kevin Frank

    Virtual List on Steroids

    Here are links to resources that may be referenced during my FM-DiSC presentation on Friday, January 12th. This page will be updated to include demo files in the near future. Virtual List Articles Long Documents in FileMaker 11 Conditional Subsummary Report in Browse Mode Virtual List Reporting, Part 1 Virtual List Reporting, Part 2 Virtual […] View the full article
  8. Kevin Frank

    Scrolling the Unscrollable

    Demo file: scrolling-the-unscrollable.zip Howard Schlossberg’s presentation on popovers (FileMaker 13 Popovers) has inspired me on multiple occasions… a favorite takeaway is the idea that you can have a scrolling check box set within a popover. The trick is to size the field as tall as necessary to display all the values (this is an extreme […] View the full article
  9. Kevin Frank

    Simple Join

    Yep... my response assumes the user is querying from the perspective of a particular therapist record.
  10. Kevin Frank

    Simple Join

    Hi Jim, I agree with Barbara's observations that "YEAR" is a reserved SQL word, and that ExecuteSQL isn't generally a good fit for a calculated field. If you insist however, I think this would work as a calculated field in THERAPISTS -- and of course if you have FMP Advanced, you can test this via the Data Viewer ExecuteSQL ( " SELECT SUM( expectedrefsind ) FROM YEARS WHERE therapistid = ? AND \"year\" > ? " ; "" ; "" ; therapists::zk_TherapistID ; 2014 ) You don't need to use the JOIN operator because both the fields referenced in the WHERE clause live in the YEARS table. Hope this helps, Kevin
  11. Kevin Frank

    Excel Exports using XML and XSLT

    Editor’s note: Once again it is an honor and a privilege to present an in-depth guest article written by Beverly Voth. This is a follow-up to the User-Friendly Excel Exports series by Kevin Frank, but using an XML export along with various XSLT to give you .csv or .xls (for Excel). The first demo is […] View the full article
  12. Kevin Frank

    Reciprocal Linkage, part 3

    I thought after part 2 that this technique had been thoroughly discussed and dissected, but Geoff Gerhard of Creative Solutions writes to point out that, if the goal is to have as few moving parts as possible, the table occurrence (TO) count can be further reduced, from four to three… …and has provided a demo […] View the full article
  13. Kevin Frank

    Reciprocal Linkage, part 2

    This is a quick follow up to last week’s article on reciprocal (bi-directional) linking, and will assume the reader is familiar with that material. Paul Jansen of APJ Computing Solutions sent in a revision of one of my files demonstrating that, among other things, the graph could be a good deal leaner (as per my […] View the full article
  14. Kevin Frank

    Reciprocal Linkage

    Challenge: in a multiuser document management system, facilitate the linking (and unlinking) of any document with any other. Make it clear which documents are linked to the current document, and make sure the approach is multiuser friendly — in other words, allow document records to be linked and unlinked even if one or both of […] View the full article
  15. Kevin Frank

    JSON Array + Virtual List

    Over the last few postings we’ve been looking at using JSON with Virtual List… and prior to today, our focus has been on JSON structures using name/value pairs. Well today we’re going to switch our attention to basic JSON array structures. Demo file: json-array-plus-virtual-list.zip (requires FileMaker 16.02 or later) Apart from using JSON arrays instead […] View the full article
×

Important Information

By using this site, you agree to our Terms of Use.