# Security question: hash column

**URL:** https://community.glideapps.com/t/security-question-hash-column/57477
**Category:** Ask for Help
**Created:** [February 3, 2023, 9:35pm UTC](https://community.glideapps.com/t/security-question-hash-column/57477 "2023-02-03T21:35:27Z")
**Posts on this page:** 14
**Page:** 1

<div class="post-metadata">

### Author: ![OndieM](https://avatars.discourse-cdn.com/v4/letter/o/b3f665/32.png) [@OndieM](https://community.glideapps.com/u/OndieM)
#### Post date: [February 3, 2023, 9:35pm UTC](https://community.glideapps.com/t/security-question-hash-column/57477/1 "2023-02-03T21:35:27Z")

</div>

Is there a way to block me as the App Developer from seeing the value of a particular column in glideapps as a security feature? This is a finance app I built and I don’t want to be able to see User Income info that they add in a particular column in Glide Editor or GoogleSheet.

Something similar to the virtual addresses that are assigned as a security feature.

---

<div class="post-metadata">

### Author: ![OndieM](https://avatars.discourse-cdn.com/v4/letter/o/b3f665/32.png) [@OndieM](https://community.glideapps.com/u/OndieM)
#### Post date: [February 3, 2023, 9:38pm UTC](https://community.glideapps.com/t/security-question-hash-column/57477/3 "2023-02-03T21:38:38Z")

</div>

I don’t know if I agree with this. I am still able to see User Input info in certain columns.

---

<div class="post-metadata">

### Author: ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [February 3, 2023, 9:47pm UTC](https://community.glideapps.com/t/security-question-hash-column/57477/4 "2023-02-03T21:47:53Z")

</div>

The Glide bot is mistaken. Row owners is a security feature between users of the app, but the developers of the app will be able to see all the data.

The protected column feature is the closest there is to what you need, but that won’t work either.

I don’t think there is a true secure way currently for a developer to develop an app in Glide (the data structure and user interface) _and_ not see the data of the app.

---

<div class="post-metadata">

### Author: ![OndieM](https://avatars.discourse-cdn.com/v4/letter/o/b3f665/32.png) [@OndieM](https://community.glideapps.com/u/OndieM)
#### Post date: [February 3, 2023, 9:49pm UTC](https://community.glideapps.com/t/security-question-hash-column/57477/5 "2023-02-03T21:49:57Z")

</div>

Oh ok. So, out of curiosity…How is this achieved with the virtual addresses that are assigned in lieu of the user’s true email address on public sign in? If I could get a feature that is able to scramble the data in a column that would be cool. My app is finished but a few ppl asked if I am able to see their income…so Im thinking this might be a concern for some.

---

<div class="post-metadata">

### Author: ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [February 3, 2023, 10:07pm UTC](https://community.glideapps.com/t/security-question-hash-column/57477/6 "2023-02-03T22:07:27Z")

</div>

You would need to be able to hash the data, but as far as l know that feature is not available natively in Glide.

The hash feature is _only_ available for email addresses used by users to sign in, and this feature isn’t available at the column level but in the settings at the app level. Email addresses are a special piece of data as they play the role of a user ID. To be in line with local privacy regulations and in particular GDPR in the EU, Glide offers the possibility to anonymize these email addresses.

---

<div class="post-metadata">

### Author: ![OndieM](https://avatars.discourse-cdn.com/v4/letter/o/b3f665/32.png) [@OndieM](https://community.glideapps.com/u/OndieM)
#### Post date: [February 3, 2023, 10:09pm UTC](https://community.glideapps.com/t/security-question-hash-column/57477/7 "2023-02-03T22:09:08Z")

</div>

Ok…thank you.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 4, 2023, 2:20am UTC](https://community.glideapps.com/t/security-question-hash-column/57477/8 "2023-02-04T02:20:20Z")

</div>

> [@OndieM](#):
>
> I don’t want to be able to see User Income info that they add in a particular column

@OndieM - is this income value used in any way in the App after it’s been entered? ie. do you display the value in this column anywhere?

---

<div class="post-metadata">

### Author: ![OndieM](https://avatars.discourse-cdn.com/v4/letter/o/b3f665/32.png) [@OndieM](https://community.glideapps.com/u/OndieM)
#### Post date: [February 4, 2023, 2:24am UTC](https://community.glideapps.com/t/security-question-hash-column/57477/9 "2023-02-04T02:24:08Z")

</div>

Yes, once the income is entered…calculations happen in the background…then the results are displayed on a chart. So there’s an input box to enter income…answer some questions, then calculations happen based on the income entered. So it is displayed to the User. But only the User can see their personal info. I can see what they entered on the Glide Editor and Google Sheets. I’m trying to fix it where I can’t see it as an app developer. (Some of the ppl using this app are my friends, and I feel that that’s their personal info…and I want them to feel safe using it.) I just thought about how the virtual addresses are issued in lieu of the original email address and thought maybe there was someway to do the same for columns we choose.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 4, 2023, 2:30am UTC](https://community.glideapps.com/t/security-question-hash-column/57477/10 "2023-02-04T02:30:20Z")

</div>

Yeah, I get it.

The reason for my question was if you were only using the App to collect that information, then Protected Columns might have been an option. With Protected Columns you can add data via a form, but once it’s been added you can’t see it or use it in any other way.

But not helpful in this case, it seems.

---

<div class="post-metadata">

### Author: ![OndieM](https://avatars.discourse-cdn.com/v4/letter/o/b3f665/32.png) [@OndieM](https://community.glideapps.com/u/OndieM)
#### Post date: [February 4, 2023, 2:37am UTC](https://community.glideapps.com/t/security-question-hash-column/57477/12 "2023-02-04T02:37:38Z")

</div>

I was considering it at first, and then I realized that you said the data can’t be used in any other way.

---

<div class="post-metadata">

### Author: ![OndieM](https://avatars.discourse-cdn.com/v4/letter/o/b3f665/32.png) [@OndieM](https://community.glideapps.com/u/OndieM)
#### Post date: [February 4, 2023, 2:44am UTC](https://community.glideapps.com/t/security-question-hash-column/57477/13 "2023-02-04T02:44:20Z")

</div>

So I asked Chat GPT and it suggested the following: (basically what Nathan said…but he said it probably won’t work for columns)

"1. Create a new sheet in your Glide app.  
2. In the new sheet, create a column for the user’s income data.  
3. In the script editor, write a custom formula or function that will hash or encrypt the user’s income data when it is entered into the app.  
4. Save and publish your app.

Now, when the user enters their income data into the app, it will be encrypted or hashed and stored in the new sheet. The app developer will not be able to see the user’s actual income data, only the encrypted or hashed version of it.

Note: This is just a general idea and there are different encryption methods that you can use. The exact steps may vary based on the method you choose and your programming skills. Before implementing this in a live app, make sure to test and validate the encryption method you choose to ensure it is secure and reliable."

Do you think this will work? If so, I may give it a try

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 4, 2023, 3:00am UTC](https://community.glideapps.com/t/security-question-hash-column/57477/14 "2023-02-04T03:00:48Z")

</div>

The hashing might work, but it still won’t hide the original entry from you.

---

<div class="post-metadata">

### Author: ![OndieM](https://avatars.discourse-cdn.com/v4/letter/o/b3f665/32.png) [@OndieM](https://community.glideapps.com/u/OndieM)
#### Post date: [February 4, 2023, 3:06am UTC](https://community.glideapps.com/t/security-question-hash-column/57477/15 "2023-02-04T03:06:43Z")

</div>

Yeah, I see that now…lol. I just tried it and it didn’t work. Haha…thanks for helping.

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [February 5, 2023, 3:07am UTC](https://community.glideapps.com/t/security-question-hash-column/57477/16 "2023-02-05T03:07:38Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
