I used to have the PI sheet in Qualtrics and then pass the ResponseID through Pavlovia to a second post experiment Qualtrics survey.
However, I’m not moving away from that to use my Study Portal to host the PI sheet and debrief and embedded html forms for questionnaires. They aren’t as pretty as Qualtrics but I can save the results directly to expInfo variables which then appear in the data file on every following line.
Have a look at my Qualtrics Primer (slide 38) on my resources page for information about ResponseID and @thomas_pronk’s chaining tutorial.