3 Replies Latest reply on Jun 23, 2016 9:24 AM by ninja

    Formula/container on FM Server

    Uwe_Jourdan

      Filemaker Advanced 14

      Filemaker Server 15

       

      Hi,

       

      I'm using a fomula field, result container, creating a relative path and file name:

       

      "Image:Folder/Subfolder/" & image.jpg

       

      This works in the local database. Of course it doesn't when the database is on Filemaker Server and the image files are placed in: databases/Folder/Subfolder, even when the folder containing the images is a shared one. The container shows: image.jpg not found.

       

      How must the path look like please?

       

      Thank you!

       

      Uwe

        • 1. Re: Formula/container on FM Server
          TSPigeon

          Uwe_Jourdan:

           

          Thank you for your post!

           

          If I understand, you are doing something similar to a reference -pulling the Container Data via a Text Calculation. You might want to check into Storing container field data externally as an alternative when hosting on FileMaker Server.

           

          Also, I am going to move this thread from the FileMaker Community Feedback Space, which is specifically for input on the Community itself, to the Discussions Space where you should receive more views and potentially more advice!

           

          TSPigeon

          FileMaker, Inc.

          • 2. Re: Formula/container on FM Server
            Uwe_Jourdan

            OK, thanks.

             

            Von meinem iPad gesendet

             

            Am 23.06.2016 um 16:43 schrieb TSPigeon <noreply@filemaker.com>:

             

            Formula/container on FM Server

            reply from TSPigeon in Discussions - View the full discussion

             

            Uwe_Jourdan:

             

             

             

            Thank you for your post!

             

             

             

            If I understand, you are doing something similar to a reference -pulling the Container Data via a Text Calculation. You might want to check into Storing container field data externally as an alternative when hosting on FileMaker Server.

             

             

             

            Also, I am going to move this thread from the FileMaker Community Feedback Space, which is specifically for input on the Community itself, to the Discussions Space where you should receive more views and potentially more advice!

             

             

             

            TSPigeon

             

            FileMaker, Inc.

             

            Reply to this message by replying to this email, or go to the message on FileMaker Community

            Start a new discussion in Discussions by email or at FileMaker Community

            Following Formula/container on FM Server in these streams: Inbox

            Manage your email preferences

             

            FileMaker Developer Conference 2016 • Las Vegas, Nevada • July 18-21 • www.filemaker.com/devcon

            • 3. Re: Formula/container on FM Server
              ninja

              Howdy,

               

              If you do store the image externally (via the container field setting), you can grab the path right from the container field itself.

               

              I use the following calc to put the path into a variable that I can then use to open it using the desktop temporary path on the client computer.

               

              Set $Path Variable to:

               

              Let([

              RemoteFile = GetAsText(SDS Product::SDS pdf Container);

              L = Length(RemoteFile);

              P = Position(RemoteFile ; ":" ; 1 ; 1) ;

              Filename = Right ( RemoteFile ; L - P )

              ] ;

               

               

              Get ( TemporaryPath ) & "/" & Filename

              )

               

              Then Export field contents of the container to $Path.

               

              If all you want is the path where the file is.....just use the GetAsText( yourcontainer) part...