i tried but am still unable to solve it. so basically i have many submitted forms in the database already. I show all the submitted forms on a table. how do i select the each of it to approve it ? i added an additional column in my database for approval using boolean as input type.
First of all, you can do that directly inside the database.
By code there are a few ways to do it:
Set onRowSelect for the table and then decide what to do with it (maybe open a menu that allows approving)
Set a button that opens a such menu.
Set s Dropdown element that shows all of the submitted forms, then you select one, and then click a button that approves it.
All of these have one thing in common - you need to set an event listener (button or dropdown change).
In this event listener, you’ll be able to use ’ wix-data ’ to update the item.