Jump to content

Josh Ormond

  • Content Count

  • Joined

  • Last visited

  • Days Won


Josh Ormond last won the day on April 1 2019

Josh Ormond had the most liked content!

Community Reputation

116 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

19,803 profile views
  1. 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
  2. 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.
  3. 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 pass to the AppleScript command. world - string for inside the escaped quotes to feed into AppleScript. \\ - an escaped backward slash, that reduces to a single backward slash when evaluated by FileMaker. \" - an escaped quotation mark, that pairs with the previous backward slash, to form an escaped quotation mark to pass to AppleScript. \" - another escaped quotation mark to close the string to pass into the AppleScript command. " - closing quote required for text in FileMaker. Visually it looks like this ( red characters reduce down when evaluated in FileMaker 😞 "display dialog \"Hello \\\"world\\\"\""
  4. 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.
  5. This looks like a driver issue on your machine. I don't see anyway this is related to FileMaker.
  6. 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.
  7. 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 ).
  8. Yeah, I get the approach. I've always appreciated your focus on the issue itself, and not the surrounding. It's partly why I didn't post the version I am using. As for understanding, I do understand how it works. I also ran it through a bunch of unit tests and saw how it breaks. We work with some junior devs that sometimes need to just copy and paste code from other sources to make something work. I both walk them through how and why, but I also don't have the time to chase minor bugs that take up precious time later. That is the reason for the unit tests. I try to make it as simple as possible, but not any simpler. My purpose of bringing it up was to prompt other readers to understand how it works. The default behavior, by most, would be just to throw 2 lists at it, and then complain it doesn't work. You and I, both, know that is the common behavior.
  9. Honestly, I would be hard pressed to find a regular scenario where they would not be unique also. However, I've already run into a scenario where it ( read by someone else ) was used in a way that presented duplicates and/or extra returns. I tend to try and guard against that, if it's possible and doesn't present other issues. In this case, running UniqueValues ( ) on both lists and removing any extraneous CRs is worth it to me. And doesn't carry a lot of extra weight. And I completely agree with your last comment. The use-case for this is not retaining duplicates.
  10. Looks like you also need to make sure the 2 lists are also unique. Duplicate values in either of the lists break the result.
  11. https://www.briandunning.com/cf/193 For that, I usually either script it, or use this Custom Function from Ray Cologon. Probably other ways to handle it, but I know this works.
  12. What happens if you open cmd and run the command manually? It's also possible there is some odd character or string that I didn't account for, because I didn't run into it.
  13. Try this. We may need to modify this a bit if you have someone running on Windows 7. The command may be a little different. One thing I, personally, don't like about this approach is that is uses the clipboard. Other options to make this work: write the result to a file, instead of the clipboard, and import the file. Read the data that way. use the BaseElements plugin, or your preferred plugin, to execute a system command. This way you can save the result directly to a variable. Anyway, hopefully this gets you moving in the right direction. MonitorInfoTest.fmp12
  14. For starters, why are you trying to do this with Groovy? And exactly what are you trying to do. You mention 2 screens, but not what you are trying to do. We need more details to help guide you. Also, while we can help guide you, the main purpose of the forum is not to build it for you, it's to help guide you and explain things you don't understand.
  15. It will be interesting to see exactly what happens. A colleague is at DevCon and had a nice chat with Srini Gurrapu ( the new VP of Product Design and Development ), and he talked about the vision. At this point, there are a lot of possibilities. He was very open and honest about what they are striving for. I’m sure we will see more come through official channels as they work through that vision. It’s clear. Both Brad and Srini are shifting things into high gear.
  • Create New...

Important Information

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