Color World: Collect data from Google Form and insert into CartoDB

Steps for building a google form + cartodb table to collect data

Figure out what data you want to collect. I’m going to collect

• What color people like (color)
• Where they are located (location)

Create a table to store the results

• Create blank table with columns for color and location

Create a form to collect data

• docs.google.com
• select Create new Form
• create form
• store results in a new spreadsheet

Go to the new spreadsheet

• Tools
• Script editor
• Create a script for => Spreadsheet

Edit script

• rename to CartoDBColors
• use the attached set of functions
• add trigger on onFormSubmit for ‘on form submit’

Share your form with the world!

• enjoy data collection straight into CartoDB :)