Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Fitch last won the day on May 19

Fitch had the most liked content!

Community Reputation

159 Excellent

About Fitch

  • Rank
    Imaginary friend

Profile Information

  • Title
  • Industry
    Public health
  • Gender
  • Location
    Portland, Oregon

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    El Capitan and Win 7

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet

Recent Profile Visitors

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

  1. Fitch

    Finding Multiple Records from a List

    First, create a global field, let's call it idList, and then create a relationship from idList to part id. Next, create a script and/or a button with the script step 'Go to related' and specify the relationship you just set up. Now paste your list into the field and run the script/click the button.
  2. Fitch

    Dynamic Portal Sorting

    Still the best method to sort a portal: http://www.fitchandfitch.com/2011/05/filemaker-portal-sorting/
  3. Fitch

    What relationship to use?

    I'd probably use a script to process your invoices and then create records as needed in a Bonus table or something. If you try to do all your accounting through unstored relationships, your system will get slow when you have a lot of records. Using a script also gives you more flexibility in applying the rules that you want.
  4. Fitch

    Case Statement

    It seems redundant to put the true cost in field A when you already have it in field B.
  5. Fitch

    Deployment Advice

    As for workstation space constraints, I've got a Lenovo ThinkCentre on my desk that's not much bigger than an Apple TV. And there are many similar PCs, or the Mac Mini. Can you really not put a PC on the floor? In any case, by the time you add a screen it doesn't seem like the cost would be much different than an iPad -- Apple's got some refurbs in the store today for $309.
  6. Fitch

    Get button action

    Could you give a real-world example of how this would be used? Would this work for you: 1. add a Hide condition to each button that references a $$variable 2. add a triggered layout or record-load script that sets the $$variable Buttons don't have much "self-awareness" so your options are limited I think.
  7. Fitch

    group by and count

    I'd suggest a sub-summary report: 1. Create a summary field that is the count of site_id 2. Create a new layout -- if you select Report, it will walk you through creating the sub-summary parts, or in Layout mode you can go to Layouts > Part Setup to add sub-summary parts 3. Create a sub-summary part sorted by site_id and another sorted by plot 4. Put your summary field on each of the parts 5. Sort by site_id and plot That's it. Welcome to the forums!
  8. Agreed with Barbara. Emphatically do NOT use eSQL for calculated fields, or tooltips, or anything but scripted results. There may be a few exceptions, but that's the general rule.
  9. Fitch

    Useful resources

    Those are good, thanks for sharing. (I wish every article didn't have to be on Medium. It gives me that "you are being tracked" feeling.)
  10. The search menu won't go away. I didn't even do a search. It's overlapping the right hand column. Firefox, Windows 7
  11. That does give you the table name, and adds a reference as "a" -- and all the fields are then referenced as "a.field" ... not strictly necessary here because we're only looking at one table, but it's auto-generated code so it's built to work with one or many tables. When you're looking at the Data Viewer and showing <unrelated...> are you on a layout based on @LineItems ?
  12. Fitch

    Why doesn't this work?

    John, when you say "it doesn't work" what do you mean? Gilbert's idea is a variation that makes your script easier to debug, but wouldn't necessarily change the result. (PS if you use this form, it's optimal to go to Find mode before changing layouts.) One thing you might be missing is a "Set Error Capture [On]" step before the Perform Find. That way you won't get a FileMaker error dialog, and the script should exit as expected. But the user might be confused if you leave them on a layout with zero records, so you may want to handle that before you exit.
  13. You wouldn't use all those ampersands in the query -- the field and table names are part of the literal string. I sometimes like to use this form for readability: q = "SELECT SUM ( interest ) FROM LineItems WHERE a_id_lease = ? AND a_id_tract = ? AND a_id_unit = ? " ; Substitute( q ; [ "interest" ; "ainterestMineralDecimal" ]; [ "LineItems" ; "a@LINEITEMS" ]; etc. )
  14. FileMaker field calculations cannot be recursive, but they can use a custom function (CF), which can be. In your example it's not exactly clear, but I believe Test would be the name of the CF, and EndLoop would be a parameter of the CF. As such, there's an error, because where it says "Test" after the paragraph mark it's missing its parameter. It should be: Let( $i = $i + 1 ; Middle( "abcdefghkjilmnopqrstuvwxyz" ; $i ; 1 ) & If ( $i < EndLoop ; ¶ & Test(EndLoop) ; Let( $i = "" ; "" ) ) ) If you call the CF like this: Test(3) ... the output will be: a b c As it runs, it increments the counter $i; grabs the $i letter from the string, and then if $i is less than EndLoop -- 3 in this case -- it does it again, by calling itself, which is called recursion. Once $i reaches 4, it goes to the end of the If() function -- Let( $i = "" ; "" ) -- what this does is reset the counter $i and return a null result -- because a Let function has to return something, even if it's only null -- and since it does NOT call itself, the calculation is done. It's always important that a recursive function has some kind of logic like that to tell it when to stop. Hope that helps. PS: you don't have to use a recursive custom function, you could try scripting it.
  15. Fitch

    File Access Protection and Import

    File Access controls access to the schema. It won't stop you from importing data -- which you need an authorized account to do anyway.

Important Information

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