Local data / private data

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.

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

1 Like

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?

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.

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.

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

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:

All the users write on the same sheet.