+ How to create an event sign up sheet
- Create a new event
- When you click “edit” on the event content, click on the “add content button” and then choose form
- Create your form and then in storage click on “connect” for Google drive and choose a name for the spreadsheet you want to create.
+ 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.