I still do a bit of work on this project even though I don't always get the results to show people my work. A lot of the time, I have an idea that will takes me a few days to work out that I can't find a solution for it and end up scrapping it for the time being.
Having said this, I have been working on adding a leader board page so users can see more than just the top five athletes, and we now have a seperate page that shows the full leader board for the current rewards week. There is now a link to this page on the activity comment of each of your posts, which looks like the following:
The leader board page will also show the last time the service has run, so if you are worried things are not running, this will give you the information to show if it has run recently or not. The direct link to the leader board page can be found here:
https://cypress-anorak-da8.notion.site/Leader-Board-Updated-Tue-Feb-14-19-49-34-UTC-2023-bf9e87e4106e446fb627abff356ce675
I've been sticking to the process of keeping costs as minimal as possible to make sure as much of the earnings are going back into the community. So the new page is again running with free services, and it revolves around a few different steps.
- After every post is made a database is updated with everyone's posts.
- I then use a Google sheet to import this data, total all the values for the week.
- This sheet is then embedded into a Notion page that looks like the following:
Everything seems to be working and is also hopefully secure, but as always, please let me know if you see any issues.
If anyone has any ideas of extra data or information they would like to see on this page, let me know as it might be easy to do...eg; top cyclists or top runners, etc.
Hopefully, I'll have some more updated in the coming weeks.