How to update existing database records via form submission

Ask the community
, ,
1

Hi

On wix I have set up a form that members can access when they log in. This form is linked to the database.

When they resubmit the form to update there records I would like the same record to be updated and not set up another record for this company. Somehow I need a unique field to check if this record exists, if so to update record.

I can’t find any tutorial on YouTube or how to guide on wix to do this.

Any help will be much appreciated.

Many thanks
Abs

2

Hi,

In this case, you will want to use the update() function from the wix-data API shown here. In the link provided, take a look at the right side of the page and you will find a couple of examples on how to update a specific item your data collection. You will typically want to get the ID of the data collection item that you will want to update.

Best regards,
Edward

3

Thank you so much Edward for directing me in the right direction. I finally have hope in the WIX platform again.
Before I reached out to this forum, I contacted WIX by email and on call to find a solution to my problem they were unhelpful on the call and then when I emailed them they said this is not possible to do.

732×650 68.6 KB

4

Hi abs, did you get this to work? I’m looking to do the same - allow college students to create/update their information via a form. Would you have any example of how you did it? I currently have a website where each student’s data has been manually entered but this is not sustainable going forward.
site in feedback form here https://wix.to/e8BqDFw

5

I am sorry was unable to resolve this as coding was required. Although contacted WIX for there support they were unable to help.
If you do find a solution for this please do let me know.

6

Thanks, abs