Create multi-page form connected to database

I currently have a very long application from divided roughly in half between two different pages connected to the same database. The first “Save & Continue” button links to the second page, but logs the inputted information as a separate entry. The second page is then submitted with its own entry.

I need these to submit as a single entry, ideally from the same page, transitioning between steps of the form rather than pages of the site.

I tried to rebuild the form using this template:

…but had no luck. The form was non-functioning. This also seems like a cumbersome way to code the form, disconnecting all of its elements from the database, that is.

I can see that the submit button has the option to connect the “next page” in the dataset, which leads me to believe I can simply divide the fields within the database, but I don’t see this option.

Has anyone else encountered this issue or created any solutions? Any help is greatly appreciated.

I have the same problem and haven’t been able to resolve it or contact support. On the first page I am putting the submit button as go to another dynamic page, but I can even try it because is not letting me enter the website

That is because the submit is for exactly what it says, for submit. You can submit your data and move onto another page via the settings.
https://support.wix.com/en/article/adding-a-submit-button-to-your-form

As for user inputs, you can either save them in Wix Storage and pass them onto the second page of your form.
https://www.wix.com/corvid/reference/wix-storage.html
How do I pass data between pages in my site?
Use the wix-storage API. Use the setItem() function to place data in storage on the originating page. Then use the getItem() function to retrieve the data on the target page.

However, please note this request page.
https://support.wix.com/en/article/request-linking-elements-to-a-dynamic-page-eg-blog-post-or-product-page-on-your-site
Currently, there is no option in the link panel to link an element such as a button or image directly to a dynamic page on your site (blog post or product page).
In the meantime you can use the workaround below.

Or you can use a simple example like this and call them from a dataset so that they are autofilled.
https://www.vorbly.com/Vorbly-Code/WIX-CODE-AUTO-FILL-FORM-WITH-USER-INPUTS

I found an article that shows how to create multi page form on Wix. It solves the separate entry problem nicely with custom Wix codes. I think it can help you. The link to the article is https://mtechwizard.com/ how-to-create-multi-page-form-on-wix /