Score Keeping Google Quiz to Airtable

Hi Airtable guru’s!

Here’s what I’d like to do that I haven’t figured out.

I’m teaching a series of classes that will have tests that are being held in Google Forms/Quizzes.

I’d like to have these scores come into AirTable in one sheet to summarize all of these scores.

Like a grade book.

Email address | Test 1 | Test 2 | Test 3

I’ve stumped my self.

HELP!

Welcome to the community, Jessica! :slight_smile: Where exactly are you stumped? With the base design in Airtable? With the moving of data between Google and Airtable?

moving the data to the one page. I know I can do it, but it’s on many pages, basically one per test. I’d like to have a one view of everything :smiley: