Skip to main content

Creating online forms and spreadsheets

Two online services to collaboratively collect data, and manipulate it, are Google Forms and Airtable. 

Unsecure forms such as Google and Airtable are helpful to:

  • Collect food preferences for an upcoming event or large meeting
  • Get additional information from people attending a training on what their goals or skill level is
  • Collect feedback after an event
  • Get clothing sizes for the swag you are going to order
Note: These forms should never be used with clients because they are not a secure way to collect data and all research projects involving clients should be reviewed by the Center’s Institutional Review Board.  If you are interested in conducting research or data collection from clients, always contact CCI_IRB@courtinnovation.org first or the researcher assigned to your operating project. 


Google Forms, which all CCI staff have access to, allow you to easily create forms to send to CCI staff, collect data, and have the data automatically stored in a spreadsheet.  This can be useful for surveys, or figuring out food requirements for your next event.


Airtable is a service that has both free and paid accounts that allows you to create collaborative spreadsheets, slice and dice your data, and create forms for people to fill out information to put in the spreadsheets.



Labels:

Comments

Post a Comment

Popular posts from this blog

Creating your new branded e-mail signature!

As part of our  branding efforts, the Center wants all staff to use the same format for signing e-mails – also called an “e-mail signature.” To make sure these e-mail signatures are consistent, we have created a Signature template webpage . Use this page to create your own e-mail signature, complete with your operating program logo. which you can then easily copy and paste into any e-mail program so it automatically appears at the end of your emails.   Do not use these logos for any other purposes.  E-mail smeah@nycourts.gov to get high-quality logos. Here are detailed video instructions, as well as overview instructions, to use the template for Desktop Outlook, web Outlook, and Gmail (which includes the courtinnovation.org account). See the bottom of this post for mail app instructions on your phone.  You can also print out these instructions (Ctrl+P). Questions or issues?  E-mail CCI Tech Support for extra help! Desktop Outlook Clicking Fi...
Post a Comment
Read more

How to add a drop down to a cell in Google sheets

Creating a shared spreadsheet in Google sheets?  One way to make it easy to use and avoid misspellings is to add a drop down to a cell so everyone can select an option instead of typing the info in.     More info on how to create, edit and remove a drop down  here .
Post a Comment
Read more

How to change default software

When you open files, do they open in a different software than the one you'd like to use?  Sick of links opening in Firefox instead of Google Chrome? You can reset the default software your computer uses to open different types of files or search the web.   To change a default software, just open your Windows menu in the bottom left hand corner of your screen.  Then click on the gear icon to open Settings. Go to "Apps" and then "Default Apps".  Here you can select which software your computer defaults to when you browse the web, look at photos, etc. More info  here .  
Post a Comment
Read more