# Local data / private data

**URL:** https://community.glideapps.com/t/local-data-private-data/24865
**Category:** Ask for Help
**Created:** [March 29, 2021, 10:24am UTC](https://community.glideapps.com/t/local-data-private-data/24865 "2021-03-29T10:24:03Z")
**Posts on this page:** 17
**Page:** 1

<div class="post-metadata">

### Author: ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)
#### Post date: [March 29, 2021, 10:24am UTC](https://community.glideapps.com/t/local-data-private-data/24865/1 "2021-03-29T10:24:03Z")

</div>

I need to add a “personal journal/diary” option to the app. (multiple users, each of them cannot see others). It’s easy to do with, for example, an inline list + show form where the user can use Text Entry to add personal notes. But their personal notes are stored in the GS and visible to us. Is any way to use only their own mobile memory to store the data or other protected way to do that? This is important for privacy, of course, and we are not interested to store private info that also increases a lot the used rows.

---

<div class="post-metadata">

### Author: ![Michael\_hien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_hien/32/18864_2.png) [@Michael\_hien](https://community.glideapps.com/u/Michael_hien)
#### Post date: [March 29, 2021, 10:31am UTC](https://community.glideapps.com/t/local-data-private-data/24865/2 "2021-03-29T10:31:42Z")

</div>

User specific column, I guess? You can choose the option when you add a new column in the Glide editor, the column will not be shown in google sheets either

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/311f2f9226fe0ff6fa8460a69517dcfe47d0985b.png)

---

<div class="post-metadata">

### Author: ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)
#### Post date: [March 29, 2021, 11:00am UTC](https://community.glideapps.com/t/local-data-private-data/24865/3 "2021-03-29T11:00:48Z")

</div>

Thanks, Michael. I was working on this solution. Only thing that I’m not sure how data are saved on users data editor. I mean: when are they erased? Are they living inside local Glide App editor? What if we update the app? Do you have any experience on that?

---

<div class="post-metadata">

### Author: ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)
#### Post date: [March 29, 2021, 1:25pm UTC](https://community.glideapps.com/t/local-data-private-data/24865/4 "2021-03-29T13:25:44Z")

</div>

Users enter 1 or 2 notes per day, like a diary, with the possibility to revise them. I don’t think is possible with user specific column.

---

<div class="post-metadata">

### Author: ![Michael\_hien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_hien/32/18864_2.png) [@Michael\_hien](https://community.glideapps.com/u/Michael_hien)
#### Post date: [March 29, 2021, 2:49pm UTC](https://community.glideapps.com/t/local-data-private-data/24865/5 "2021-03-29T14:49:59Z")

</div>

I think they’re erased when the user erases it, it is saved in Glide database, if you are the app owner/editor and you change “Viewing as…” to any user, you can still see the note of that user (my app is private pro and that’s what i see, i am not sure if public app works the same way)

I am not sure what would happen when you update the app, you might wanna ask some cool guys in the community, but I guess as long as the users don’t change their email or remove the app or some sorts of actions like that, it’s not gonna be removed.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 29, 2021, 11:26pm UTC](https://community.glideapps.com/t/local-data-private-data/24865/6 "2021-03-29T23:26:34Z")

</div>

Do you store these in a new Sheet, added via a form?

---

<div class="post-metadata">

### Author: ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)
#### Post date: [March 30, 2021, 7:03am UTC](https://community.glideapps.com/t/local-data-private-data/24865/8 "2021-03-30T07:03:57Z")

</div>

Yes. User write via a form (form button) the new entry for the journal (it opens a simple text entry with a limit on the max length) and then data are stored in one sheet, like this:

 ![journal1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/02fdc681062be2e7a98b1e4348f581e76ff7b7b8.jpeg)

All the users write on the same sheet.

---

<div class="post-metadata">

### Author: ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)
#### Post date: [April 21, 2021, 1:03pm UTC](https://community.glideapps.com/t/local-data-private-data/24865/9 "2021-04-21T13:03:49Z")

</div>

Still looking for a safe solution where users can write their own daily notes, maintaining the privacy. As said, I don’t need to save them on Glide or on GS. The only solution that I see is to use “row owner” column and protect the email address (that anyway can be unprotected and then visible again). But either way the notes are visible on their column. Any way to save the notes only locally on the user’s device? Or anybody has a way to encrypt/decrypt the text?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 21, 2021, 1:33pm UTC](https://community.glideapps.com/t/local-data-private-data/24865/10 "2021-04-21T13:33:44Z")

</div>

There’s no way to encrypt/decrypt the text. If you’re still using forms for daily entry, then using row owners is the only way to protect that data. Users will only download their own rows.

---

<div class="post-metadata">

### Author: ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)
#### Post date: [April 21, 2021, 1:45pm UTC](https://community.glideapps.com/t/local-data-private-data/24865/11 "2021-04-21T13:45:26Z")

</div>

> [@ThinhDinh](#):
>
> If you’re still using forms for daily entry

Do you suggest other ways to do that?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 21, 2021, 2:05pm UTC](https://community.glideapps.com/t/local-data-private-data/24865/12 "2021-04-21T14:05:03Z")

</div>

I think you want to keep multiple notes attached to an event, so I don’t have an immediate thought about an alternative. I was thinking you can just point that to a user-specific column if it’s a single note.

---

<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: [April 21, 2021, 2:46pm UTC](https://community.glideapps.com/t/local-data-private-data/24865/13 "2021-04-21T14:46:12Z")

</div>

hmm, what about writing them to a single user specific column as a joined list?

An app developer would still be able to get at them by previewing the app as a specific user, but other than that they’d be well hidden?

---

<div class="post-metadata">

### Author: ![PieroPec](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@PieroPec](https://community.glideapps.com/u/PieroPec)
#### Post date: [April 21, 2021, 3:04pm UTC](https://community.glideapps.com/t/local-data-private-data/24865/14 "2021-04-21T15:04:22Z")

</div>

Sorry, not sure to understand…how to do that?

---

<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: [April 21, 2021, 3:14pm UTC](https://community.glideapps.com/t/local-data-private-data/24865/15 "2021-04-21T15:14:33Z")

</div>

It’s a somewhat advanced technique, and I’m not even sure if it would work in this case, but it could be worth a try. Rather than try and explain it, I’ll point you to the following Tutorial…

> [@\[Advanced\] Trebuchet Method link - List of Items/users in one cell!](https://community.glideapps.com/t/tutorial-trebuchet-method-list-of-items-users-in-one-cell/25688):
>
> #1 - Learn how to implement the method in your app. #2 - Learn how to remove an item from an array. star Trebuchet Method works in public & public with email apps! COPY THE APP FOR FREE Points of attention: We gotta pay attention in the minimal details because in almost every time we’re adding informations to another place, and all the columns must have values in every row (like tamplate, IFE, join list, split list), so when we click, our “current” row pick the …

---

<div class="post-metadata">

### Author: ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [April 21, 2021, 6:32pm UTC](https://community.glideapps.com/t/local-data-private-data/24865/16 "2021-04-21T18:32:29Z")

</div>

@PieroPec I tested here now with the method @Darren_Murphy mentioned here above + a way I use in my booking apps. But even trying hard, there’s no “easy & row safe” way to do it

---

<div class="post-metadata">

### Author: ![Ojasvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ojasvin/32/43959_2.png) [@Ojasvin](https://community.glideapps.com/u/Ojasvin)
#### Post date: [June 17, 2022, 9:22pm UTC](https://community.glideapps.com/t/local-data-private-data/24865/17 "2022-06-17T21:22:19Z")

</div>

Hey! Were you able to figure a way to get this done?

I’m trying to build something similar and am facing the exact same issue!

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 17, 2022, 9:36pm UTC](https://community.glideapps.com/t/local-data-private-data/24865/18 "2022-06-17T21:36:36Z")

</div>

There’s no way to store data anywhere in Glide without it living somewhere externally. The best you can do is user specific columns, but that data still lives on Glide servers.
