Hi all! Ran into some snag with forms...
I have 40 items in 4 categories to rate. Putting all 40 items on a single form is not the ideal user experience (but if nothing else works, that's how the cookie will crumble).
So, I thought I would break the forms into four forms. One calling the other after each submission. I can create a helper sheet that collects the four rows and combine them into a single one.
Where my dilemma is that the original link included some arguments to autofill the form (these were hidden in the form). Let's say an id, for example. That id is generated dynamically by another sheet before. If I want to send the form to the second form after the first submission, that is a hard-coded URL in the form settings. I can't add the auto-fills to it. Which means my "id" will be present in the first submitted row only.
Any idea how I could identify that four rows that belong together?