how to save a user score for future cross reference

@Curios - i use the following process/tools:

• always connect to google sheets so that i have data in the spreadsheet
• make sure to have a unique identifier like email address that you can use to connect across various 
• create output templates in Google Docs/Slides depending on the format i want to use
• use multiple tabs to pull in data for various reports i want to make - ie every six month, every three months, annual, monthly for example - i create additional fields in a tab that is prep for all reporting where i parse the year and month into separate columns so that i can use this in some of the report formats
  • i pull first-time submissions into one tab to generate the report
  • the monthly version will pull in up to 12 calendar months of responses by an email address (for example) where the start date is gte to X (period 1) and goes up to period 12 
• i use Document Studio to merge the data from the appropriate report tab into a Google Doc/Slide template that is formatted for that output ie “here’s your monthly report” that will give them up to 12 months of data 
  • the templates that i use are pretty simple in that they have the 12 months - if i start on the calendar year, then Jan - Dec otherwise i use Month 1 to 12 - and the template looks for data in specific columns and merges what is there ie a null value shows the column blank
• Document Studio will also email them out 
  • you set up workflows in Document Studio to do that… and if it is lacking some of the ‘capability’ to schedule the frequency, i use trello and a gmail reminder to me to run the reports on a set time/day

There are a number of posts in the Community on how to use Google Sheets and Document Studio, if you want to check that out.. 

hope that helps a bit

des