Jump to content

Josh Ormond

  • Posts

  • Joined

  • Last visited

  • Days Won


Josh Ormond last won the day on September 10 2020

Josh Ormond had the most liked content!

Profile Information

  • Slogan
    Director of Structural Entropy
  • Title
    Senior Developer, FileMaker Certified
  • Industry
  • Gender
  • Location
    Rochester, NY

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Mojave, Big Sur

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet

Recent Profile Visitors

21,874 profile views

Josh Ormond's Achievements


Mentor (12/14)

  • Dedicated Rare
  • Week One Done
  • One Month Later
  • One Year In
  • Conversation Starter

Recent Badges




Community Answers

  1. What version of FileMaker are we talking about here? Your profile says '11 Advanced', your question references "FileMaker Pro 9". Either of those versions are really old... that may be the reason. Also keep in mind that sometimes ( a lot of the time ) the syntax of the commands are case-sensitive. Make sure that is correct. Next: If you paste the text of the command you are trying to run in the command line, does it work? Ultimately, FileMaker just hands off the command to the operating system, so there is not a lot of complexity in that leg of the action. Can you give us a sample of what the argument looks like? What are you expecting the action to do? You mention the path of the script to run, and you mention what shows up in the cmd window, but don't tell us if that is right, wrong, or no related.
  2. How consistent is the input? is 'posterOffset' always after the 'value"? are there ever double quotes inside of the value itself? There are several ways to do this, and I know others will pop in with some excellent suggestions. They may range from finding the beginning and end of the 'value' portion of the text, to looping through each character to be more dynamic in figuring out where the end of that string is. The answers to the above questions may help other decide which type of solution to provide.
  3. It's probably going to end up hurting you down the road to try and do this with ExecuteSQL. That's not really what the function was intended for, and can have some serious performance degradation under specific circumstances. There are several ways to accomplish what you want to do. Take a look at this and see if it helps. Also, take some time to run through the courses on the Claris Academy. They will help fill in some blanks about features available in FileMaker for this type of thing. https://support.claris.com/s/article/Simple-example-of-a-subsummary-report-1503692935845?language=en_US
  4. Over WAN, having the JSON already set can often create a significant performance increase on complex JSON. When I can, I'll actually push this to a separate table, if it's in a system or file that I already have handling CRUD operations with a transaction. It's part of an overall development pattern. With that, it can be easily used with script parameters, external APIs, scripts, calculations, error trapping, etc. It is all about controlling WHEN the user has to wait for the actions to happen. If I can, without compromising data integrity, have those actions happen when the user is sleeping, that's the route I go. Forcing a wait time when the user expects there to be a wait is ideal.
  5. I absolutely do. There are options once you click buy. I agree, it's not a very intuitive design.
  6. Why is it embarrassing? They are two very different things. At the very least, it's a one-time purchase vs a monthly subscription.
  7. The reference in the help documents about the script step not being compatible means that it wasn't tested to work, or you will experience issues, not necessarily that it would never function at all. As you have found, it may or may not work without warning.
  8. https://www.elemental-fm.com/ Also lots of places to get them, but these ones are already set to work with FileMaker.
  9. Just note that Google has deprecated that option. So I wouldn't put too much time into building your features based on that option. In most GSuite accounts, it's already disabled.
  10. OAuth isn't quite as easy as flip on an option. At least not when you are dealing with sending email. Your next option then, is to have your clients set up an app password. You will be responsible for securing it if you store it. This is better than storing the user's actual account password, but will require some diligence on your part to make sure no can get direct access to that password. https://support.google.com/accounts/answer/185833?hl=en
  11. 18 will not be able to connect to FileMaker Server 15 either. https://support.claris.com/s/article/System-Requirements-for-FileMaker-Pro-18-Advanced?language=en_US About half way down are the versions it can connect to.
  12. It is a security change with Google, and Gmail. You need to either authenticate with OAuth, or use an App Password. The user has to set up the App Password to use with their account. We recently experienced the same thing. If your clients have a business account with google, they can setup the SMTP relay and use that, by allowing only their IP addresses to send email.
  13. 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"
  14. See if something like this works: "file://" & Get ( DocumentsPath ) & "fileName.pdf"
  15. 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 are easier to track and monitor with FileMaker Server. Just to add a note to this, this is the user licensing. It is an annual cost. You don’t get server if you just buy individual copies of FileMaker Pro.
  • Create New...

Important Information

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