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'] == '…

Variable column based on group

Builder

wakecarter November 5, 2022, 12:28pm 2

Do you mean like this?

Topic		Replies	Views
Using multiple parameters and selecting one file per row to use as a stimuli Builder randomization	1	206	October 2, 2023
Randomly selecting from rows Builder	1	840	March 16, 2020
Varying the set of stimuli shown based on group Builder	1	1080	March 24, 2018
Randomly selecting a subset of 5 excel rows from groups of 10 rows on each trial Builder	10	7130	October 19, 2020
Selecting different rows per iteration in a loop Builder randomization	20	14896	October 17, 2021

Variable column based on group

Related topics