Forum Discussion
Solved
Store marked complete based on question
Hello,
I am having trouble coming up with the solution or if its even possible.
I have a client that runs multiple questions per location and as long as one is answered that store is marked complete.
The store can have up to 20 questions. The other detail is that the 1st question is the important one. So if question 1 and 2 are answered we want to Display question 1, but if question 3 and 4 are answered, we want to display the one that was answered first.
How can I do that?
3 Replies
could you pls paste the data here (not the screenshot)?
and what's the expected output based on the sample data you provided?
Here is the data and the desired output. Hope this helps.
Store Question Answer Complete/Not Complete 1 New Release Yes Complete 1 Promotion No 1 Support No 2 New Release Yes Complete 2 Promotion "Blank" 2 Support "Blank" 2 Distribution "Blank" 3 New Release "Blank" Complete 3 Promotion "Blank" 3 Support Yes 3 Distribution "Blank" 3 Remodel "Blank" 4 New Release "Blank" Complete 4 Promotion "Blank" 4 Support "Blank" 4 Distribution Yes 4 Remodel "Blank" 5 New Release "Blank" Complete 5 Promotion "Blank" 5 Support "Blank" 5 Distribution "Blank" 5 Remodel Yes 6 New Release Yes Complete 6 Promotion Yes 6 Support "Blank" 6 Distribution "Blank" 7 New Release "Blank" Not Complete 7 Promotion "Blank" 7 Support "Blank" 7 Distribution "Blank" 8 New Release "Blank" Complete 8 Promotion Yes 8 Support Yes 9 New Release "Blank" Not Complete 9 Promotion "Blank" 9 Support "Blank" 9 Distribution "Blank" 10 New Release "Blank" Not Complete 10 Promotion "Blank" 10 Support "Blank"
