Container Field Reference Path Modification
FM newbie here.
I have an environment where FM Database of about 1,200 records is accessed by both Windows and Mac users.
I set up a container field that references a picture file on a local shared server.
Currently, on a Mac, the file path looks like below:
I'm trying to get the pictures for each record to appear on Windows platform.
From doing a little research, I understand that there needs to be a Windows compatible path, as such:
Am I correct in assuming that the container field for each record must contain the following two lines of text?
How do I replace the current Mac-only path with two lines of reference path?
Find&Replace doesn't seem to work because there are 1200 different SKU names and paths.
Any help would be appreciated.
Thank you, in advance.
Create a calculation field with container result that uses one path if mac and another if PC. You can check to see if its a mac or windows by using Get ( SystemsPlatform )
Case ( Abs( Get ( SystemPlatform ) ) = 1; "filemac:"; "filewin:" )