I know how to variably select files based on groups (e.g. by using $“spreadsheets/list_”+expInfo[“list”]+“.xlsx”), but what I would like to do is to have separate columns in one spreadsheet instead of 4 separate spreadsheets (i.e. with columns “question1”, “question2”, “question3” for the three list…

That’s perfect! Thanks so much, Wakefield! So for future people with the same problem, adding the following code at Begin Routine with separate columns question1 and question2 solves it. :slight_smile: if expInfo['list'] == '1': #Note the quotes thisText = question1 elif expInfo['list'] == '…

Do you mean like this? [image] Shuffle rows after routines Coding Hi there, I have 4 conditions in my excel sheet with 104 questions (4 columns and 104 rows). Each round (loop) participants will need to rate 5 questions from each 4 conditions, which means they will need …

Hi Wakefield, thanks for the incredibly fast response! Hmm, I think this is more complex than what need. Sorry I probably haven’t explained it very well. Below is a minimal example using the practice stimuli spreadsheet assuming there were two lists. So, at the start of the experiment, I’ll assign …

I meant that it was code for you to simplify. Something like if thisExp['list'] == '1': #Note the quotes thisText = question1 elif thisExp['list'] == '2': thisText = question2 ...

Oh, I see, thanks, it looks like that should work, but I get an error currently. Sorry, I’m not the best coder. I’ve added that code to a code component (practice_code), set to the beginning of the routine and then referred to $thisText in the audio component (see picture below), but I get the follo…

Sorry, my fault. I get confused between thisExp and expInfo. You need the latter.

Variable column based on group

Builder

wakecarter November 5, 2022, 12:28pm 2

Do you mean like this?

Topic		Replies	Views
Two stimuli lists Builder	1	58	October 8, 2025
How easy is it to distribute a long list of trials among participants? Builder pavlovia	13	1028	February 15, 2022
Pull stimuli from three columns of a spreadsheet Builder	4	882	October 28, 2021
Varying the set of stimuli shown based on group Builder	1	1113	March 24, 2018
Semi-random order to avoid repetition of grouping variable Builder randomization	1	1073	April 28, 2021

Variable column based on group

Related topics