Jump to content

Josh Ormond

  • Content Count

  • Joined

  • Last visited

  • Days Won


Josh Ormond last won the day on February 26

Josh Ormond had the most liked content!

Community Reputation

119 Excellent

1 Follower

About Josh Ormond

  • Rank
    Director of Structural Entropy

Profile Information

  • Title
    Senior Developer, FileMaker Certified
  • Industry
  • Gender
  • Location
    Rochester, NY

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    High Sierra, Mojave

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet

Recent Profile Visitors

20,367 profile views
  1. If you use a path like @comment pointed out, it will work. I typically use a custom function for this process that handles the path for me, and I neglected to show the adjustment to the path. But it does work with that path he showed. "file:///" & Let ( [ path = Get ( DocumentsPath ) ; transformPath = Substitute ( Get ( DocumentsPath ) ; "/" ; "¶" ) ; listCount = ValueCount ( transformPath ) ; adjustedList = MiddleValues ( transformPath ; 3 ; listCount - 2 ) ; newPath = Substitute ( adjustedList ; "¶" ; "/" ) ; result = newPath ] ; result ) & "fileName.pdf
  2. See if something like this works: "file://" & Get ( DocumentsPath ) & "fileName.pdf"
  3. Well, your experience kind of confirms that the problem is on your machine. It’s is likely one of the 4 main bottlenecks. Processor, Memory, Disk I/O, Network. Any of which could be taking a hit from FileMaker processing a request, or some other process on your machine using up the resources. The consumer OS isn’t optimized for shared resources. One thing to check is plugins. Or other applications that may have a memory leak. Disk space? How much free space do you have? How large are the database files? What kind of processor do you have? Some of these questions a
  4. One of the first things you learn when hosting a file, don't host it on a machine being used as a workstation. FileMaker is doing a lot. So any tasks you are performing on your machine, take resources away from FileMaker being able to serve data. Here are some other tips: https://support.filemaker.com/s/article/Optimizing-network-performance-for-shared-databases-1503692929962?language=en_US
  5. "text" & ¶ & "more text" or List ( "text" ; "more text" )
  6. Spawn a regular window off-screen. Pop the card window from that. Then the user can't move. It will need to be based on it's own file, or the user won't be able to do anything else with any window. Generally, I'm not a fan of forcing things on the user, unless absolutely necessary. So you will need to consider if that's really necessary vs just having a floating window they can place where they want. You may also need to do some dancing to make sure scripts don't inadvertently take over that launcher window. A separate file can go a long way in making that management easier.
  7. You will need to loop through the list in some way. How you do that depends a lot on what you are doing with them after. The easiest way for you may be a script. Essentially, you can get to something similar this: hex2num ( GetValue ( $hexList ; $valueNumber ) ) Here is what a script may look like: Set Variable [ $hexList ; Value: Substitute ( "0000 000D 002D 004C 0069 0084 009E 00B6 00BC 00BD" ; " " ; ¶ ) ] Set Variable [ $hexCount ; Value: ValueCount ( $hexList ) ] Loop Set Variable [ $valueNumber ; Value: $valueNumber + 1 ] Set Variable [ $currentNumber ; Val
  8. How long is the timeout using Insert from URL? Isn’t it the typical 60 secs?
  9. This is one of those cases where I, personally, prefer to pay for a service like NRGSoft. Those APIs change enough, where I don't want to have to go figure out why something is broken, because "Surprise" FedEx changed something. Plus Andy has all that stuff figured out, no reason for me to torture myself. LOL
  10. FileMaker, through External SQL Sources ( ESS ), is only compatible with specific databases. https://support.filemaker.com/s/answerview?language=en_US&anum=000023433 You can do Imports/Exports through ODBC, but I've honestly never done that a lot, especially in the modern world where you can use an API to get/move data around to or from other services.
  11. Enter this into FileMaker's calculation dialog ( in the 'Calculated AppleScript' dialog ). "display dialog \"Hello \\\"world\\\"\"" " - opening quote required for text in FileMaker display dialog - applescript command \" - escaped quote mark reduces to a " when evaluated by FileMaker. Hello - the string to appear inside the quoted string being fed to the AppleScript. \\ - an escaped backward slash, that reduces to a single backward slash when evaluated by FileMaker. \" - an escaped quote, that pairs with the previous backward slash, to open the string to
  12. What version of FileMaker are you using? Do you have FileMaker Pro or FileMaker Pro Advanced? Couple of notes: If you update your profile with the version you are using, that gives us a reference point to better answer your questions. If you are using v17 or 18, there is ONLY FileMaker Pro Advanced. And you have to go into Preferences and check the box, "Use Advanced Tools". Then restart FileMaker. You will then see the "Tools" menu.
  13. This looks like a driver issue on your machine. I don't see anyway this is related to FileMaker.
  14. FileMaker places a lock on the record as soon as someone starts to edit the data. So it's not possible for 2 people to change the same record at the same time.
  15. I do agree with you about the duplicate values and discussions on the forums. For the most part, I handle all the other error checking and rule handling in scripts. It's easier to debug, and provide feedback that way. The GetAsNumber ( input ) thing is a different discussion. But that's for another thread. FileMaker's datatype casting has some inconsistencies, especially when dealing with the JSON functions, and also some variable passing ( if you use dictionary functions ).
  • Create New...

Important Information

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