Jump to content

Josh Ormond

Moderators
  • Content Count

    980
  • Joined

  • Last visited

  • Days Won

    29

Josh Ormond last won the day on September 10

Josh Ormond had the most liked content!

Community Reputation

121 Excellent

About Josh Ormond

  • Rank
    Director of Structural Entropy

Profile Information

  • Title
    Senior Developer, FileMaker Certified
  • Industry
    In-house
  • Gender
    Male
  • Location
    Rochester, NY

FileMaker Experience

  • Skill Level
    Expert
  • FM Application
    19

Platform Environment

  • OS Platform
    Mac
  • OS Version
    High Sierra, Mojave

FileMaker Partner

  • Certification
    15
    16
    18
  • Membership
    FileMaker TechNet

Recent Profile Visitors

20,962 profile views
  1. 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?languag
  2. 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
  3. I absolutely do. There are options once you click buy. I agree, it's not a very intuitive design.
  4. Why is it embarrassing? They are two very different things. At the very least, it's a one-time purchase vs a monthly subscription.
  5. 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.
  6. https://www.elemental-fm.com/ Also lots of places to get them, but these ones are already set to work with FileMaker.
  7. 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.
  8. 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
  9. 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.
  10. 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.
  11. 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
  12. See if something like this works: "file://" & Get ( DocumentsPath ) & "fileName.pdf"
  13. 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
  14. 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
  15. "text" & ¶ & "more text" or List ( "text" ; "more text" )
×
×
  • Create New...

Important Information

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