2 Replies Latest reply on Jul 6, 2009 9:37 AM by Kevin Cavallo

    How do I present partial form data as asterisk when displaying and printing forms?

    Tom Beaty Level 1

      I have forms which will be generated and passed via email.  When I need to do is capture data say a SS number.  The data will be entered as 123-45-6789 once the data is entered I want to display the field as ***-**-6789.  What’s the best way of going at this?

        • 1. Re: How do I present partial form data as asterisk when displaying and printing forms?
          pguerett Level 6

          On the Standard palette there is a password field. This will allow you to display a different character for the ones that the user enters but when you ask for the rawValue or look at the corresponding data file it will show the correct values.

           

          Paul

          • 2. Re: How do I present partial form data as asterisk when displaying and printing forms?
            Kevin Cavallo Level 4

            I'm not sure this will do the trick.  Unless I'm missing something, the password field doesn't allow you to change the way it's displayed. It always shows all asterisks.

             

            I also played with the display pattern for a text field, but it does not allow a '*' to be substituted for a character so that only the first two sections of the SSN show asterisks.

             

            If all else fails, place a text field on the form and add the following FormCalc script to the field's Exit event:

             

             

            if (Len($) == 9) then

                 $.format.picture

             

            = concat ("text{'***-**-", Right($, 4), "'}")

            endif

             

             

             

             

             

            The above should change the visual appearance of the field but leave the actual value intact. 

             

            Additionally, I set the Edit pattern to "text{999?99?9999}".  This allows users to enter "123456789", "123 45 6789" or "123-45-6789".  However be aware that the data is stored without the dashes, e.g "123456789".  If this is not acceptible then you'll have to play with the Edit pattern and probably change the Len test in the script.