This might not be the most sexy or efficient solution, but I’ll mention it anyway in case there’s no other way: you could create a database type that mirrors the type you want to display, but without the sensitive fields.
Name: John Doe (not sensitive)
Birth date: 10/25/1985 (not sensitive)
Email: [email protected] (sensitive)
Unique ID: 12345
Name: 12345’s Name
Birth date: 12345’s birth date
I haven’t done this, but it might do the trick.
One thing I did to speed up searching for users, is to create a text field that contains relevant fields. Let’s say in an employee catalogue, that might be “Full name” “Position” and “Department”. So I’d create a search field that contained “John Doe, Marketing Manager, Communications Department”
The field is not visible to users, just a search term. I can’t say for sure as I don’t know the inner workings of Bubble, but I would imagine it is quicker than to search several fields.