Creating a Flight Log with Google Forms and Sheets
PART 1
Create a Google form that asks:
Course Name (Multiple Choice) (Required)
Level 05
Level 06
Level 10
Level 11
Level 12
Level 13
Level 14
Level 15
Fastest 1-Lap 000.000 (Short Answer) (Required)
Fastest 2-Lap 000.000 (Short Answer) (Not Required)
Fastest 3-Lap 000.000 (Short Answer) (Not Required)
Drone Model (Multiple Choice) (Required)
FIVE33 Switchback
Tiny Trainer
Fox Crooked
Mobula 6
Meteor 65
HX115
Screenshot Link (Short Answer) (Required)
It should look like this . . .
Here you can edit any of the responses. Such as if you fly a drone that is not listed, you can add it.
Click the Add Option to Add a new choice.
Opens Screen Capture
Click the 3 dots next to the screenshot and then share.
Then copy link.
Fly a course and fill out the form.
Click the 'Eyeball' to open the form preview.
Open Reponses
Open Google Sheets
It should look something like this.
PART 2
Create a new sheet.
Rename the new sheet "Flight Log" & drag the sheet to the left.
Press {ctrl} + {shft} + {v}
This will paste the row titles with out formatting.
It should look like this . . . "No Formatting"
Change the formatting to make the 'Flight Log' look good.
Center Text
Change Font Size
Change Font Color
Change Cell Color (Background)
Change Wrapping to Wrap
It should look something like this:
Align the text to the middle of the cell.
Select cell A2 and type "="
Switch to the Form Responses Sheet
Select cell A2 and hit {Enter}
Repeat and select for the corresponding cell, skipping email.
Courses
Fastest Lap
Fastest 3-lap
Drone Model
Screenshot of Time
It should look like this, now adjust cell widths to fit content.
It should now look something like this.
It should now look something like this.