I would like to create a table that can be populated with data from the database, but can be edited similar to an excel spreadsheet. Googlesheets is not an option. Objective is to create user-specific page with table where user can modify the data on the table and have the data stored in a database. Each record in the database would be a row in the table. User should simply open the page and, see the table and enter any data into any cell in the table and then press save. The next time the user enters that page, he/she would see the same data on the table and can edit it again. I know how to limit the page to a specific user so that the data is specific to that user. I would also use one database per user/page (only a few users). Any ideas/help? Thanks!
Hey
There is no native component to accomplish this in WIX except coding and tricks. You could call on a iframe where the actual table is populated using some script and when edited it calls back to wix and stores it.
Otherwise you could just give the user the permission to add / edit and work with your collections through WIX directly?
You can also add input elements next to the table, so the user can select a row in the table, and edit the data using the input elements.
Another (maybe crazy?) idea is to have a lot of text inputs, imitating a spreadsheet. That could be an interesting experiment 
Please give it a try, we’d love to see what you come up with.
Thanks To both for these ideas!
EDITABLE TABLES I REALLY LOVE IT ! Someone have add it into request features Forum!?
Ron, Me too! Editability of table along with ability to (a) insert a blank row and (b) delete selected row(s) or delete a row-at-a-time to begin with, would be a nice.
In the website I am working on, just in the first draft I have a need to have 4 editable tables. And then I will need one more very soon. (For now i am using Tomer’s suggestion of having input elements next to the table.)
I would like as well the possibility to build a UI to access data from the data base from a table with possibility to modify add date and delete data.
How would this work? You have a table and you want a user to be able enter or edit an item in the table, so you put a user input and save button next to it. How do you communicate that when the user clicks on X row and inputs something into the user input, it adds it to the collection? I really like this id but how would you go about that?
I am able to do this with a table and required number of input fields. When user lists a row in the table, same data will be displayed in the input fields for edit. After edit, use a button to save data into the collections.
Great i used and succeeds, Thanks Man
Old post reappearing, closed.