Jump to content

the Otter

  • Content Count

  • Joined

  • Last visited

  • Days Won


the Otter last won the day on January 10 2017

the Otter had the most liked content!

Community Reputation

2 Neutral

About the Otter

  • Rank
    second-generation FM developer
  • Birthday 04/10/1975

Profile Information

  • Title
    Technical Lead
  • Industry
  • Gender
  • Location
    Cincinnati, OH, USA

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification

Recent Profile Visitors

2,000 profile views
  1. I’m not sure if this isn’t possible yet or if I’m missing something obvious, but… When I tap in a container field in FMGo, I get an Import dialog that allows me to import from Camera, Audio, etc.. However, the Insert from Device script step requires me to select an option. It’s not like many other script steps, where you can just not specify a source and FM is smart enough to prompt you. Is there any way to script entering a container field such that the Import menu pops up? Thanks!
  2. the Otter

    Blank Web Viewer in FMGO

    Ha! I completely forgot about this thread, and now nine months later, it’s happening again. It’s currently happening with several Web Viewers that display dynamically generated HTML5 (including fairly simple, but extensive, JavaScript and jQuery). They work just fine in macOS Safari, iOS Safari, and FMP16; but not in FMG16.
  3. the Otter

    Export FM Data to DXF

    Hey Lee. Have you heard anything? Thanks so much!
  4. the Otter

    Export FM Data to DXF

    Awesome. I appreciate it!
  5. the Otter

    Export FM Data to DXF

    Hi, Lee. AutoCAD definitely accepts DXFs; if I’m not mistaken, Autodesk invented the format. However, I don’t actually need to integrate with AutoCAD; I need to integrate with a different system that the boss would prefer I not identify, as he’s trying to do something fairly new to our industry. That’s why I need the DXF: it’s what this system will accept. Thanks again!
  6. Since it’s been a few weeks since you posted this, perhaps you’ve already solved the problem, but I would personally use a transparent slide control with four panels: a blank panel, visible by default; and a panel for each request type. Make sure each panel has a name, then have the script switch to the appropriate panel based on which type of barcode is being scanned. The fields will appear and disappear as appropriate. (You can also use hiding, but panels are a lot easier to manage.)
  7. the Otter

    Export FM Data to DXF

    I’ve got a FM16 system that converts raw data (dimensions, etc.) into a SVG floor plan and elevations in the Web Viewer. However, my boss now needs me to use this same data to generate a DXF for integration with another system. Has anyone had experience doing this? I’ve been reviewing the DXF specifications, and it seems unfortunately nontrivial to me. Any guidance would be appreciated. Thanks so much!
  8. the Otter

    Blank Web Viewer in FMGO

    Sorry I can’t help you, but a year later, I’m having the same problem. My Web Viewers render perfectly in FMPA15, but not in FMG15. Anyone…?
  9. Yes, thank you. That’s what I get for typing hurriedly. I have fixed my previous comment.
  10. Thanks, jbante. Actually, the custom function only ignores error #0 if any error (including 0) was previously recorded. However, you are correct that I have apparently misunderstood the issue: I tried a simpler custom function that sets a variable and it was able to pass that variable to the script. Despite my misdiagnosis of the problem, there is still a change in behavior: the first version of the script still crashes FileMaker 14, but not 15; and the second version still fails to set $Error to 0 in FileMaker 15, but not 14. I will update the original post once I have more accurately diagnosed the scenario in which this occurs.
  11. As most people here probably know, the Let ( ) function can be used to define a Local variable. As such, it is possible to build a custom function that defines such a variable, and it is further possible to set said variable to a value including itself. An example would be the following custom function, ErrorList, consisting of the following calculation: Let ( $ErrorList = List ( $ErrorList ; Get ( LastError ) ) ; "" ) If a Set Variable script step sets the same variable as a custom function like the one above, e.g. Set Variable [ $ErrorList ; Value: ErrorList ] …the script step will run appropriately, so long as the contradictory variable—in this case, $ErrorList—is not yet defined. However, once this variable has been defined, executing the preceding script step will cause FileMaker 14 (and perhaps other versions) to suffer an Error #1213 and crash the application. The workaround for this behavior is to have the Set Variable script step set a dummy variable, e.g. Set Variable [ $x ; Value: ErrorList ] Even if $x is not referenced anywhere, having a script call the ErrorList function passes the variable $ErrorList to the script’s own context, thus allowing its value to be accessed by later steps in the same script (including subsequent calls to the ErrorList function itself). In FileMaker 15, this behavior has been changed: local variables defined within a custom function are now valid only within the scope of the function itself, including any recursions. While this alleviates the problem of application crashes, it also results in unexpected behavior when scripts written in earlier versions of FileMaker rely on custom functions to set local variables. When migrating to FileMaker 15, each affected script step must be updated to set the target variable explicitly instead of relying on the custom function to do the work. In other words, the code: Set Variable [ $ErrorList ; Value: ErrorList ] …which proved fatal in FileMaker 14, is now required grammar for FileMaker 15: FileMaker 15 believes that what happens in the function stays in the function, instead returning the result of the calculation to the variable defined in the Set Variable script step. The FileMaker 14 grammar, Set Variable [ $x ; Value: ErrorList ] …thus sets $x to the intended value of $ErrorList while leaving the value of $ErrorList as null. Unfortunately, this cannot work effectively in a mixed-installation environment: the FileMaker 14 grammar leaves FileMaker 15 clients with unintended null values; the FileMaker 15 grammar causes FileMaker 14 to crash. When upgrading all users to FileMaker 15 is not feasible, the best workaround is to use the FileMaker 14 grammar, then once all relevant script steps are complete, check the value of the intended variable (e.g. $ErrorList) and, if empty, set it to the value of the dummy variable (e.g. $x). ErrorTest.fmp12
  12. the Otter

    GROUP BY in ExecuteSQL

    Sorry to resurrect an old thread, but I’ve just discovered that FileMaker 13 does allow you to ORDER BY the same field as GROUP BY. So, this should work: SELECT MAX(citystatezip_id),zip FROM citystatezip WHERE city='Wilmington' GROUP BY zip ORDER BY zip Just FYI….
  13. the Otter

    Extracting data using patterncount

    Aussie John, Ignoring the data cleanup for a moment, how about: If ( PatternCount ( ¶ & List ( "tutor" ; "class" ; "lecture" ) & ¶ ; ¶ & roomname & ¶ ) //end PatternCount ; Roomarea ) //end If Obviously this could be simplified with a custom function, but that’s basically what you’re looking for, right?
  14. If you’re going to be doing this kind of thing often (and if you’re using FileMaker Pro Advanced), it would make sense to use a custom function. However, if you’re just looking for a one-off solution to this specific scenario, we can use the following: Let ( [ startText = "¶Ads¶Company Info" ; sStart = Position ( fieldName ; startText ; 1 ; 1 ) ; sLength = Length ( startText ) ; sEnd = sStart + sLength ; endText = "Map" ; eStart = Position ( fieldName ; endText ; sEnd ; 1 ) ] ; //end define Let Middle ( fieldName ; sEnd ; eStart - sEnd ) ) //end Let Let’s analyze what we’re doing here: The Let function allows us to define variables in our calculation. By using brackets, we can define multiple variables in a single let function. The portions of the code preceded by // are comments and thus optional, but help us read what’s going on here. startText is the text you want to find first. (Note: the pilcrow character, ¶, represents a carriage return in FileMaker calculations.) sStart is the position where the first occurrence of startText appears in the field, starting from the first character in the field. sLength is how many characters are in startText. sEnd is the position of the first character in startText plus the number of characters in startText, so it gives us the position of the first character after startText. endText is the text you want to find second. eStart is the position where the first occurrence of endText appears in the field, starting from the first character after startText. To get the portion of the text you want, we use the Middle function, which takes three parameters: the text string (in this case, the field) you want to search; the number of the first character you want to start with, and how many characters you want to return. In this case, the first character we want to get is the one immediately following the startText, so sEnd (i.e. sStart + sLength); and the number of characters we want is however many characters are between the two strings, so eStart - sEnd. As an aside, you could also simplify this by using a Web Viewer and the GetLayoutObjectAttribute function to get the contents of the web page automatically, instead of copying and pasting. Would this help?
  15. the Otter

    How do you find data from specific field contents?

    Stephanie, Perhaps I’m missing something, but I’m also not getting how the question in this thread differs from the one in the other thread. As was said over there, the answer to question #1 is to create a Calculation field (let’s call it unit_area_pool) with the following calculation: Case ( unit_type = "pool" ; unit_area ) The answer to question #2 is to create a Summary field that displays the total of unit_area_pool. Please let me know if I’m not understanding this correctly.

Important Information

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