Allow Edit/Delete on your own posts ONLY

How can I allow edit/delete posts (data) created by the logged in user only?

A Post can be created and viewed by all users but I only want to allow edit/deletion on your own posts.

I’m finding that when I allow edit/deletion in the details page it allows everyone to edit/delete

You have to set it up so the user can only see his posts on one sheet view. You create a second sheet using an array formula and essentially clone the one sheet to another. The other sheet is the one that you set so everyone can view the rows of data.

This is controlled under Properties/Features User Data. The checkbox would be set on for the main sheet where the data is actually stored. The other cloned sheet would have this turned off.

1 Like

thanks @George_B but I’m trying to get my head around your suggestion, I am only new to Glide so my apologies in advance :slight_smile:

If I understand you suggestion correctly, when a user creates a new post it is created in the"Public" sheet (where all posts can be seen).

The “Public” sheet is then cloned into a new “Private” sheet which is used for displaying per-user data by ticking the box ‘Filter rows by signed-in user’ found in the Properties/Features as you’ve said.

Question:

When a user edits a post in the cloned “Private” sheet, how do I ensure that it is replicated back to the “Public” sheet so that everyone else can view the latest edit?

I think you have the right idea, but instead of cloning the Public sheet into the Private sheet, flip it around and make the Public a clone of the Private sheet.

1 Like

thanks for your input @Jeff_Hager , this is making more sense…

Following this approach does this mean that when a user adds ‘+’ a new post it needs to be added in the Private sheet?

In my UI setup I have a “My Posts” view within the side hamburger menu SO it means the user needs to navigate to see their posts view to be able to add a new post (not ideal).

The Public sheet is in tab view easily visible and having the ability to add from that view is the most ideal.

Is there a way to display all posts and have the ability to add new ones from the same view and still achieve the ability to only be able to edit your own posts?

Yes, it would be added to the Private sheet.

To fix your UI issue, I would first create a placeholder sheet. You can put one heading in it so it’s at least recognized by glide. You will display a tab for the new sheet and you can hide the tab for the public sheet. Change the layout of that new tab to the Details style. Next you will add a Form Button that will be used to add a new record to the Private Sheet. Finally add an inline list component that will point to the Public Sheet. I personally like the look better than the + button in the upper right corner.

yes I like that :slight_smile: do you have a link to a sample app in the screenshot so I can see how its been setup?

Check out the Notes demo in https://concepts.glideapp.io/

There is a link to the sheet at the bottom and you can copy the app.

Jeff is correct. The private sheet is the one that your logged in users would be able to edit and add to via a Form.

Excellent thanks to you both @George_B I have been able to get it to work :slight_smile: