@AmphenomenonI see that you're getting the entry logic wrong... the Script won't add your total previous entry to your new Entry you have to do that your self manually but I tried going through the history of your entries to help you correct some but
Firstly, all you have to do when giving the format of
100k,name,total Pus days count,total number of pushups,date of entryIs adding your total number previous Pus on the table to the new Pus you're about to chip in
E.g I have a previous of 3000 on the table and now I have a new Pus of 500 my new total number of Pus on the format will be 3000+500 which is 3500....with your entries your previous entry is not correct but I got you covered
Your first Entry:
100k,User Amphenomenon, 1, 30, 2024-07-11
100k,User Amphenomenon, 2, 50, 2024-07-12
Day 1 you did 30 Pus
Day2 you did 50 Pus
Total =80Pus
Your second entry:
My Reports:
100k,Amphenomenon,1,30,2024-07-11
100k,Amphenomenon,2,50,2024-07-12
100k,Amphenomenon,2,60,2024-07-13
Here you made the mistake of writing Day 1 and Day2 you don't need it again just your day 3 is what we need if you feel like describing it.
There for your Day 3= 60
Total of 80+60=140Pus
Your third entry:
My Reports:
100k,Amphenomenon,1,30,2024-07-14
100k,Amphenomenon,2,70,2024-07-15
Total:
100k,Amphenomenon,8,190,2024-07-15
Here you only added your new Entry+part of your previous you didn't add it to the total previous entries
So you have Day 4 and 5 =>30+70=100
Total new Pus is 140 +100 =240Pus
Your fourth entry :
My Reports:
100k,Amphenomenon,1,30,2024-07-16
100k,Amphenomenon,1,35,2024-07-17
100k,Amphenomenon,4,120,2024-07-18
Total:
100k,Amphenomenon,11,275,2024-07-18
If you wish to do something like this without description the you can use the successive count which is (6,7,8) and not (1,1,4) why?? You started on 11 of July and your entry is upto 18 of July which means you've done 8 days of Pus,
Here now you have
Day 6 = 30Pus
Day 7 =35 Pus
Day 8 = 120Pus although I'm not sure how you come to this 120 but if there's any error you can subtract it before adding
However this si my calculation
30+35+120=185
Your total Pus is 240 + 185 =425Lastly this is how your format will be
100k,Amphenomenon,8,425,2024-07-19
Day 2024-07-18 has been recorded already we are currently on 2024-07-19 phase
Although, I don't think
@Dirtykeyboard script should accept previous date apart from Current because if it does then there is possibility of putting a
Future date entry by participants which will look unrealistic .
This should help @Amphenomenon
