I wonder if there's a way to display the normal text filed as *** like a pasword input.
How about this one ? Password Input Masking
No such option in field. Do you want to display only or while input ?
Script step "Show custom dialogue" has the option.
I just want to use only "to display"
Then, one way is creating another calculation field.
If the text is shorter than 400 chars,
Substitute ( 10 ^ Length ( fieldName ) - 1 ; 9 ; "*" )
If the text is longer 400 characters...
briandunning.com : Repeat ( text ; numberOfTimes )
I use two fields for passwords for example. One field is Password_input, it shows regular text when user enters the password. Then on validation it save that value (encoded) in another field and then fills the first field with random nr of *.
You gave a good point, secure UI doesn't show same number of * as password string, usually static I think.
You might consider finding or creating password font made of only asterisks or bullets. The field font could change conditionally on field enter / exit. That's if you want this to be a read/write field. If it's only for display purposes -- read-only -- then you could use a calculated field. What's your actual interest doing this?
I have a field for social security numbers that I need to display as "xxx-xx-1234". I created a second field to contain the complete value in my table (PATIENT::Patient_SSN_AllDigits) then used this script:
Set Field [PATIENT::Patient_SSN_AllDigits; PATIENT::Patient_SSN]
Replace Field Contents [No dialog; PATIENT::Patient_SSN; "xxx-xx" & Right (PATIENT::Patient_SSN; 4)]
This sets the 'AllDigits' field to contain the complete SSN number and the displayed field to contain a mask of xxx-xx-1234 to be displayed. As you type in the SSN, you can see all the digits, but as soon as you leave the object the mask displays. As long as the data you are wanting to mask has a uniform number of characters, something like this should work if you tweek it a little to fit your data format. If it is not uniform, I believe there is a way to do it but I would have to research it a little more.
Yeah nice thing is you can limit access to the AllDigits fields with FileMaker authorization, so no one can have a peek at it.
Retrieving data ...