Hi, Jeffery.

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

I am not able to get any errors, when i try to import your Sheet URL,

or to link a table with the Sheet.

Here is my Video :

https://watch.screencastify.com/v/gYBwuDIguh9fRleX4n0X

I have also used our Sandbox Demo site. https://sandbox.wpdatatables.com/wp-admin

The only detail i noticed, on the first tab of your Sheet ( the one that the URL leads to),

the columns do not have that first row on top to say the Header Names.

If you check, in the A 1,  B 1, and C 1 cells,  you have the values starting straight away,

so there is no Header Row above them.

-

Also, the column C just has these Team logos,  i tried to copy them to a copy of my Sheet, but can't paste the images.

Basically, if you need to import images in our plugin, they can not be passed like this from the Google Sheet.

There are two ways how you can render images in our plugin :

1.  If you use an Image column,

“Image” link columns are used to render images in the table, either in full size, or as a link from a thumbnail to a full size image.

• Rendering rules: If the content of the cells contains a combination of “two sticks” – || – everything to the left of this combination is used as a link to the thumbnail, and everything to the right as a link to the full image size:
  

http://domain.com/thumb.png||http://domain.com/fullsize.png

If the “||” combination is not found in the content, the entire content will be used as a link to a full-size image.

Please check more about our Image columns here.

So, first for the column C i would place a Header name on top, in the first row,

and then try again - see if you get any errors.

If you can, can you please record your screen and show me how the issue looks when you try from your end?

If the video shows any sensitive data, you can mark reply as PRIVATE for safety.

Thanks.

Hi, Jeffery.

Sorry for the delayed reply again. Thanks for understanding.

-

In regards to passing images from Google Sheets to our plugin,

yes - unfortunately it is not possible to pass them like that, our plugin can only read an image if you set the path to the image in the source cell.

If you use an Image column,

“Image” link columns are used to render images in the table, either in full size, or as a link from a thumbnail to a full size image.

• Rendering rules: If the content of the cells contains a combination of “two sticks” – || – everything to the left of this combination is used as a link to the thumbnail, and everything to the right as a link to the full image size:

http://domain.com/thumb.png||http://domain.com/fullsize.png

If the “||” combination is not found in the content, the entire content will be used as a link to a full-size image.

Please check more about our Image columns here.

-

Or if you wish to try with a String Column in our plugin, then you would need to wrap the image in custom HTML image tags.

For example, an image would be wrapped in HTML something like this :

<img src="http://domain.com/imageFolder/image.png">

You would, of course, have to modify that to your image URL paths for each cell.

If you need to use any kind of a script or formula in order to get the images right in the source Spreadsheet,

the only way to use Google Sheets with Formulas is as explained on this Documentation;

basically you would make a new empty tab of the Sheet, then in cell A1 make an !importrange that will output the values from the original Sheet, then you can link that to our table.

But you would again need to have the "finished values" formatted in certain way for our plugin to render the images, as explained above.

Let me know if that makes sense.

-

In terms of tables being dynamic, i did not fully understand that part.

I guess you are also using another Formula in the Google Sheet, or a script , to have some values/rows update periodically?

Our tables will output any values you change in the source data, as long as you keep the data structure the same,

as we pointed out in this Documentation,

Please note: Once you create a table from a Google Spreadsheet, changes in the core file from which a table is created, like:

• Changing the column’s name,
• Changing the column’s order,
• Deleting the column, and
• Adding a new column.

are highly not recommended, because the old table will not work, at the moment. If you make any of these changes, please recreate the table again.