3 Replies Latest reply on Apr 16, 2014 9:22 PM by TKnTexas

    Stacking or Overlaying Fields

    TKnTexas

      Title

      Stacking or Overlaying Fields

      Post

           I am drawing a blank on something I used to know.  Since FMPro does not have a masking for telephone numbers, I know there are numerous techniques for this.  An older technique was to have the number in a field as the straight digits, no formatting.  Then a second field was used to calculate the format.  It would look like one field to the user.  If they needed to edit the number it was done in the unformatted one.  

           I have searched the forum for the answer.  I have googled it.  No luck.  I thought it was referenced in Filemaker & Me, but reading it again I did not find it.  

        • 1. Re: Stacking or Overlaying Fields
          philmodjunk

               If the formatted copy of the field is a calculation field (or auto-entered calculation) referencing the unformatted field, You can give the formatted field an opaque fill color and place it on top of the unformatted field to hide it. You can set behavior options in the inspector to deny browse mode access to this formatted field. Then, when you click the formatted copy of the field, the unformatted copy hidden behind it will pop to the front and be accessible for editing. When you exit the field, it disappears back behind the formatted field which will update to show the formatted version of the data in the unformatted field.

               The hidden unformatted copy can also be part of the layout's tab order so that you can also use the keyboard to exit the previous field and enter the unformatted field for editing and you'll see the same behavior on your layout as you do when you click the formatted field.

          • 2. Re: Stacking or Overlaying Fields
            TKnTexas

                 Thanks Phil.  I will try get back to my desktop

                  

            • 3. Re: Stacking or Overlaying Fields
              TKnTexas

                   This worked perfectly.  It gives the illusion of masking.