Some data no longer pulling in

Right above the button you pressed to post this message, this forum asks you:

Did you include a link to your site, so that others can see the problem?

It is member’s only content that we are loading – it is pulling stock market recommendations from a spreadsheet of stocks. I would be happy to send you only a member’s login. Or, I’ll make a temporary page..

https://leibovitvrnewsletters.com/products/vr-trader-platinum/vr-platinum-portfolio-2/

There you are – as you can see, the current price and profit / loss aren’t showing (should be number fields) and the Stop Loss only shows numbers, but not text values.

I’m away from computer at the moment but have you ensured all the columns and rows that should have numbers do in fact have numbers and all the ones with text do have text? I.e., correct format?

I have checked and even changed the format in the google doc of those columns, but it hasn’t made a difference.

What is the shortcode you’re using on that page?

It is variations on this theme

[gdoc key=”https://docs.google.com/a/justinhandley.com/spreadsheets/d/15q2H_X0nohUJs8vgZ6NFiHrtU5lBKrEQLM1dJoQgB6E/edit” gid=”2078888428″ class=”no-datatables” query=”SELECT B,N,C,D,E,F,I,J,L,K WHERE A=’Long – Bullish Index'”]

using different where statements.

That one powers the top block, where columns F and I aren’t showing.

I did just notice one thing – both of those columns are generated using formulas, not hard coded values. Could that be the issue (although, as I said, this was working for a very long time as is)

Odd. When I use that same shortcode I see no missing values. However, your HTML does seem to have missing values. I verified that the data is available from Google by hitting the query endpoint for your query directly, and the full data set is there. This means there’s most likely something in your site that has changed recently and is filtering out those values.

If I were in your position, I would probably audit your site for any recent changes, starting with your theme, then your theme’s functions.php file, and finally your plugins. Inline Google Spreadsheet Viewer implements a filter (gdoc_table_html) that could be hooked by other code to change the HTML displayed, so it’s also conceivably possible that some other code has inadvertently hooked this filter and is making changes on the fly.

Unfortunately, since I cannot replicate the issue, and the problem exists only on your site (I do not get the same results as you do when I run the same shortcode queries against the same Google Sheets on my own sites), I cannot recommend anything beyond further scrutiny of your own website’s code. That’s not something I can (or will) do for you myself.

Thank you – I really appreciate you giving me that much detail.

Sure.

Another thing I will say, although it shouldn’t make any difference technically which is I didn’t mention it above, is that since you’re using a new-style Google Sheet with a full URL in your key value, you don’t have to use the gid attribute separately. You could just put it directly into the key attribute of the shortcode just as it appears in your Web browser’s address bar:

[gdoc key="https://docs.google.com/a/justinhandley.com/spreadsheets/d/15q2H_X0nohUJs8vgZ6NFiHrtU5lBKrEQLM1dJoQgB6E/edit#gid=2078888428"]

Also, if the gid value you wrote here also happens to be the gid value of the first sheet in your Google Spreadsheet, you also don’t technically need to include the gid value in the URL at all.

None of this should effect the issue you described (indeed, I tested by copy-and-pasting the shortcode you provided and, as mentioned, got a different result than your site’s display), but I figured I’d mention this for completeness anyway.

Good luck!