I have a marketplace site, and would like each person who uploads a product/post to be able to edit that product/post only. Is this possible?
Currently only way to do this would be to have a separate tab called âmy productsâ thatâs filtered by posts the user has posted and made editable by users.
Thanks Robert. That will do it 
1 Like
You also need to make sure that you choose one of the logins for your app that require an email.
Yes, done, thanks George. But if I make the posts of one user editable, they are editable for all logged in users. Am I missing something?
In that case you need to add their email to each of their posts and then have some kind of profile page that is filtered down to just them and one record. Do some searching on this board to find a few examples of how various gals and guys have implemented profile pages. They you would use a filtered by user inline list of that users posts to allow only them to edit them.
RightâŚthis is similar to my response. Create a separate tab thatâs filtered to just the user. Inline list of only their posts. Make this tab âeditableâ by users.
For the posts that you do not want to be editable and viewable by all, you will need to duplicate the sheet using a formula like ={'SheetName'!A:Z}. The new sheet will be used for the general public to view all posts/products without being able to edit them.
mmm, I have a profile page with a filter as you suggest. Do you mind if I share my app link with you?
Thanks Robert, yes, I have set up a profile page with a filter as you and Jeff suggest. Do you mind if I share my app link with you?
Sure.
Aah, OK, will give that a go. Thanks Jeff.
Please do!
I assume I shouldnât be able to edit this directory listingâŚ
Correct. I would like all listings to have user-owner editing privileges.
So, hereâs what Iâm thinkingâŚeither in the My Profile section or somewhere in the menu, have a tab/section called âMy listingsâ. This will be a list/inline list of that same Directory data table, but filtered to email isSignedInUser. This section/tab, allow users to edit. Donât allow users to edit the main directory.
I thought I had already done that. I am using a âlist relationâ section in the Profile tab and then filtering it by signedin user, but it if I give the posts editing rights, it gives everyone editing rights. Perhaps I am misunderstanding you.
OK, I think Iâve got it.
AhâŚI see. Yes, I canât edit my own from the relation in the profile tab because itâs still attempting to edit the original source sheet.
It canât be an inline listâŚit has to be its own tab. Try creating a new tab called âMy Directoryâ but use the same sheet source as the main directory. Replicate the layout of the original directory âAddâ form in details view. For each component, have it filtered by isSignedinUser. If they havenât created a directory, then these fields shouldnât be visible. You might even want to create a rich text component that says something like âSorry, you have not yet created a directory. Click the button below to set one upâ and filter both the text and the button (that would link to the add directory screen) to show if the email does not contain signed in user.
This should work. If it doesnât, you may have to do what @Jeff_Hager mentioned above:
you will need to duplicate the sheet using a formula like
={'SheetName'!A:Z}
This would be unfortunate as it would effectively double your row usage. One sheet of directories would feed the other (so you donât have to reenter data). The original sheet should be the one thatâs filtered down to one user and be in itâs own tab (like described above). The new, read-only Directories sheet would be in place of the one you have visible nowâŚonly change would be that you couldnât use the add button on this tab as it would break the ={} array formula referenced above and result in #REF errorsâŚso youâd have to find another way of creating new directories.
Try the first method firstâŚI believe it will work for you.