Fitch

Another options is https://360works.com/supercontainer/ It's a great product, great company, and I've used it in the past, but have found external container storage does the job for me most of the time these days.

Five GB doesn't seem all that big, we work with much larger files. Regarding your options: 1. Sure, you could export field contents and re-import. You'd want to test a few files to see how much you'd really save. 2. How would this change anything? You're still dealing with the same 2000+ PDFs. If you don't have to encrypt the files, I would lean towards open storage. An advantage of encrypted, other than the obvious security, is that it deals with creating the folders. With open storage you'll need to handle that, but it's a one-time setup that's fairly straightforward.

There's no simple way to do it, but you might be able to achieve this with a web viewer, something like: https://www.sloperdata.com/demos/easy-filemaker-quill-integration

Not bad, although a bit over-engineered for my taste. Thank you for sharing. FYI the "second" layout calc's object name is "first Copy" so it fails to refresh.

The term you're thinking of might be, not magic key, but 'multi-key.' It can indeed be quite useful, not only for going to related records, but displaying those records in a portal.

Consider using a block of text on the layout, you can format it in red or something so it stands out, and then apply a hide condition to it: Case( Grade <> 11 ; 1 ; not IsEmpty(Voucher) ; 1 ; 0 ) 1 and 0 are shorthand for True and False. When either of those conditions are true, the alert text will be hidden.

Possibly you were sent a link to a page for downloading your software? If so, go to that page and it should have download links for any version your license covers.

I've gone down the UID road and have gone back to using plain 'old school' serial numbers. I would only use UIDs when there's a scenario that warrants it, e.g. certain syncing situations. YAGNI

Not quite clear what this is about. Screenshots might help.

I'm not sure I fully understand the setup here, but one alternate approach you could try is to script a Find for the crew records you want to display, then grab their IDs and put them in a global field, then use that global field to drive the portal's relationship. You wouldn't need to apply a filter at that point.

Short answer is no, long answer is "it depends." I think you may find this helpful:

If you don't see the Enable/Disable command in the Edit menu, open the Preferences dialog and select the 'Use advanced tools' checkbox, then quit FileMaker and re-launch it.

I agree that it's not cost-effective to re-invent the wheel. That said, you sound like a person who enjoys tinkering and learning. In which case, you will learn a lot by building an accounting system. You need to think about not just FileMaker, but how to structure things. Many people have spent lots of time thinking about this. See for example: https://martinfowler.com/eaaDev/Account.html My advice is to start by building The Simplest Thing That Can Possibly Work, and iterate from there. Also, you're making life more difficult by using such an old version of FileMaker. And it will make it more difficult for us to help you here. Not only do newer versions have useful new features, but security is much improved in newer versions of FileMaker. You claim to be concerned about security. So, save yourself some aggravation and upgrade!

Thanks for clarifying, sorry I can't help you there.

Do you mean how to set it with a script? First you need to find out what value is assigned to the checkbox by its value list. E.g. is it "yes" or "1" or what. Then you simply use the Set Field step. Not sure why this is in the MBS forum.

It works, thanks Stephen! We'll have to compare notes sometime.

Nice! I actually made one too but it's not fully polished. Any chance you could release a version for FM18? Or does it require some feature of 19?

First you say "no I am not" -- as in no, you can't get to the server admin page? And then you say... "I got to the admin page..." Then you mention the admin password for FM, and I think here you're talking about the password for a particular file? That's different than the password you'll need to log in to the FileMaker Server admin console. You can indeed remove the admin password from a file -- but only if you know the admin password. This is a feature for securing a file, it's not going to be helpful for you here.

Are you able to reach the admin start page? You should be able to launch the admin console from there. It is a java app in version 12. You'll have to google or search this forum for the exact java version needed. If you don't have the server admin login info though, it won't do you much good.

Hard to know where to start here. 1. The title of your post is confusing. Version 9 of FileMaker Pro cannot open fmp12 files and version 9 of the server cannot host them. 2. "multiple copies of this file, in multiple locations" - what does this mean? If you're hosting a file on a server then there would only be one copy of it. Do you mean that each user has their own local copy of the launcher/menu file? 3. Perhaps you want to take a look at Editing external FileMaker data sources

Interesting, thanks for that. Our IT guys do it manually. There's one dept. in charge of renew/retrieving the certs, then they give it to the database server admins, who actually install them. I can do most tasks in the FMS admin control panel but don't have permissions for this. Such is the world of state government.

Sorry, I have no more ideas. I can tell you we've had a similar experience trying to upgrade from 18 to 19 on Windows. Very frustrating. We had to roll back to 18. I'm 99% sure it's a certificate issue but it's hard to troubleshoot when you don't have spare servers lying around.

Tried restarting the whole server? Tried re-installing your SSL cert?

Starting with 18.02 you have to install your own JRE. But it should have prompted you to install it when you enable the WPE in the admin console.