3 Replies Latest reply on Apr 3, 2009 6:35 AM by TSGal

    Calculation Update for remote open

    GDstudio

      Title

      Calculation Update for remote open

      Post

      I have a calculation field that automaticically selects the correct name based on an If function.  It works great when the file is opened locally.  However, when the file is open remotely over the network the calculation fields are blank.  Even stranger, once a single related field is manipulated on the remote computer, all the calculation fields for all records populate.  Why is this performing differently when the file is accessed remotely?

        • 1. Re: Calculation Update for remote open
          TSGal

          GDstudio:

           

          Can you tell me more about the If () function, and what fields are involved?  Are you using global fields?  (Global fields work independently for each FileMaker Pro client.)

           

          TSGal

          FileMaker, Inc. 

           

          • 2. Re: Calculation Update for remote open
            GDstudio
              

            The If() statement is:

             

            If ( Projects::Client_Type = "Individual" ; Contacts_CLIENTS::Full_NAME ; Companies_PRJ_CLIENT::Name )

             

            Projects::Client_Type is a field defined in each record as either "Individual" or "Company"

             

            Contacts_CLIENTS::Full_NAME is a related occurance of Contacts::Full_NAME witch is an autoenter via a calculation field with the following calculation:

             

            Trim ( Title & " " & First & If ( IsEmpty ( Middle )  ; "" ; " " & Middle ) & " " & Last & If ( IsEmpty ( Suffix )  ; "" ; ", " & Suffix ))

             

            and Companies_PRJ_CLIENT::Name is a related occurance of Companies::Name

             

             

            The relationships do involve a global calculation field called _GBL_CLIENT that is set to equal "Client"  - Since it is a caclulated global it should update for each user automatically. Shouldn't it?

            • 3. Re: Calculation Update for remote open
              TSGal

              GDStudio:

               

              Thank you for the additional information.

               

              When a guest opens a hosted file, it immediately takes on the default values of the global fields set by the host.  You can then change the global fields to whatever you want.  However, if you quit and reopen as a guest, your global values will be gone and you will return to the original values.

               

              When you open the file, the global will be equal to the Client of the host.  You may want to change the calculation to a regular field and use a Set Field command instead to force the relationship.

               

              TSGal

              FileMaker, Inc.