Live update Repeating Group Data

Need help Database
1

Hey,

I am currently building a flashcards app and want to implement spaced repetition. To save the progress of multiple users I have a Progress database with: UserID, CardID, Progress, NextTime.

Currently I have a repeating group with a Do a Search for Progress:each items card. The plan was that when a user tags a card with “bad” that he should redo the card in 5 minutes and I thought that if I have a Do a Search for in the repeating group it would work, however it doesnt add the card back to the repeating group after NextTime <= CurrentTime.

Any ideas for another method or how I can do that?

Thanks in advance!

2

Shouldn’t it be;

current date/time+minutes: 5

Then maybe you change back the cards tag from bad to something else…
Apparently you must have constraint the RG not to show bad cards

Instead of

NextTime <= CurrentTime.

3

image
image1360×858 80.4 KB

Hey, thanks for your answer. That is my current logic. (Karte = Cards). So I already only use the time and nothing else. The other variables are just for making sure that those cards are really for that deck and that user.

4

Okay this is to display the cards, there are couple of ways to execute that.

My opinion ;
In the cards DT there should be “BadTag” as a thing which can be a yes/no or multiple options depending on your design
And
A constrain on the RG NOT to show bad cards or “BadTag=No”

After a user tags a card ‘bad’ you can set up a backend workflow for database to change the card “BadTag” from yes to no only when the cards modified date/time +minutes: 5

5

Okay but when I add a “BadTag” to the Cards database that would not work because it would also be changed by other users. thats why I use the progress database.

6

Oh! the app is already live… to better solve this I can spare 15min for us to troubleshoot it together, that’s if you don’t mind

7

No the app is not live yet, but the Cards data would interfere if every user changes the “BadTag” in the Cards Database or am I wrong?

8

Nope u’re only using that data thing “BadTag” as a reference thing to the constraint in the RG and the backend workflow, it should work well if you Trigger it usage well

9

Hi there,

One thing you’re going to want to do before showing the next cards is to reset the group and it’s data first and then display the new data (this way you’re making sure the data is being properly displayed)

Next thing, making sure debug mode is on. Before running the workflow, click the step by step button. You can check if the data is being updated properly.

Last thing, your workflows will be less costly and run faster if you save the cards to the current user rather than searching for cards with the user= current user.

Let me know if you need more help. You can schedule a call with me by clicking on my profile picture if you’d like (I offer 30 minutes for free) or send me an email at jonah@floop.app

Have a great day

10

Thanks for your help! I will try building it that way!

1 Like