David Jondreau

  • Content count

  • Joined

  • Last visited

Community Reputation

74 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

13,942 profile views
  1. 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?
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. This is not a simple request. It is probably possible using AppleScript and some native FileMaker scripting, but I haven't actually done it.
  7. 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.
  8. 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.
  9. 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?
  10. 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/
  11. 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?
  12. 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 )
  13. The function TextSize() combined with Length() as an auto enter calculation could work...
  14. Just one little point...missing UUIDs don't actually determine if the "record" is still there or not, after all, the UUID field can get overwritten! Get (RecordID) helps with that. I suppose you could use an calculation field to hold the UUID. I've never tried that though.
  15. Some thoughts... Using privileges is a worthy idea. I always like to ask, "How do you know what you think you know?" How do you know records were actually "deleted"? Could some data have been changed so those records still exist but aren't showing up in a find? Could a user or script have written over the data, so the record you're looking for is actually another record now? Also, why wait months? Do a weekly check. Or even daily. You could, for example, import all that table's records into a new table each week as a "back up". Then the following week, find all the records that had been created as of the week before and do an import into the back up table, matching on the pk, and "add new". All the new records would be ones that had been deleted and you can compare that list to the the admin approved list. I can think of a couple ways to delete a record without triggering a cascade delete. Primarily if the user doesn't have delete privileges on the child, but does on the adult. Also, if you change data used in the relationship, breaking the link, then delete it. Finally, you do have a UUID field, yes? And Created On, Created By, Modified On, and Modified By fields? And I would recommend a Get ( RecordID ) field as well. It could be helpful in identifying the problem.