Trouble creating charts using queries

So, I think you’re making this more complicated for yourself than it needs to be. As described here, don’t try creating a query to calculate your generated data at the same time as you try to format that data into a structure the chart you’re trying to draw expects. That’s really complicated. Instead, just create a new sheet that generates your chart-able data and then grab that data from its sheet using this plugin. Again, read the linked post for some more guidance.

Thanks for the quick reply. I had hoped to avoid that route because there’s more than 40 columns to deal with which can be a little tedious. But I did start creating that and it worked so that’s good.

If I can ask one more question, somewhere in the documentation it mentioned that it’s possible to call the logged in member’s information. I have no idea how to do this and I would love to use the user’s email address to get information from the table for a table. How does that work with the short code?

somewhere in the documentation it mentioned that it’s possible to call the logged in member’s information. I have no idea how to do this and I would love to use the user’s email address to get information from the table for a table. How does that work with the short code?

This is done by implementing the plugin’s gdoc_query hook. See here:

It’s just a standard WordPress filter, which you can/should learn about in the Codex. If, for example, you wanted to do a GQL query on a Google Spreadsheet but select only rows that match the current user’s email address, you might write a gdoc shortcode like this:

[gdoc key="ABCDEFG" query="select A, B, C where X = '__WORDPRESS_USER_EMAIL__'"]

and then, in your plugin or theme or whatever, a WordPress filter function like this:

function filter_gdoc_query ($query, $atts) {
    if ('ABCDEFG' !== $atts['key']) { return $query; }
    $cur_user = wp_get_current_user();
    return str_replace('__WORDPRESS_USER_EMAIL__', $cur_user->user_email, $query);
}
add_filter('gdoc_query', 'filter_gdoc_query', 10, 2);

In this example, when a logged-in user whose email address is [email protected] loads the page on which a gdoc shortcode with the key of ABCDEFG is inserted, the resulting query to the Google Sheet will be:

select A, B, C where X = '[email protected]'

All other gdoc shortcodes will simply be passed on unchanged.

Hope this helps.