So I’m trying to make a flash card app for my son to practice his words. If he gets a word wrong, I want the card to basically go back three cards in the stack so he will be asked the card again. The way I’m doing this is on the flash card there are two buttons, “Correct” and “Try Again”. When that button is clicked it will document that he got it wrong in a table called “Progress Data” and then in a separate table is where it will move the row. The document I’m working on is below:
You’ll see a couple different columns to randomly sort and then rank the words. I’ve tried a few different ways but am at a loss. Does anyone on here have an idea to try? The one thing to think about is when the word gets towards the end of the “stack”, it won’t always be able to go back three places. Not sure how to account for that either. Thanks for any ideas!