Plugin Author
Meitar
(@meitar)
You have it exactly right. To retrieve one cell value, a combination of limit and offset each with an argument of 1 as part of a query like you have it in your shortcode is correct. There is no option for printing this value without its containing <table> element, though you can easily style that table to be effectively invisible using some simple custom CSS. You’ll want to look into using display: inline.
See also:
https://ww.wp.xz.cn/support/topic/show-value-of-only-a-specific-cell/
https://ww.wp.xz.cn/support/topic/extract-cell-value-without-table/
Meitar, thanks so much for your response. My goal is to have the cell’s value appear within a line of text without any distracting formatting artifacts. If I style the table to be invisible, wouldn’t it still be problematic to have the value perfectly “fit in” with the surrounding styling?
Also, I saw the reference to gdoc_table_html in the other ticket whose link you provided as a way to reduce the output to “text-only” and the raw cell value. Can you give me or point me to specific information on how to use this hook to modify your plugin to accomplish this? I do have some coding experience, but will be immensely grateful for your help.
All the best,
Marc.
Plugin Author
Meitar
(@meitar)
If I style the table to be invisible, wouldn’t it still be problematic to have the value perfectly “fit in” with the surrounding styling?
That is up to you and your site’s code.
Can you give me or point me to specific information on how to use this hook to modify your plugin to accomplish this?
https://www.wpbeginner.com/glossary/filter/
Meitar, thanks for asking what exactly I want to accomplish. If you look at the page below, you can see it. Basically, I want the bolded numbers to be dynamically updated with the data being fetched from specific cells in a Google sheet, and I want the appearance of everything to be as in this example.
I’ll take a look at the wpbeginner.com link you gave me. Thank you again.
https://elevatorspeechtraining.com/testing-3-2/
I found a solution. Your information was helpful. Thanks again.
Plugin Author
Meitar
(@meitar)
I found a solution. Your information was helpful. Thanks again.
Great!
Also, on a side note, your communication style throughout this thread was exceptionally good. If this is indicative of your competency with Elevator Speech Training, I think you’ll do very well indeed.
Glad my plugin could help be a part of building out your site the way you want. I hope the solution you found also increases your general skill with WordPress and PHP-based Web development in general. Good luck with all your endeavors.
Hi Marc,
Could I please trouble you to provide details on the solution you arrived at?
Thank you.
Ivan
