Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6867 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hi,

I've got a database containing about 400 staff in my organisation. I'd like to have the facility to select a name from a pull-down menu, and have a picture of the person appear (I expect in a container field) on the layout.

The solution must work on Mac and Windows.

An obvious answer is to store the images within the database. But with 400 images of about 10KB each, this makes the db 4MB bigger than it needs to be. I'd like to avoid this if possible.

Storing the images as a reference seems to be the answer, then. But this has the problem that Mac paths won't work on Windows, and vice versa. To get around this, I thought of creating separate Mac and Windows global paths, then combining that with filenames via a calculation to create valid filepaths for each platform. But I then get myself in a bind in that I want the photo to appear automatically, and not via a script. I'm not sure how this would work.

Is there any way to do what I want? I'd rather not use plugins, but I have the Troi file plugin if that helps.

If it can't be done, is the extra 4MB overhead, due to storing JPEGs in FileMaker, likely to cause me a problem?

Posted

Theres a get function you can user, i think its Get(SysyemPlatform) or something. Anyway, this will return a result of either 1 for pc and 2 for mac or negative of these numbers, i dont remember, but just play with it. You can then in your picture calc just use If(Get(SystemPlatform) = 1 ; win path ; mac path )

Genx

Posted

I can't get that to work. The calculation result (which is set to container) gives a text string with the path, rather than displaying the picture.

Posted

Are you sure you did it right? Are you sure your using imagewin or imagemac at the start of your filepath?

~Genx

This topic is 6867 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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