I am currently working on a website that allows people to add items and receive points for the items and things have been going well lately but I’ve run into a big snag. I want people to be able to edit their items they’ve added to the website (or at least be able to delete them) and I haven’t really found a good way to do this. Wix doesn’t seem to have editable tables from what I know and all I want users to be able to do is change (or delete) what they’ve added so far easily, like just by selecting an item and pressing a button.
Below is an image of the table that I want them to be able to edit. I tried adding an “Item Number” field to uniquely identify each item with a single number, but that doesn’t really help me too much since Wix’s databases don’t have an autoincrement field for a primary key, and this number would need to autoincrement starting from 1 for each member since all items are in the same database, so this doesn’t really seem to work since some users would have seemingly random numbers for their Item Number. I wanted to use it so they could select the Item Number of the record they wanted to update/delete.
What should I do for this? I’m relatively new to Wix and I don’t know if there’s a better way for members to manage their data or not. I’d like for them to be able to click an item in the table and be able to fill in a form to update it or something similar, but I’ve had issues figuring out to this. An editable table that would update the database would also be great if that’s not a feature already. Thanks for the help!