![[community profile]](https://www.dreamwidth.org/img/silk/identity/community.png){kind=small}
(no subject)
Jan. 18th, 2020 09:25 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
theyregooddogsHey, let's talk about ways to record activity for the sake of our memories and also being able to make AC. So, the way I have found best is to use a combination of Google Forms and Sheets.
First, you need a form set-up roughly like this. If you want to add more information or even skim some of it off, go for it. This amount of details helps me to find what I need at any point and to help add up points really easily as you will soon see . . .
Second, go to the responses tab and have it auto-populate a spreadsheet. Then, retitle that first sheet to something snappy with just one word. Make any additional sheets for however many characters you want to track. Here is what I have after some slight tweaking.
Third, in those character specific sheets, you need to put =query(Responses!A:H,"Select * Where B='John Doe'") in the very first cell. You need to change Responses to whatever your first spreadsheet that is collecting all the data is called, change John Doe to whatever names you are using in that section of the spreadsheet and pay attention to what column it falls in too, and finally expand or reduce A:H depending on how much information you want to copy over.
Fourth, you cannot edit the character specific sheets. You have to go back to the main sheet to do that, since it is just moving the information over. This is why I like to wait a few days to log my threads, but party hardy if you don't mind editing your information a lot.
Optional, fifth, format your lives and games column to just catch your eye. It helps, okay. Also, put a filter on the top row of your individual character sheets, so you can organize it by date or what have you.
Think that should be enough, but let me know if you need any help troubleshooting.
First, you need a form set-up roughly like this. If you want to add more information or even skim some of it off, go for it. This amount of details helps me to find what I need at any point and to help add up points really easily as you will soon see . . .
Second, go to the responses tab and have it auto-populate a spreadsheet. Then, retitle that first sheet to something snappy with just one word. Make any additional sheets for however many characters you want to track. Here is what I have after some slight tweaking.
Third, in those character specific sheets, you need to put =query(Responses!A:H,"Select * Where B='John Doe'") in the very first cell. You need to change Responses to whatever your first spreadsheet that is collecting all the data is called, change John Doe to whatever names you are using in that section of the spreadsheet and pay attention to what column it falls in too, and finally expand or reduce A:H depending on how much information you want to copy over.
Fourth, you cannot edit the character specific sheets. You have to go back to the main sheet to do that, since it is just moving the information over. This is why I like to wait a few days to log my threads, but party hardy if you don't mind editing your information a lot.
Optional, fifth, format your lives and games column to just catch your eye. It helps, okay. Also, put a filter on the top row of your individual character sheets, so you can organize it by date or what have you.
Think that should be enough, but let me know if you need any help troubleshooting.
