gbrunks Posted December 20, 2019 Share Posted December 20, 2019 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? Link to comment
michaeleparkour Posted December 20, 2019 Share Posted December 20, 2019 I would look at page if possible, as we have no idea how you embed so don't know what to expect. Link to comment
gbrunks Posted December 20, 2019 Author Share Posted December 20, 2019 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 Link to comment
michaeleparkour Posted December 20, 2019 Share Posted December 20, 2019 3 minutes ago, gbrunks said: 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 That's what I thought. Google says shared html and csv sheets are updated in 5 min, I do not think there is a way to force this unless use their API, but that's sure far more complex than pasting an embed code to Code block. Link to comment
Recommended Posts
Archived
This topic is now archived and is closed to further replies.