Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #3435814
circa
Closed

Comments

  • Di Belardino Luciano started the conversation
    Good evening,
    if I import or link a google excel sheet with images embedded in the cells these are not seen. Why?
    Thanks for the attention.
    Luciano Di Belardino
  •  1,847
    Miloš replied

    Hi Luciano Di Belardino,

    it is not possible to have images rendered in our tables when you embed them directly in a Google Sheet in this way.

    For every image, in order for our Plugin to render it, you need to format it in a certain way, with a full URL leading to the image.

    There can be two ways :

    1. If you use an Image Column to show the image in our Plugin's table,

    “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.

    • Issues to note:
      • Sometimes some issues may appear when you’re sorting on image columns, since it’s done alphabetically, and alphabetic sorting of HTML typically doesn’t make sense.
      • Please note that the plugin does not create thumbnails (at least for the moment), so you will need to take care of this yourself.
      • If you would like to open full-size images in lightbox, you can use a plugin for that, e.g. WP Lightbox 2  (please note that this is available for tables that aren’t editable)

    Please check more on using Image columns in our Plugin here.


    2. Or you can try with a String Column.

    In that case, you need to wrat the image inside Custom HTML image tag,

    for example something like this :

    <img src="URL to your image.jpg">

    You can learn more about image HTML tags here.

    -

    So in your source Google Sheet you need to add the path to the Image in order for our Plugin to render it in the cells.

    Let me know if that helps.smile.png


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables