Hi all! I created an action that fetches a row of data from a Google sheet. Now I want to make use of these values one after another using a loop (label/goto label), eg. I want to put out a question that uses value a1, then a question that uses value b1 etc. Any ideas how to achieve this? Thanks so much.
Use values from a get row in Google sheets action in a loop
DanielBeckett
(Daniel Beckett)
#2
Hi @Dudebert
Unfortunately nested variables aren’t supported so you can’t automate a loop with results that increment on each pass through.
Instead you’d need to have questions setup for each possible result, i.e. if you’re going to have a maximum of 6 results then have 6 questions setup. You could add filters so that the question isn’t asked if that particular result number is empty.