Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages

Shopping Cart
Shopping Cart


Free Newsletter


Privacy Policy

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.


 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site


Rate this function:  

  Average rating: 3.9  (40 votes)
  Discuss this Custom Function

Tim Scoff, Medical Database Consultants

Replace a text string with bullets

Sample Input:
HideText (1234)
Sample Output:

 Then copy & paste into FileMaker Advanced's Edit Custom Function window.


This recursive function takes a text string of any length and replaces every character with a bullet. This can be used to display a password field for entering a password without displaying the actual text entered into the field, such as when using the Account Management Script Steps to enable customers to create accounts in a solution without giving the customers full access to the solution.

Create a field named Password and another field named Display Password
Set Display Password = HideText ( Password ) and make it unstored
Set the text in the Password field on the layout to white, or whatever your background color is set to
Put the Password field directly behind the Display Password field and don't allow entry into the Display Password field

It almost duplicates the functionality of a standard password dialog box. The only problem is the bullets don't appear until after you tab out of the Password field.

Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it


Thanks! Fantastic!

& the problem of the bullets not appearing until after the field is exited can be resolved by a using a simple script-triggered script. instead of a second calculation field;

OnModify on the password field...

Set Field [ password; HideText(password)]
Commit Records
Go to Field [password]

Jo, New Zealand
April 22, 2010 9:15pm

ok - so not quite that simple; as the above script replaces the actual password with dots...

but I've got it working now via a shadow field & lots of parsing!

Jo, New Zealand
April 22, 2010 11:47pm

Use only one field Password. Don't need the second field.

Use the same Custom function...

Create a simple script (to use later as a trigger):
Insert calculated result[Select; Password; HideText (Password)]

In Layout mode, on that field choose those two triggers with the script:
Set script triggers

Paul Bourbeau, Drummondville
December 25, 2012 3:09am

Hi all

This function is fantastic. Exactly what I need.
How can I integrate the password verification process? Eg. Username and Password for Login processes.
On typing in the password it would replaced the text with bullets.
How can I copy the text input on keystokes to an other field to verify with the login?

Please help me. It would be great to add this easy function with this possibility.
Regards Sebastian

Sebastian, Lucern
August 26, 2013 3:17am

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 4 + 7 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. ChiSquare3x2 ( param ; param ; param ; param )
  (Tue, Aug 14, 6:33am)
2. ReverseByteOrder ( bytes )
  (Thu, Aug 09, 12:06pm)
3. BytesToDec ( hex )
  (Thu, Aug 09, 11:47am)
4. GetAsHexBytes ( number ; bytes )
  (Thu, Aug 09, 10:50am)
5. ValCorrelationCoeff ( XValueList; YValueList; Xmean; Ymean; XStdDev; YStdDev )
  (Wed, Aug 08, 4:17pm)
6. ValLeastSquaresSlope ( XValueList; YValueList; Xmean; Ymean )
  (Wed, Aug 08, 4:10pm)
7. ValueMath ( List1 ; List2 ; operation )
  (Wed, Aug 08, 4:05pm)
8. GetExtension ( File )
  (Tue, Aug 07, 10:22am)

RSS Feed of Custom Functions