while it's not i'm deciding to use the integer only data column to store the "%/100"
so if you had 5 water updates to do, and landed 4 / 5, progress would be 80%
proposed approach:
0: just restart the tables and correct it.
1: attempt & prepare solution on the fly given the problem.
👍 progress: {'check', 'check', 'check', 'miss', 'check}
// this array of strings is how its supposed to be. could also be arr of T/F flags but they're strings.
bookmarking a consideration that I would've done them as booleans rather than strings and now it'll be a whole num of 100.
👍 '{"check, check, check, check, check"}' // set up wrong, its a string of 5 checks not 5 strings in array
not a big deal the client function parses anyways with a .split(',')
while it's not i'm deciding to use the integer only data column to store the "%/100" so if you had 5 water updates to do, and landed 4 / 5, progress would be 80%
proposed approach: 0: just restart the tables and correct it.
1: attempt & prepare solution on the fly given the problem. 👍 progress: {'check', 'check', 'check', 'miss', 'check} // this array of strings is how its supposed to be. could also be arr of T/F flags but they're strings.
bookmarking a consideration that I would've done them as booleans rather than strings and now it'll be a whole num of 100.