4 Replies Latest reply on May 9, 2017 12:35 PM by Jason Wood

    Replace Front End missing fields


      Hi Everyone

      We have a front end fileA_App and back end fileA_Data.

      When we finished development, we do deployment.

      step1: manually add all new fields to client's current fileA_Data file

      step2: replace client front end file with our fileA


      Problem: the new fields show as missing in replaced fileA's layout or scripts.


      I kind of understand this is related to filemaker "ID" when create field? so the order of creation is matter ?

      But , when we copy the contents of the script of a working fileA_App to this copy, the script or layout now can find all fields.

      Does anyone have more experience on this one, please help !



        • 1. Re: Replace Front End missing fields
          Jason Wood

          Yes, the problem is related to to the internal ID which is what FileMaker uses to keep track of field references. This is the reason we have the ability to change field names and all references update automatically, even if they are referenced in a separate file that might not even be accessible at that time.


          But when you move a front-end file from connecting to a development data file to a production data file, FileMaker doesn't know it's a different file, so all the references are based on the internal ID's, which may now be different on the production data file.


          The reason that COPIED scripts (and layout objects I think) work is because when you copy a script or layout object, the copied data contains the field names, not their internal ID's. When you paste, the scripts/objects are mapped back to the new record ID's based on name match.


          Be careful, because not only could this cause "field missing" errors, it could also cause field references to get mapped incorrectly to other fields, which can really mess with your mind when you start reading your scripts and they make no sense! I'll leave it to someone else to describe best practices for avoiding this, as I don't have much experience with multi-file solutions myself.

          1 of 1 people found this helpful
          • 2. Re: Replace Front End missing fields

            Thank You , Jason !


            • 3. Re: Replace Front End missing fields

              I also found another discussion "Internal Field ID Problem?" which has very helpful information there as well.

              • 4. Re: Replace Front End missing fields
                Jason Wood

                I was hoping someone with more experience would have chimed in with some "best practice" advice on how to deal with this in a more regular/preventative way. Data separation seems to be popular but it's sort of based on the premise that modifications to interface are common, while modifications to fields/tables is rare. I've never attempted it - mainly for that reason.