Is there a way to hide data in a table with **** symbols, similarly to when passwords are entered and appear as **** ?
I am storing roster info for calculated rosters in a database. Part of that info is user pin codes for alarm acks, which is what i want to hide. I have a power table polling the data.
I still want to be able to easily manipulate the data from vision, so I cannot just hide the column.
I believe you can set a specific column’s font in a power table. Wingdings font will produce unintelligible text, to get asterisks you would need to get a password font. I have never used anything but out of the box fonts, so i don’t know if/how you can do that.
Welcome to Forums @Dee_Duncan! I would probably hide the actual pin column, and select an additional and separate dummy column used to alter the real column.
select *, '****' as PIN
from rosters_table
Of course you would be able to see the pin as you type it in though, unless you prompt for a system.gui.passwordBox() onDoubleClick() of the cell and enter it that way.
1 Like
Thank you very much!
1 Like
It’s an advanced technique, but for fully seamless integration you could use configureCell and configureEditor to return a JPasswordField based renderer/editor.
4 Likes