# Hide Data with \*\*\* Symbols

**URL:** <https://forum.inductiveautomation.com/t/hide-data-with-symbols/55938>\
**Category:** Ignition\
**Created:** [February 9, 2022, 7:31pm UTC](https://forum.inductiveautomation.com/t/hide-data-with-symbols/55938 "2022-02-09T19:31:48Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dee\_Duncan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dee_duncan/32/31786_2.png) [@Dee\_Duncan](https://forum.inductiveautomation.com/u/Dee_Duncan)\
**Post date:** [February 9, 2022, 7:31pm UTC](https://forum.inductiveautomation.com/t/hide-data-with-symbols/55938/1 "2022-02-09T19:31:48Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [February 9, 2022, 7:40pm UTC](https://forum.inductiveautomation.com/t/hide-data-with-symbols/55938/2 "2022-02-09T19:40:46Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [February 9, 2022, 7:46pm UTC](https://forum.inductiveautomation.com/t/hide-data-with-symbols/55938/3 "2022-02-09T19:46:38Z")

</div>

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.

```auto
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.

---

<div class="post-metadata">

**Author:** ![Dee\_Duncan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dee_duncan/32/31786_2.png) [@Dee\_Duncan](https://forum.inductiveautomation.com/u/Dee_Duncan)\
**Post date:** [February 9, 2022, 7:52pm UTC](https://forum.inductiveautomation.com/t/hide-data-with-symbols/55938/4 "2022-02-09T19:52:01Z")

</div>

Thank you very much!

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [February 9, 2022, 9:06pm UTC](https://forum.inductiveautomation.com/t/hide-data-with-symbols/55938/5 "2022-02-09T21:06:58Z")

</div>

It’s an advanced technique, but for fully seamless integration you could use `configureCell` and `configureEditor` to return a [`JPasswordField`](https://docs.oracle.com/en/java/javase/11/docs/api/java.desktop/javax/swing/JPasswordField.html) based renderer/editor.

[https://docs.inductiveautomation.com/display/DOC81/Vision+-+Power+Table#VisionPowerTable-ExtensionFunctions](https://docs.inductiveautomation.com/display/DOC81/Vision+-+Power+Table#VisionPowerTable-ExtensionFunctions)