+ How to create an event sign up sheet

  1. Create a new event
  2. When you click “edit” on the event content, click on the “add content button” and then choose form
  3. Create your form and then in storage click on “connect” for Google drive and choose a name for the spreadsheet you want to create.

    Tutorial

+ How to add a member to the database

In order to make adding members into the database as easy as possible, each member is shown as an event or a blog item in the Squarespace backend.

Since the Squarespace CMS wasn’t designed to interact with SQL data, I’ve created a few workarounds to make it as easy as possible for you to manually enter a member. As you watch the video, note the way that members are sorted. The date field for a member determines where that member is sorted in a list. As members are imported automatically from the spreadsheet, each member was automatically assigned a “date” one day apart.

If a member has a date with 11/2/2012 at 8:00 and you want to create a new entry above them, they will need to have a date sometime after 11/2/2012 at 8:00 (11/2/2012 at 8:01 would work just fine). If you want to add a member below another member, simply make the new members date one minute below that other member’s.