I run a writer's education website. We have "bootcamps" where each writer logs the word written each day. I would like a leaderboard that captures entries that users record in a Google form, then totals words written and av words per day, then displays them in a leaderboard format. I would prefer using google forms for capture and google sheets for calculations and display. The form also needs to only allow numbers for dates less than 3 days in the past so should not accept any entries older than that.
I have mocked up the form here: [login to view URL]
This form captures the information in a google sheet which I would like to use as the source for this leaderboard.
We will know the names of the participating users so we can pre-populate them in a dropdown in the form. Or if possible put them in the spreadsheet and validate against that we usually get between 40-100 users so that would be a pretty big list.
The leaderboard should allow us to show the username and pull an image from their profile on our Xenforo forums in their profile. It should show the name, image and the # total words and #av. daily words with the leader (total words) at the top.
14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hello sir, Thanks for offering this project. I have mastered all of the google api and i have some experiences with google sheet api. Please hire me, then i can complete your project very easily. Thanks alot
Individual worker and passionate to learn new things. ✓ Excel work (tax invoice,formula related works) ✓ Data entry from PDF files to Excel ✓ Data entry from Word files to Excel , lmage files to Excel