I have created 2 different forms on 2 pages and i have link these forms to a single database, but after submit the first page form the database shows my details correctly but after submit the second form the database showing on another row of Database.
Anyone can help me to show my 2 different forms detail connect to a single database in a single row
That is because when you submit the first form it takes it as one submission and then when you submit the second form it takes it as a second submission.
You can either use Wix Storage API to set the users inputs to memory and then get them again on the second form and save it all in one go with setFieldValue/s and save.
https://www.wix.com/corvid/reference/wix-storage.html
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#setFieldValue
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#setFieldValues
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#save
Or you can look at writing a backend file that gets all of the users dataset rows and combines them all into the one row after the user has submitted the user inputs on the final form.
The second option has already been done and talked about in a previous forum post.
https://www.wix.com/corvid/forum/community-discussion/solved-multi-page-form-why-do-we-think-it-is-not-working
Or you can write code that saves it as it goes and then saves it all into the one dataset row as shown on this previous forum post.
https://www.wix.com/corvid/forum/community-discussion/please-helpp-connecting-dataset-in-same-row-resolved
Note that this last one is for logged in users and not just for normal contacts only.
It has also been talked about here.
https://www.wix.com/corvid/forum/community-discussion/wixdata-insert-creates-three-different-rows-in-collection
