Please help us help you and fill where relevant:
LimeSurvey version: LimeSurvey Community Edition 6.3.6
Own server or LimeSurvey Cloud: own server
Survey theme/template: Fruity 23
==================
Hello, I encountered the "The survey response table could not be created" problem (mysql error:  1118 Row size too large (> 8126)) but I can't edit questions or enhance the database.

Therefore, I decided to break the survey into 2.

In survey 1 I set the end URL field by entering the path of survey 2.

So far it works, but I would like to be able to identify the answers given by the user who fills out both surveys

I can't use tokens and I don't have a participant table.

So I would like to use the solution given here: forums.limesurvey.org/forum/can-i-do-thi...-in-the-first-survey

Like this:

1) in survey 1 I modified End URL by adding the parameter &step1={PASSTHRU:SAVEDID}

2) in survey 2 I inserted a field with code “step1” and in the integration panel I added a Step1 parameter with destination the field Step1

3) I don't know how to set hidden the Step1 field.


But unfortunately the end url does not carry the value of SAVEDID, it does not carry any value. It is empty.

In the browser the end url becomes ..../limesurvey/index.php/2?lang=en&step1= 


What am I doing wrong?   

Thank you very much!

..../limesurvey/index.php/2?lang=en&step1={SAVEDID}

Thank You very much Tony

It works!

Great!

Bye

I notice now that now the first page (landing page) of survey 2 shows the welcome page, whereas before it pointed directly to the first question.

The parameter “Automatically load final URL when survey is complete” is still on, as before.

What could this change be due to?

Check the settings in "presentation".

Found and solved, thank you!


Please could you tell me how to hide the question "step1"? It is the question that hosts the received parameter value.

I tried setting "hidden" in the CSS Class field, but it doesn't work

Use hidden setting directly manual.limesurvey.org/Question_type_-_Sh...is_question_(hidden)

...or, CSS class d-none.

tpartner wrote:

...or, CSS class d-none.
 

Here we don't need it for JS, then no need HTML produced

DenisChenu wrote:

tpartner wrote:

...or, CSS class d-none.

 

Here we don't need it for JS, then no need HTML produced

Understood but I generally use CSS as I manipulate so many questions.

I have a lot of system with bunch of question hidden

Less HTML produced => less code => more quik

Thank you!


Now everything is working fine.

One strange thing: today the 'step1' parameter I entered yesterday in the integration panel of the second survey disappeared!

However, passing the value from survey 1 to survey 2 still works: the value is saved in the hidden question of the second survey.

Why has the parameter disappeared in the Integration Panel? Perhaps because I have set the question "hidden" or perhaps because I have changed the question text (not the code)?