Members adjusting their Database Listing

Discussion Ask a question
, ,
1

I am going to do my best to explain this, but it lives in my head as an image soooooo yeah. I am created a member and non-member based page. Here are the steps that I took and where is succeeding and where is failing.

Setup a database for info from members (name, address, photos etc…) - Success

Setup a dynamic page to feature information from the members submission to the database - maybe success

Setup a form on the “My Account” page linked to the members listing in the database so that they can update their own pictures, name, business info. - Total Fail!

I can put all of the info on the My Account page and I can connect it to the database, but when I try to log into the website as a user and go to the My Account page, I can’t fill out the form. I have the permission for the database set to read/write by original member, and the My Account page permission to read/write. I just can’t figure out why it isn’t working.

I even tried creating a totally different dynamic page for folks to link to to fill in the data to update their public pages and it isn’t working either. Are there some more advanced tutorials out there, or can someone give me pointers?

2

Hi,
can you share the editor link to the page, so I can inspect?

Usually setting collection update permission to Site Member Author and setting dataset permission to Read & Write should do the trick. In addition you may need to filter element by currently logged in user if collection permissions allow reading all elements for everyone.

3

Hi

I got the same need (also the settings of my DataBase are the same that Giedrius Graževičius 2 says in previus post).

1. I created a DataBase that only Site Member can add info.
2. Created a Dynamic Page wit a Form for input the information on DataBase.
3. Created a Dynamic Page with a Form that displays the DataSet (Read&Write Mode), with the Previus, Next Buttons and a Submit (Refresh) data button.

All is working great, but I notice that when a Member enters on the [EDIT] DynamicPage it displays all the information of the DataBase, not only the information that the Member inputs. How can I do that??
Maybe a filter option that reads the Member ID ( label _owner ).

Is theres a Code that can I use to get the Member ID, so I can set the DataSet in filter mode and display only the info that each meber Inputs.

I am wondering if can set up a hook too.

4

Hi,

to allow only the author of the data to see and update the data use Site Member Author permissions for reads and updates of the collection

You can read more about permissions here:

If you need further assistance, do not hesitate to continue the thread!

5

I found what I need, heres the link:

https://support.wix.com/en/article/how-to-filter-a-page-based-on-the-currently-logged-in-user

a simple filter in DataSet solve it.

-JC

6

Hi,

while this achieves your requirement you need to keep in mind, that this is a filter that is applied in UI. Technically other users can still see and update any data. If you don’t mind, this is fine. Otherwise, it is more secure to apply collection permissions.

1 Like
7

So I found the permissions and I got it to where it works in the preview mode perfectly, but when I go live everything but the submit button works. It seems to not be creating new info.

The settings on the page are for “read and write”

The settings in the data base are
who can read - Site Member
who can create - anyone
who can update - site member author
who can delete - site member author

I tried to switch the read to “Site Member Author” also, but that made my links to that page stop working. It doesn’t really matter if other members read each others stuff, but yeah. So far you have been very helpful :slight_smile: the website is www.shopsmallfarms.rocks if that helps