Can't load a google sheet unless I REFRESH the page...help!

Hey Gang,

I'm a newbie at anything script related, however, I figured out how to display the contents of a google sheet on a Squarespace page using the CODE block.

In a code block, on a blank page, I entered:

<div data-first-sheet="true" data-sheet2site="1LFO7CgWX2isRSd7J9Zwuxxp-vM_UADO4iEQPKsTC-Hs&g=1&e=1"></div><script src="https://sheet2site.com/js/embedded.js"></script>

So here's the problem.  When I load then page, nothing happens, but when I refresh the page, all of the data appears.

How can I get the data to load on the first page view?

To see the page, go to https://www.robspictures.com/did-i-order

Thanks you so much!

Rob

I'm thinking the curse of Ajax Loading strikes again! Try, temporarily, turning off Ajax Loading to see if the problem goes away.

Please note that turning off Ajax Loading will effect the performance of your site. Ajax Loading is designed to increase the loading speed of your site after it first loads.

If the problem goes away then it is likely the code has not been written to be Ajax compatible. It would need to be rewritten to be Ajax compatible, assuming it it even possible.

You have to decide whether the custom code you are trying to use is worth turning off Ajax Loading. Or, it is worth trying to get an Ajax compatible version of the code.

paul2009 has a great article on the ins and outs of Ajax Loading. Please see Why does Squarespace code only work on refresh?