3 Replies Latest reply on Sep 19, 2014 6:20 AM by philmodjunk

    Webdirect and global field issue

    pmehta91

      Title

      Webdirect and global field issue

      Post

      Hi 

      I have set some fields as global in filemaker so they appear on all records. When I am in browse mode in filemaker pro it seems to be working fine.

      However, when I am on webdirect, the global fields appear to be blank. 

      Any ideas on how I can fix this?

        • 1. Re: Webdirect and global field issue
          philmodjunk

          It's not due to WebDirect but due to the fact that global field values are specific to each user when the file is hosted over the network. This is true for FileMaker Pro and WebDirect clients of your database.

          See this Knowledge Base article on the subject: http://help.filemaker.com/app/answers/detail/a_id/3604/kw/global

          There are ways to manage this issue that aren't terribly difficult, but you'll need to describe how you are using these global fields first.

          Caulkins Consulting, Home of Adventures In FileMaking

          • 2. Re: Webdirect and global field issue
            pmehta91

            Hi

            Ok I think I have misunderstood how global fields work. 

            I have created some fields, which I want to have a certain value. I want this value to be the same on all records.

            Is there a way of doing this?

            • 3. Re: Webdirect and global field issue
              philmodjunk

              Yes you can probably use global fields, but just control how you assign those values. If, for example, you take the file down off the server, open it in FileMaker Pro and assign values to the global fields, then return the file to the server, all users will see the values you assigned as the initial values of these global fields each time they open the file.

              You can also use a "server side" script--run from a schedule or via "perform script on server" to change the values of the global fields and users will see these new values the next time they open the file.

              Another option is to set up a utility table with a record (with fields that aren't global) for storing the values you want to have in the global fields. Any time that you want to change the value of a field, you edit the corresponding field in this record. A start up script performed with the OnFirstWindowOpen trigger can copy the values from this utility table into the global fields of your solution.

              And you can also set up a single related record by using the Cartesian Join operator (x) instead of the default (=) operator. The data in this record will be the same for every record in tables linked to it in this fashion, but all users will able to see and edit the same value.

              Caulkins Consulting, Home of Adventures In FileMaking