Claris Certified FileMaker Pro App Developer ExpertClaris Certified FileMaker Pro Server Administrator

NO-COST CONSULTATION

Detailed initial consultations to discuss your needs and estimate costs are always free. Contact me to speak in-depth with no obligation:
 

 

  • Based in California's San Francisco Bay Area and serving clients nationwide

    • Partners

    A proud partner of
    Tech Tonics logo
    A Bay Area full-service managed IT support services company. Find us at http://www.techtonics.com.
    Jan 28

    Dynamically sorting Relational Numeric Value Lists by Custom Order in FileMaker Pro 11

    Michael Kupietz

    0 Comment

    FileMaker Articles

    There is a discussion on Soliant’s blog of using the Char function and unicode Byte Order Marks to sort dynamically-generated value lists into a custom order. One of the comments was from a user that had a problem getting this technique to work in FileMaker Pro 11 with numeric fields.

    Here is an FM11 demo file that solves the problem:  Sorting Numeric Relational Value Lists FM11.fp7

    File tested in FileMaker 10 and 11.


    Tags : , , , , , ,
    Michael Kupietz

    Related articles

    Converting and resizing images in FileMaker with pure Javascript instead of GetThumbnail()
    August 15, 2024 FileMaker has a built-in GetThumbnail() function to resize and convert image formats for images stored in container fields. However, there are scattered reports that this isn’t always reliable (like at https://www.reddit.com/r/filemaker/comments/1et224c/strange_container_bug/ and https://community.claris.com/en/s/question/0D53w00005ZIw34CAD/getthumbnail-on-filemaker-go-not-working-with-png-files-when-fm-file-is-hosted. So I used a javascript demo I found (at https://dev.to/ninofiliu/lets-write-an-image-converter-in-20-lines-of-htmljs-bng)  to create a webviewer-powered function that uses pure javascript to resize and […]
    Solution: FileMaker Server will not start after Windows Server crash or upgrade
    January 14, 2019 SHORT ANSWER: Try moving the file ‘ServerCustom.pem’ from the “C:\Program Files\FileMaker\FileMaker Server\CStore” directory to the desktop, and then try starting the FileMaker Server. If it works, you’ll need to download and install a new SSL certificate, but other than that you should be fine. If it still doesn’t work, put it back into “C:\Program Files\FileMaker\FileMaker […]
    “[Er, Almost] Always Working” FileMaker app Multi-Page PDF viewer
    October 17, 2018 Note: This technique should be considered “almost always working”, not “always working” as previously (and wishfully) billed. Sorry, as FileMaker and desktop OSes have changed, this file, which relies on several technologies from several different sources working together, has proven to be not always reliable. I would not try to use it in any solution […]
    Opener file no longer works after upgrade to FileMaker 16
    June 26, 2017 Due to FileMaker version 16’s new warnings about connecting to servers without SSL,  after upgrading, some opener files simply don’t open files from FileMaker Server over the network like they did under previous versions of FileMaker Pro or FileMaker Advanced. The symptom: Many users use “opener” files, local files saved on their hard drives, to open FileMaker databases […]
    Capturing a FileMaker screenshot in Preview Mode with a scripted “Copy []” command
    March 6, 2017 This hidden feature of FileMaker has been documented elsewhere, but there’s a little quirk that isn’t always mentioned. You can capture a screenshot of your current layout in FileMaker by going into Preview mode, and selecting “Copy” from the “Edit” menu. This places a screenshot of the Preview on the clipboard. However, if you script this, […]
    Stay in touch
    • Michael Kupietz
    • Certified Expert FileMaker Pro Consultant & Full-Stack Web Developer
    • Serving clients locally and remotely, in California's San Francisco Bay Area and nationwide
    • Phone: (415) 545-8743
    • Download vCard