• Home
  • Family
    • Esther
    • Jeremiah
    • Gabe
    • Spencer
    • Brigg
  • Posts
  • Photos
  • Family Histories
  • Files
  • Links
    • Caveman Youth Football
    • FileMaker Hacks
    • FileMaker Solutions
    • Great Mac Software
  • About Me
    • Contact Me
    • Resume
  • Login
Layne Shipley

PERSONAL

Menu

  • Home
  • Family
    • Esther
    • Jeremiah
    • Gabe
    • Spencer
    • Brigg
  • Posts
  • Photos
  • Family Histories
  • Files
  • Links
    • Caveman Youth Football
    • FileMaker Hacks
    • FileMaker Solutions
    • Great Mac Software
  • About Me
    • Contact Me
    • Resume
  • Login
  • Computers,  ExecuteSQL,  FileMaker,  General

    ExecuteSQL Show 1 Row of Search Results

    05/01/2025 / No Comments

    I have query that do a find, sort the records, then I want to show only the first record:

    Read More
    Layne

    You May Also Like

    Importing JSON Data Into FileMaker

    07/10/2014

    The Savior Makes All Things Right

    04/13/2014

    Hopewell

    10/17/2023
  • Computers,  ExecuteSQL,  FileMaker

    Multi Join FileMaker ExecuteSQL Query

    12/17/2024 / No Comments

    I have a client with a database that was over engineered. Rather build a set of overly complex relationships to find this data I attempted my first multi inner join query with SQL. The result was highly successful! Greatly reducing the speeding on reporting pages. The query finds country names, groups them by name, and sums the days the user is in country.

    Read More
    Layne

    You May Also Like

    Have you ever wanted to Quote in a calculation field?

    07/10/2014

    BYU vs the Big 12

    06/10/2014

    Using 360Works Plugins with FileMaker Server and IWP / XML

    07/10/2014
  • Computers,  FileMaker

    Missing FileMaker ExecuteSQL Documentation

    11/18/2024 / No Comments

    https://filemakerhacks.com/2012/10/19/the-missing-fm-12-executesql-reference/ Very useful article!

    Read More
    Layne

    You May Also Like

    A Los Anos

    05/02/2023

    Importing JSON Data Into FileMaker

    07/10/2014

    Emron

    04/01/2014
  • Computers,  ExecuteSQL,  FileMaker,  General

    ExcuteSQL Dashboards and Charts

    03/13/2023 / No Comments

    Read More
    Layne

    You May Also Like

    Why We Shoot Deer in the Wild

    03/15/2021

    Remove Duplicates from List() function

    07/10/2014

    Gabe JV Football Videos

    05/02/2025
  • Computers,  FileMaker,  General

    ExecuteSQL Function Basics: free training webinar for FileMaker

    03/11/2023 / No Comments

    Read More
    Layne

    You May Also Like

    Importing JSON Data Into FileMaker

    07/10/2014

    Sunday School Book of Mormon Disscussion

    04/13/2014

    Have you ever wanted to Quote in a calculation field?

    07/10/2014
  • Computers,  FileMaker

    Parsing JSON in FileMaker

    05/10/2022 / No Comments

    https://www.soliantconsulting.com/blog/parsing-json-filemaker-16/

    Read More
    Layne

    You May Also Like

    Exporting RTF text from a FileMaker field

    07/10/2014

    8B AF Shipley 2020

    11/19/2020

    WordPress Front-end Editor Error

    10/10/2014
  • Blog,  Computers,  FileMaker

    Web Safe FileMaker Fonts

    03/23/2015 / No Comments

    Arial Courier Georgia Helvetica Lucid Grande Times Trebuchet Verdana Hiragoni Osaka  

    Read More

    You May Also Like

    Hosted FileMaker File Make Pre Upload Tips

    07/10/2014

    Importing JSON Data Into FileMaker

    07/10/2014

    All Stars

    06/19/2014
  • Computers,  FileMaker

    Have you ever wanted to output quotes from a FileMaker calculation?

    07/17/2014 / No Comments

    Have you ever wanted to output quotes from a FileMaker calculation?  Here’s the simple way to do it: Ex. Johnathan “Doe” Shipley In the FileMaker calculation your would write the following: “Johnathan \”Doe\” Shipley” Your output will then have quotes.

    Read More

    You May Also Like

    Creating QR Codes with FileMaker

    07/10/2014

    Gabe JV Football Videos

    05/02/2025

    Emron

    04/01/2014
  • Computers,  FileMaker

    Exporting RTF text from a FileMaker field

    07/10/2014 / No Comments

    On one of the projects I was working on, I came across a problem were I had data to export that needed to be exported with the RTF formatting maintained.  I was trying to create an index with some bolding etc. applied.  After looking for plugin etc. to do this I came across a simple solution.  If you’re using FileMaker on a mac you can use applescript to do this. (it may also be possible on Windows –  I don’t know) Basically, what I did is create a loop to go through my records.  Then essentially I copied the contents from the field and pasted them in my application.  …

    Read More

    You May Also Like

    Hopewell

    10/17/2023

    The Savior Makes All Things Right

    04/13/2014

    Have you ever wanted to Quote in a calculation field?

    07/10/2014
  • Computers,  FileMaker

    Hosted FileMaker File Make Pre Upload Tips

    07/10/2014 / No Comments

    Before you upload your FileMaker database to be hosted check the following: Open File > Mange > Security Click Privilege Sets and the privilege set you want to edit. Edit “Access via FileMaker Network” to be checked.  This will allow you remote access for FileMaker and FileMaker Go. If you want IWP, check the “Access via Instant Web Publishing”. Now your file is ready for us to host!

    Read More

    You May Also Like

    XML parsing error: whitespace expected

    07/10/2014

    Gabe JV Football Videos

    05/02/2025

    Unicode Information

    07/10/2014
12

Menu

Recent Posts

  • Gabe Freshman Highlights
  • Gabe JV Football Videos
  • Gabe Mission Photos
  • ExecuteSQL Show 1 Row of Search Results
  • Multi Join FileMaker ExecuteSQL Query

Categories

  • American Fork
  • Baseball
  • Bitcoin
  • Blog
  • Brigg
  • BTCPayServer
  • Computers
  • Documents
  • ExecuteSQL
  • FileMaker
  • Football
  • Football
  • Gabe
  • Gardening
  • General
  • Laugh
  • MacOS
  • Mission
  • Moodle
  • MU Wordpress
  • Music
  • OS X Server
  • Plex
  • Religion
  • Rugby
  • Shipley
  • Spencer
  • Sports
  • Wordpress
  • WPLMS

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org