Hello,
I am having trouble iterating over a subset of items and was hoping someone could help me figure out what I’m doing wrong.
I have a large number of items (300+) that I saved as Supplemental Data. These items are divided in smaller sub-groups, meaning I have (say) 30 groups of 10 items each. For the sake of the example let’s say every item is a restaurant.
I want to ask every participant to rate 10 restaurants on some aspects (cleanliness, friendliness, etc). In theory this means that I would make one single question template and then change the restaurant name as I iterate over every restaurant in the (randomly assigned) group.
I tried two workflows, neither of which have worked:
- I added Supplemental Data to my Survey flow, searching on a single column (group number) which should return 10 restaurants. But I couldn’t find a way to access the individual items in the resulting Embedded Data - using the Piped Text field always returns the first restaurant on the list, but I couldn’t access the second one.
- I added a second column (item number) to the Supplemental Data, which as expected returns a single restaurant. I need a way to loop over this result to increase the item number on every iteration. I tried to use the Loop & Merge functionality, but this functionality is block-based and the Supplemental Data item is outside the block, meaning the Piped Text field “0${lm://CurrentLoopNumber}” doesn’t seem to return anything.
So far the best option I found was to create 10 Supplemental Data fields, but this is cumbersome and difficult to maintain. Is there a better way I can iterate over my data?