WEBusers access to the EDIT LIVE DATABASE WINDOW or CSV form

I would like to give acces to web users to their specific database thru the LIVE EDIT DATABASE url tab from a restrict member page(without using a contributor access). In our case we want our clients can be able to manage/record/modify their own DB in a live mode. So if it could be possible to be able to give access their specific Database with EDIT LIVE tab with password restrictions or/and approve member restrictions. (it could be also usefull if some of your wix web builder users want to give management of their DB to a employee or a external company)
If not…(we could let them manage their DB in CSV/XLS)
But we will need to create a import form for the new CSV importing feature, to be able to import CSV thru a webpage (not only in the sandbox).
To be more precise, we want to use DB for statistics records for sports, so we need to give acces to each of our stats member manager clients, the access to record/edit/update their spécific stats Database. If this feature could be possible, our company is ready to pay more their subscription to be able to build hundreds of DB eventually. Of corse it will be necessary to be able to regroup DB in A folder to allow User to only see their DB not see all others existing Webuser DB.

Hey!

Unfortunately, you can’t make Database app from My Account available as is under Member Area page, if that’s what you’re asking.

We’re working on better member management, so that could potentially help you in this particular case. I assume the main reason why you don’t want to use Database app in My Account is that there would be multiple collections visible to the users who needs to see one, right?

If you need a solution sooner, you can work around this problem with a bit of code.

First of all, you’ll need a new collection that would serve as a meta collection. In it, you’ll store other collection names and list user IDs that have access to it. Then, you’ll need to create a page and add a Table component to it. Then, using wix-data, get the necessary data from selected collection (dropdown) and again, via code, populate the Table component.

To make sure only specific users have access to their collections, you’ll need to make sure their IDs are manually entered in that meta collection and then user data hook to restrict the access.

After you have collection setup as Table, you’ll also need a page that would enable the edits of specific records. Unfortunately, you won’t be able to edit data within a table, thus you need a custom form page. Again, keep in mind the restrictions that you need to set via data hooks.

It’s definitely an ugly workaround so maybe you’ll reconsider contributor access to Database app in My Account or wait for better member management. :slight_smile:

Hi Adas… Thanks for answering ! Will consider your solution, you wrote :

''We’re working on better member management, so that could potentially help you in this particular case. I assume the main reason why you don’t want to use Database app in My Account is that there would be multiple collections visible to the users who needs to see one, right? ‘’

The big problem is of corse the user will see all collections but the other big problem the contributor user can access also to account Biling informations via this page. Is it possible to remove access to account setup and biling informations via this page if a contributor user !?

Thank you!

Yeah, you’re right. You can’t have these restrictions set for contributor.

… And Why not !? :slight_smile: why not a feature to not allow Contributor see Biling and acces Biling account! what I mean! I think WIX Can improove the EDIT LIVE Database to give access for a specific rigestered members web user to his own LIVE Edit DB via a URL to manage himslef a collection we created for him via this Live Edit Database (In our case Statistics recording). Why ? Because LIVE EDIT DB Table is easy to edit, understand and manage and also in LIVE MODE. Because our stats has to been recorded LIVE and fastly! Only Live Edit DB page can perform it that way and will minimize user entries errors, if so, he can fastly make a correction… I think this feature can open a new kind of USER market and flexibility to the infinite possibilities to Use Database (not only for selling or display collections). This is my opinion! But for our needs it could be very POWERFULL feature :)))))))))

I completely agree that that feature would be awesome, and we’re aware of how it might help you and others, but as for now, we can’t offer it. But we’re definitely not ignoring it! :wink:

I’m a realtor running mutliple websites for other realtors. I see this functionality would let me give my realtors the ability to re-open a dealsheet they have saved to the database so they could re-edit it to make changes or so that they could save something partially completed, to complete another day.

I need this functionality now. How can I do this?

Thank you!

I I so need a way for my members (realtors who work for me) to be able to edit their own entries in the db. Please can you update the thread and let me know if this functionality is done yet?

Hi,

this is already possible. If you add update rights to “Member Author” role in the collection, it will allow the user who inserted the record (submitted the form) to also access the item for editing. For example by another edit form.

1 Like