I have built two separate forms and connected them to the same database. Now, when a user fills the form, the page 1 is considered as 1st entry and page 2 is considered at 2nd entry. I’m fine with it but the ideal solution would be to get the data in a single row.
Alternatively, I was thinking of passing user input from form 1 as a value in form 2’s database. This would help me join these 2 forms. I’m choosing this method over multistage form because the form is relatively very big (250+ fields) and I don’t want it to crash by putting everything on 1 page. I tried using session and pass the value. But, it doesn’t seem to work. Please someone help me out with this!
Why don’t you update the existing row in the database using wixData.update
further info here wix-data - Velo API Reference - Wix.com
I need to update the page 2 value based on page 1’s value based on the users session. If the session is same, then it shall update page 2. But, I’m still confused how to use update function since the database doesn’t have any common ground between these 2 sessions.
Eg. fields:
Page 1: First Name, Last Name, Mail ID
Page 2: Text and drop-down boxes
What people normally do on Wix if the want to spread the form over a few pages is use a slide show. This way everything is submitted on the one row.
You just place back/next buttons on the slide show, place your inputs on each slide. Then when the submit button is pressed on the last slide all info is inserted into the same row on the database.
@mikemoynihan99 Ya it seems that the only option I’m left with now.
Thanks for your help! 
I need to do this same thing except I have my multipage form on a slideshow on second page already but I want a drop down menu on the homepage to do what the first post originally asked for. So I want the user to select a service from a drop down list on the homepage and hit a button which will take them to the slideshow/multipage form on the other page. However I need the Service from the dropdown on homepage to be in the same row as the rest of the form so I want to add it to a textbox which would be the first user input on my form.
Is there any way to carry the selection from the dropdown menu on the homepage and add it to the first user input (text box) on my multipage form on the second page? I have been trying for days and I really need some help