Yes, you can put a Mac path there, either as another line, or instead; I do instead. There is a useful function which lets you tell which platform the user is on. There's different ways to set up the calculation, but the below is likely the easiest to understand. You will need to put the name of the volume which the Mac sees the mounted shared volume as (where I put "volume name" in the path).
Go to a Mac and see what the mounted volume name looks like. (Hopefully it is not the default "Macintosh HD", otherwise you'll want to change to something more unique.)
Others may have a better idea, but this method works for me. The calculation should have its Storage set to [x] Do not store, otherwise you'll be bloating the file with this long path in each record.
not IsEmpty (Contestant Master::Name);
Abs ( Get (SystemPlatform)) = 1; // Mac
"imagemac:/volume name/Database/Filemaker/Filemaker 9/Web/Contestant Pics/Season 2/" & Contestant Master::Game ID & "/" & Contestant Master::Name & ".jpg" ;
"imagewin:/Z:/Database/Filemaker/Filemaker 9/Web/Contestant Pics/Season 2/" & Contestant Master::Game ID & "/" & Contestant Master::Name & ".jpg"
That's working like gangbusters!
Thanks so much for the help
This sounds similar to the other discussion posted on this forum: http://fmforums.com/forum/showtopic.php?fid/30/tid/209663/
I've tried this method but can't get it to work. I think I might be setting up the lookup container incorrectly or maybe my path will be different. Is there any documentation available for setting up these type of containers and calculations?
Any help would be greatly appreciated!!!
Thank you for your post.
What happens when you try to get this to work? Do you get an error message? Does it show for some files? What type of file are you trying to display?
Any additional information you can provide would be helpful in narrowing down the cause.
Thanks for the reply TSGAL,
I get an error message saying the file can not be found. This happens on the PC side. We are saving references to PDFs, some are small in size and some are rather large so storing them in the container is out of the question. MAC users aren't having any problems opening the files as most of our company uses MACs but we have a few that use PCs and need to access the files as well. I hope this helps.
You'll need to debug the differences between the file path to the file on the mac system and the filepath to the same file on the windows system. Obviously, theres some difference in the paths. It could be as simple as the path on the windows side starting with a drive letter like D: and not on the Mac.
Thanks for the reply. That sounds exactly like what I need to do but I am new to filemaker and have no idea how to do that. Any suggestions? I'm using FileMaker Pro 10.
Well, I can give you a method for comparing the path to a file inserted from the Mac to a path to the same file inserted from windows.
Let's say your container fields are simply named "containerMac" and "containerPC".
Define a calculation field for each that exposes the paths:
For cMacPath, simply enter the field name for the container, containerMac and set the calculation to return a text result (Popup in lower left corner of specify calculation window).
Do the same for cPcPath but select the containerPC field.
Now place all four fields on a layout. Make cPCPath and cMacPath fields several lines of text tall so you can see all the text that'll appear in them.
Use a mac to insert a file from the shared drive in containerMac
Use a pc to insert the same file into containerPC
Examine your path fields to see how they differ.
From there, you may be able to devise a calculation field that detects whether or not the current computer is mac or windows and computes the appropriate file path for that platform. (Look up Get (SystemPlatform) for a method that detects whether the current computer is mac or windows.)
I'm not able to get this to work - any advice on what I could be doing wrong?
You can open the files (PDFs?) on the PCs?
If not, that is the first step.
Once you can open them, you can see the path by a number of methods, perhaps the easiest is using a find file utility for windows called "Everything", this will display the filepath.