Update db connection with wix form

i need help with wix form, it seems to only create new records in db , and i need to knoew how to use it to update existing record too. thanks.

Hi @arikr !

Wix Forms is a code-less app from our Wix App market, and as such I’d suggest contacting Wix Support Center as they know best regarding its behavior.

If you want to build your own form using WixCode I’d be more than happy to guide you through.
Custom form built by WixCode can be updated and adjusted to your needs.

Doron.

Hi Doron, I will be happy to get help on this matter.

Well,
You need a collection that represents the submissions DB.

In order to build your form, first add to a page enough (and relevant) input fields according to your form (if you have different fields in your collection that needs to be filled / images / etc.)

After you built (physically) the structure of the form, add a dataset to your page and connect between the inputs to the correct fields in your collection.
If it’s your first time working with datasets I’d suggest to read this article.

Note that in a page of ‘first submission’ a.k.a the first time that user fills the form, the dataset needs to be set to “write-only”.
I pointed that because - if you want to give the user the opportunity to update their submission you can make another form page identical to the first and add a dataset that is set to be “Read - Write”.
Dataset like this gives you the ability to edit the data that was submitted before by Reading it from the collection and Re-Writing over it.

Let me know how it goes,

Doron.

Thank you. I will follow your instructions.

I have just gone through this. I was able to add content to the Collection via form, but not update via a form. I checked the Javascript Console on the live site and that is where I saw the error (User does not have permission). You need to go to the Collection when you are in the editor. Then click on the gear icon. Once you are there, you can define permissions for how the Collection can be edited and by whom. I hope this helps you! Good luck!