Jump to content

Form Field Select Field - How can I load or change the selections based on logic

Recommended Posts

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.

Link to comment
  • Replies 2
  • Views 476
  • Created
  • Last Reply

Top Posters In This Topic

Use Google Sheets is an option, is has published url that can be fetched as data source, or do you create events on the page? Can also use summary block to get the upcoming event and parse it into the form via code

BeyondSpace - Squarespace Website Developer

🖼️ Lightbox Studio (Enable Pinch/Zoom on lightbox)
🗓️ Delivery Date Picker (Squarespace Date picker form field)
💫 Gallery block 7.1 workaround
🥳 Sparkplugin Customisations Browsers (Browse +100 Spark plugin customisations)
🥳 Elfsight Template Browsers (Browse +1000 Elfsight widget Templates)

If you find my answer useful, let's leave a like or upvote so others with the same issue can find their solution. Thank you!


Link to comment
  • 1 year later...

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 ?


Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.