Create a form to update database collection column

Ask the community
,
1

I created a database to track orders from clients, I set the default status as “received” in the in the status column that I created in the database. How can I create a form to update the Status column on my database collection for a particular order # without it dupicating the order on there again wih the new status udpate.

2

Hey Amber,

You could use the save() function from the wix-data API. That function can update an item in a database collection.

Hope this helps!

Dara | Corvid Team

3

thanks. I’m new to this its my first site. do you know how I would put that code in

4

@adburge17
To help you, Dara will surely need more information from you :grin:.
Anybody knows your Database or form. Which Inputs do you have?
-DropDowns
-Inputs
-Do you use perhaps APPs like WixForms

All such informations are important to start with creating a code-solution.

-Structure of DB (database)
-Structure of your form