David Jondreau

  • Content count

  • Joined

  • Last visited

Community Reputation

75 Excellent

1 Follower

About David Jondreau

  • Rank

Profile Information

  • Gender

Contact Methods

  • Website URL

FIleMaker Profile

  • FM Application
    13 Advanced
  • Platform
    Cross Platform
  • Skill Level
  • Certification
  • Membership
    FileMaker Business Alliance

Recent Profile Visitors

14,170 profile views
  1. When you make a new window, the current layout is reloaded and the OnLayoutEnter script trigger fires. The Orders List layout's triggered script ends in Halt Script[]. The Halt Script[] script step ends all running scripts, such as the new window script, so you never get to the Go to Layout[]. Use Exit Script[] in place of Halt Script[] in the Order List OnLayoutEnter triggered script.
  2. Is there a good way to rename files? And did the behavior of SCMove() change recently. A few months ago, I was testing using SCMove() to rename a file SCMove by using the same filepath for the old and new paths, but adding a filename parameter SCMove ( filepath ; filepath ; new.filename ). I thought I had it working ok. I let the project sit for a couple months and just came back to it and now it's not working. I'm second guessing myself that I ever had it working in the first place. But it looks like SCMove() may have changed, now accepting key/value pairs rather than just a filename. I've tried it both the old way and with filename= and neither works. My goal is to rename the file. Is there a better approach? Related for my purposes...does SCMove() delete the old filepath's folders? Or are they still there in the filesystem? Thanks!
  3. Could you clarify the use for this? Maybe post an example? I like where you're going, but I'm not sure what you're doing? Is this basically adding a "graphic" to a popover?
  4. I believe if a user without layout modification privileges modifies a table view, that view will neither persist past that session nor change for other users. It seems like a reasonable accomodation.
  5. Filemaker is really moving away from this. They don't want you running your own business where you control the licenses for your customers. They want the customer to be buying the licenses.
  6. I don't know what Show Custom Dialog will do for you. You're running the script via CWP. Show Custom Dialog isn't a supported script step. 1) Post your FileMaker script 2) How do you know the script is succeeding, just not the parameter? 3) If that's true, there may be a problem on the FM script side, not the PHP side.
  7. Keep in mind, more than one script can have the same name. That may cause a problem in getting the script ID using Design functions.
  8. This is not a simple request. It is probably possible using AppleScript and some native FileMaker scripting, but I haven't actually done it.
  9. Unfortunately, @ is a special symbol in find mode. Quotes works. Also changing the fields storage settings to Unicode (though then upper and lower case letters will be treated differently). It's a problem.
  10. Excellent points, Steven. I think there's something to be said for asking *someone else* to hack your file. Developers have their strengths and weaknesses. We have our blindspots, especially about our own work. I have mixed feelings about File Access Filtering. File Access Filtering is good, but has a major weakness. It makes it really easy for a threat agent to test out user/pass combination. A hacker can enter one user/pass and server then tests that against all accounts on all files on the server. And it's trivial to see if there's a file with a valid Guest account on the server. Without FAF, you have the threat of a hacker seeing all the files, but they would have to test user/pass on a file-by-file basis and those attempts would be logged by FMS. As far as I can tell, user/pass attempts for FAF are not logged. So...why list at all? FMP gives us the option not to by not displaying in the Launch Center at all! Developers should prevent the file from displaying in the Launch Center using the file's Share with FileMaker Clients... settings.
  11. I thought the same thing while reading the pdf. There is the cost of the license itself, yes. But there's an additional cost of spinning up a new machine (virtual or otherwise) and sysadmining it. I used to be a "FileMaker Commercial Hosting" provider for my development clients. I got out of it though. It was too much hassle. I pushed everyone off onto other, bigger operations. Clients don't want to handle managing their own server, with backups and OS upgrades, blown ethernet cards, etc. So, even if the cost went up $30 a month for their own license of FMS but still on a shared server, I would recommend they do it. Because it's going to be an additional $10-$30 a month on top of that for a machine....If EULA allows, which is unclear. But that would be a $30 waste since there's only a nominal benefit to the client. Maybe there are other options they haven't announced, like a free FMP client and all costs are server connections, or an FMI hosting service!. Who knows. But if FMI makes no other changes to their pricing or business model, and only does this one thing, basically killing shared hosting, then I think that will drive a lot of small-fry operators off of FileMaker. Maybe that's best for FMI and I respect their choice.
  12. Steve (or anyone), Wasn't there a place for developers to sell solutions on FM Forums? Like an App Store for FileMaker? Is that still around?
  13. Sounds like a serious problem. And frustrating! It's unlikely upgrading from 12 to 13 would cause data loss. And it is difficult to help with such a vague problem. Are you hosting using FileMaker Server? How is the database being hosted (3rd party, in house)? What are the specs on the hosting machine? Who is responsible for ensuring there is access to it? Are Go users doing data entry locally, then syncing or are they using the server live? Is all data missing or just some? If just some, is it certain users or certain times of the day? If you drop FileMaker, what is your plan for transferring data and ensuring that the new system works? What if when the new system doesn't meet expectations? There are probably 30 questions like these a FileMaker consultant will ask you, and the questions will depend on answers to previous ones and many of the questions will come up based on actually reviewing the database itself. Doing that sort of back and forth asynchronously on a forum isn't a good use of time. In Columbus, I recommend Joe Simpson: http://radicalappdev.com/contact-2/
  14. I have a client that has a server full of image files (jpgs, pdfs, tiffs, etc). They have a FM14 database being served on FMS 14 (Windows Server 2012). They are accessing the server from FMP 14 clients on Macs and Windows. They want to link records in a database to the image files. The want to start from a record in their client FMP, open up a dialog that allow them to search the server machine and choose a file that will be linked to that record. Later they want to go to that record and view the file. Storing the files as containers won't work as the files will be edited (but their filepaths and names won't change). And the filepaths and names have a strict naming convention that can't be changed. How would you accomplish this?
  15. I was bored...here's on way to create the font.size used in the TextSize() function. It'll give you a whole number between the max.size and min.size. field.size represents the number of characters that you want and still have the max.size font. Let( [ field.size = 50 ; max.font = 36 ; min.font = 6 ; text = table::field ; text.length = Max ( Length ( text ) ; 1 ) ; size.diff = max.font - min.font ; adj = ( field.size / text.length ) * max.font ; font.size = Min ( adj ; max.font ) ; font.size = Max ( min.font ; font.size ) ; font.size = Round ( font.size ; 0 ) ]; font.size )