gbrunks

The email you get for the order can be parsed using Google scripts to scrub the information about the form and order and put into a Google sheet. The only problem is that if Squarespace changes the email format (which they have done occasionally) you'll need to update the scrubbing script.

It appears that SP may have reverted the format change on the emails. I see that may emails are now back to the original format.

I have a form (https://www.phgagolf.com/supplemental-form), pick the Supplemental Entry Button, that has select fields on it to allow the submitter to pick partners from a roster of members. Each of the select fields contains the same list of members. You mentioned a method to use Google Sheets to fetch data from, I have limited coding skills, is there an example I could look at to build from ? Thanks

Site URL: https://bird-sawfish-7s2c.squarespace.com/config/pages Since SP took away the opportunity to bulk load Select Fields on forms. Could I use Custom CSS to add the 100 or so items I need in my select field on various forms I use on my site ? I was thinking that I could add the required Options under the Select field using it's ID <option value="MyValue2">MyValue2</option> Is that possible ?

Site URL: https://www.phgagolf.com/event-signup On my form I have a select field (Event) that contains the upcoming events that the user can select. What I would like to do is either a) dynamically load the events from a Google Sheet or other source that can be programmatically maintained, or b) remove events from the selections based upon date. Once an event date has past I don't want the user to be able to select it. I know I could go in and update the form manually occasionally but I would rather have it happen automatically.