Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Chuck last won the day on November 27 2018

Chuck had the most liked content!

Community Reputation

5 Neutral

About Chuck

  • Rank
  • Birthday 06/16/1971

Profile Information

  • Gender
  • Location
    Hemet, CA
  • Interests
    Software development, history, classical literature, chess, scouting

Contact Methods

  • Website URL
  • Skype

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

FileMaker Partner

  • Certification

Recent Profile Visitors

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

  1. Well, never mind. I got into contact with Goya and the developer tells me that it used to work and now doesn't because of a change they made to what function BE_ExecuteSystemCommand calls, and now it won't allow the stringing of shell commands. So I did it with Keyboard Maestro instead.
  2. I'm trying to use the BaseElements plugin to execute an AppleScript a few seconds after the FileMaker script (the AppleScript creates a DDR using interface scripting and doesn't seem to work when using Perform AppleScript). This used to work, but I think the new security settings for macOS are preventing it from doing so now. The calculation being used to execute the AppleScript is BE_ExecuteSystemCommand ( $_cmd ; 0 ) where $_cmd has something like this: (sleep 2 ; osascript "/var/folders/2d/1p6b7tb14tl_g3rrfjyn_jp40000gn/T/S10/create_ddr.applescript") & If I paste th
  3. Just an alternative that I've used in similar situations, which I find more readable and understandable: First Name: GetValue ( Substitute ( SUPPLIED NAME ; ", " ; "¶" ) ; 2 ) Last Name: GetValue ( Substitute ( SUPPLIED NAME ; ", " ; "¶" ) ; 1 ) Converting text delimited with a specific string to a list often makes parsing it much easier.
  4. I have a client who uses a report of many records. Some of the records could have an image appear before the record's details. Occasionally, depending on the length of the descriptions in the previous records, the image will be split across pages. Turning off "Allow part to break across page boundaries" does solve this problem, but has the unwanted side-effect of producing large amounts of whitespace when it's not needed to prevent this issue. So far the only inkling of a solution I've come up with is to check the report one record at a time, temporarily emptying out the description, addi
  5. I have FileMaker Server 17 running on my local machine. I'm trying to use the command line to backup a single file to a folder in my home folder using the following: fmsadmin backup filename -dest filemac:/Aslan/Users/chuck/project/folder/ Although it's unusual for a command line path to be specified as above, that's how the fmsadmin help backup help text specifies it should be (although I've tried using the standard POSIX path). This always returns (after entering my credentials) "Error: 20500 (Directory not found)". I tired giving the fmserver user the read/write privileges
  6. I've tried committing the records, refreshing the portal, refreshing the window, even entering layout mode and returning to browse mode doesn't fix the problem. It only seems to get fixed when I change the filter calc. I'm familiar with the various techniques published at FileMaker Hacks, but those aren't working because they don't allow for attribute data in the join file. Are there other known technique to accomplish this?
  7. I apologize. I was trying to abstract out the problem from the specifics, and the actual tables would require quite a bit of explanation to get a handle on, but I can present the problem in terms that are, I hope, easy to understand. Make X PERSONS and Y MEETINGS with the join table ATTENDEES. PERSONS and MEETINGS each have primary keys named id. ATTENDEES has two foreign key fields, person_id and meeting_id. People has one table occurrence: PERSONS. ATTENDEES has a TO: persons_ATTENDEES. Relationship between these two is PERSONS::id = persons_ATTENDEES::person_id. MEETINGS has
  8. Three TOs: X with X as base table, x_XY with XY join table as base table, and x_Y~cross, with Y as base table. X related to x_Y with X::id = x_XY::x_id. X related to x_Y~cross with cross join. Goal: portal into x_XY shows linked records, portal to x_Y~cross shows unlinked records.
  9. I have a many-to-many relationship with a join table between two tables, X and Y with join table XY. While viewing a record in X I have a portal of all the join records in XY that are linked to X. I'd like to show a portal of Y of all the records not linked. I sort of have a solution. I have a cross going from X to Y and a filter with the following calc: IsEmpty ( FilterValues ( x_Y~cross::id ; List ( x_XY::y_id ) ) ) This works as soon as I edit the filter calculation, but as soon as records get linked or unlinked, the filter is wrong. If I edit the filter calc, it updates. Refres
  10. I know I've done this before, but can't find an example of the functionality in my archives and can't seem to work out how to do it again. I've got two tables: PERSONS and CONNECTIONS. PERSONS has an `id` field and CONNECTIONS has `person_1_id` and `person_2_id`. There's a relationship from PERSONS to CONNECTIONS with `id` = `person_1_id` and from CONNECTIONS to another TO into PERSONS, connections_PERSONS, with `person_2_id` = `id`, but these relationships may need to change to make this work. On a layout with a context of PERSONS, I need a portal into CONNECTIONS that shows the na
  11. OK, I fixed it, and the process might be interesting. Here's the original calc. Case ( dev.IsSet ( c_score_cache ) ; math.Fractile ( c_score_cache ; List ( prsn_PRSN~cross::c_score_cache ) ; 7 ) ; dev.Nil ) I started unwrapping the custom functions. `dev.IsSet` is just `not IsEmpty` and `dev.Nil is an empty string. Here's `math.Fractile`: // math.Fractile ( _value ; _list ; _pieces ) // Purpose: Return which fraction of a list of numbers the value appears in. // Parameters: _value: The value to get the fractile of // _list: The list of value the value
  12. Commenting out the field's calculation and setting it to `GetAsNumber ( 5 )` worked. The first calc I quoted returned `5¶1¶1¶1` instead of `5¶1¶0¶0`. I did create a new `c_seventh_2` field and copied and pasted the calc, and that failed to work just like the original field. I've been doing all this on a developer field in table view, but going to a user layout shows the same problem.
  13. I thought of that, which is why the first example has the "GetAsNumber" function. But `"5" = 5` returns 1, so that's not likely the source of the problem. And even if it were, that doesn't explain why it's getting the item before the one it should. I can only think of two possible explanations so far. Either there's an esoteric bug somewhere in FileMaker itself or the file is corrupted. But if it's corrupted, then four other very similar fields, differing only in which other field they're referencing, are showing the exact same behavior, which seems unlikely But, you don't see any ob
  14. Can anyone explain how this calculation: List ( PRSN::c_seventh ; Length ( PRSN::c_seventh ) ; PRSN::c_seventh = 5 ; GetAsNumber ( PRSN::c_seventh ) = 5 ) is returning this result 5 1 0 0 The "PRSN::c_seventh" field is an unstored calculation that I've triple checked returns a Number. This arose from a more complicated calc that was returning the wrong value from a list. Let ( [ _levels = List ( "Very Low" ; "Low" ; "Moderately Low" ; "Moderate" ; "Moderately High" ; "High" ; "Very High" ) ] ; _levels &
  15. In a system I built years ago, I register a ScriptMaster function with the following (obviously based on one of the ScriptMaster examples): RegisterGroovy( "PostDataToURL( key1 ; value1 ; key2 ; value2 ; key3 ; value3 ; key4 ; value4 ; url )"; "// Construct data¶ String data = URLEncoder.encode( key1, \"UTF-8\") + \"=\" + URLEncoder.encode(value1, \"UTF-8\" );¶ data += \"&\" + URLEncoder.encode( key2, \"UTF-8\") + \"=\" + URLEncoder.encode(value2, \"UTF-8\" );¶ data += \"&\" + URLEncoder.encode( key3, \"UTF-8\") + \"=\" + URLEncoder.encode(value3, \"UTF-8\" );¶ data += \"&\"
  • Create New...

Important Information

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