We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

Kevin Frank

  • Content count

  • Joined

  • Last visited

  • Days Won


Kevin Frank last won the day on February 22

Kevin Frank had the most liked content!

Community Reputation

14 Good

1 Follower

About Kevin Frank

  • Rank
    grizzled veteran

Profile Information

  • Gender
  • Location
    Humboldt County, California

Contact Methods

  • Website URL
  1. Does FQL actually work?

    In addition to Comment's observations, I will add that if you're looking for records where FlagReview is empty, you should use IS NULL, e.g., ExecuteSQL ( "SELECT Inv_dollars FROM Customer_Event WHERE FlagReview IS NULL" ; "" ; "" ) ...which will give you a return separated list of all the matching Inv_dollars amounts (which I'm guessing is not what you actually want). You mentioned trying to get a sum -- perhaps this will do the trick? ExecuteSQL ( "SELECT SUM ( Inv_dollars ) FROM Customer_Event WHERE FlagReview IS NULL" ; "" ; "" )
  2. Does FQL actually work?

    Beverly Voth and I have both written extensively on ExecuteSQL, e.g., The Missing FM 12 ExecuteSQL Reference PDF version of FM 12 ExecuteSQL Reference FM 12 ExecuteSQL, part 1 FM 12 ExecuteSQL, part 2 FM 12 ExecuteSQL: Dynamic Parameters, part 1 FM 12 ExecuteSQL: Dynamic Parameters, part 2 FM 12 ExecuteSQL: Robust Coding, part 1 FM 12 ExecuteSQL: Robust Coding, part 2
  3. Windowing in FM 16: First Impressions

    9 May 2017: Today’s release of FileMaker 16 introduces new windowing options, and changes to existing windowing behavior… some of these are cross-platform, and one is specific to FileMaker for Windows. Demo file: FM-16-Windowing.zip (requires FM 16 or later) Cross-Platform Changes Change #1. Redesigned “New Window” dialog Note the new “Card” window style — I’ll […] View the full article
  4. In the article “An In-Depth Look at “Export Field Contents” (here), the study of how FileMaker exports text as single field contents is compared to the standard FileMaker Exports. Some of these present a problem when the field (exported) gets converted to something which a receiving system may reject as invalid. Several methods and alternative […] View the full article
  5. User-Friendly Excel Exports, part 7

    This is a follow up to last week’s part 6, with three refinements. Demo 1 (Excel Exports, v7a) – fixes a numeric formatting bug Demo 2 (Excel Exports, v7b) – offers a more flexible Excel export “save” dialog Demo 3 (Excel Exports, v7c) – uses ExecuteSQL to reduce the # of TOs on the RG […] View the full article
  6. User-Friendly Excel Exports, part 6

    Recently I was asked to implement user-friendly Excel exports on a WAN-based solution, utilizing some of the techniques explored earlier in this series (part 1, part 1.1, part 2, part 3, part 4 and part 5 — all from five years ago). There was just one problem: while performance was great locally, and okay on a LAN, it was […] View the full article
  7. PDF with Embedded Links

    Author’s note: I’d like to offer a big thank you to Christian Schmitz of Monkeybread Software, not only for creating and continually improving a fantastic plug-in, but also for promptly and patiently answering my many questions. A few weeks ago we looked at creating a table of contents for a PDF containing nine individual reports. […] View the full article
  8. Virtual List Table Of Contents, part 1

    A few years back I did an article on producing a PDF catalog + table of contents, with the TOC based on a vendor table and the catalog entries based on a products table. Today we’re going to use a different approach to generate a table of contents, and it builds on techniques explored in […] View the full article
  9. FM/SQL Portal Filter + Dynamic Sort

    Editor’s note: Today I’m pleased to present a guest article and accompanying demo file written by Joel Englander on using ExecuteSQL + a global multi-line key as an alternative to FileMaker’s built-in portal filtering mechanism, with dynamic portal sorting included as an added bonus. Demo file: fm-sqlportal-filter-and-dynsort.zip (75 Mb compressed, 230 Mb uncompressed) Portal Filtering […] View the full article
  10. Exploring Problem Spaces

    Given its primary role as a database product, it’s easy sometimes to forget what a great teaching tool FileMaker Pro can be. One of my favorite educational uses for it is building models to explore problem spaces, for example… viewing all possible outcomes for a problem with boundary conditions conducting trials to confirm the likelihood […] View the full article
  11. Modal Popovers + Magic Date Value Lists

    Today we’re going to explore a couple ideas that were glossed over in last month’s article on the CustomList custom function… implementing a “modal” popover using a “magic” value list to display a properly sorted list of dates …and you can download a copy of today’s demo file, Date Filtration, if you are so inclined. […] View the full article
  12. CustomList

    Earlier this year, in Virtual List Reporting, I used a custom function written by Agnes Barouh called CustomList to generate a couple basic lists, and then remarked… Well today I’m going to attempt to make good on that assertion. In case you aren’t already familiar with CustomList, it allows you to iteratively generate and/or parse […] View the full article
  13. Transfer a Found Set to a UI File

    Introduction If you work with the separation model, or any other multi-file configuration where a layout in file A is based on a table in file B, you may have encountered the following situation: while FileMaker is perfectly happy to allow you to transfer a found set from file A to file B… …there is […] View the full article
  14. SQL Query Error

    Obvious now that you mention it. Thanks.
  15. SQL Query Error

    Instead of Rental in the statement, try either... 'Rental' or ? If the latter, then you'll need to change this... ; "" ; "" ; invoiceID to ; "" ; "" ; invoiceID ; "Rental" Also bear in mind case-sensitivity... for SQL, Rental is not the same as rental A couple other thoughts: 1. in general, I avoid using SQL in calculated fields, for performance reasons 2. I have no idea what problem you're trying to solve with... decimal = Left ( Evaluate ( 1/2 ) ; 1 ) ...but I'm guessing there's a less convoluted way to go about it.