Have PsychoPy ask question from the same excel sheet as stimuli

Builder
1

I have an experiment where PsychoPy presents stories sentence by sentence from a bunch of different excel sheets. I would like it to ask a question from the same excel sheet after presenting all of the sentences from it, but cannot figure out how to do so. I can only figure out how to have it ask the same question for each story, or ask questions from a different “conditions” excel file. How would I have it present a question from the same excel sheet it is presenting each story from?

For example, I have ten excel sheets, each with a different story in it featuring two characters. PsychoPy is presenting each story sentence by sentence. Then after each story, I want to ask, “Which character did you like more, John or Kate?” The names in the question need to be different for each story, to match the names of the character in the story. Do I add the question as a row at the end of my excel sheet, or as its own column?

And then in the builder, how do you get it to ask the question from that excel sheet?

My apologies for any lack of clarity–I am struggling with putting this experiment together.

2

Hi @jgis,

there are multiple ways of doing this. The one with the least amount of programming would work like this:
Have two routines, one for the sentences of the stories, and one for the question. Around the sentence routine have a loop set to sequential and use conditions file $story_file. Around both routines and the inner loop, have another loop set to sequential and using conditions file stories.xlsx. stories.xlsx should look like this:

story_file    question
story1.xlsx   Which character did you like more, John or Kate?
story2.xlsx   Which character did you like more, Jim or Ann?
...            ...

The different story files can then have a single column with the sentences you want to present.