gbrunks

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.

Thank you so much that is fantastic.

Site URL: https://www.phgagolf.com/xcard I am trying to build a form for submitting golf scores. I am using a form block that takes in the information for the round of golf including the score on each of the 18 holes. The standard form places each of the 18 hole score fields on separate lines which slightly annoying. I would like to have two lines each with 9 fields to enter the scores. So on the form you'll see form fields labelled 1 through 18, these are the fields I would like on two lines on the form. The form can be found at-->https://www.phgagolf.com/xcard

The page is -->https://www.phgagolf.com/spring-scramble You can go ahead and click and complete a Join Event and observe the delay between the completion of the form and the update to the embedded google sheet a minute or two later by refreshing the page

I have a page which I let the user complete a form which then stores the data in a Google Sheet. That works great. On the same page I display the same Google Sheet by embedding the google sheet in a code block. The problem is that after the user submits the form it doesn't immediately show in the embedded Google sheet. It takes maybe 1 or 2 minutes later then it shows. Is there anyway to force SP to update the page immediately or more frequently?