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…

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]

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 sur…

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: [journal1] All the users write on the same sheet.

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…

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.

[image] ThinhDinh: If you’re still using forms for daily entry Do you suggest other ways to do that?

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.

Local data / private data

Ask for Help

Darren_Murphy April 21, 2021, 3:14pm 15

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…

Topic		Replies	Views
Are visitors able to save private text in their app? Ask for Help	2	264	April 3, 2023
Allow the input field only on the phone. Not on the sheet Ask for Help	6	349	August 27, 2020
Help & How to Ask for Help	1	203	June 10, 2022
Privacy doubt Ask for Help security	9	70	September 22, 2024
Private notes for users Ask for Help	4	321	July 18, 2023

Local data / private data

Related topics