UPDATE: I wrote some VBA code in Excel to export my spreadsheet into C2's .json format. I made this a Project File and then used "AJAX.LastData" to "LOAD" the file into my array. Works great!
I want to make my web app available to my wife and other people in my French class. Ideally, the app will keep track of which words/phrases they get right and wrong so I can make the latter come up more often. I'll also need to add new words/phrases to the list by updating the .json file on the server.
What would be the best way to do this? Here's what I am currently considering:
[id] = Sequential numbering from 1 to the total number of cards. Doesn't change.
[french] = A French word/phrase
[english] = The English equivalent
[score] = This variable is used to determine how often that flashcard appears (based on whether players got it right or wrong)
Then I'll do something like this?
1. App starts - load Phrases Array from .json file on server
2. Load LocalStorage
3. Copy local [score] to array [score] by using the matching [id]
Then I'll show the Flashcards with the lowest score. If users get a card right then I'll raise the score. If they get a card wrong I'll lower the score.
If I store my Phrases Array with the [id] first and the [score] last then I should be able to sort the array on the X axis (sort by [id]). Or, Sort the array on the Y axis and then sort it on the X axis (sort by [score]). Right?