The plugin can't see the image from external sources, so images, hyperlinks, custom formatting, formulas or custom styles can't be imported in wpDataTables.
To show images in wpDataTables, you would need to add the image source in the Google Spreadsheet with <img src... HTML tag, like this:
<img src="url-to-the-image" width=50>
And it would appear in the table with the width of the image set to 50px.
The plugin doesn't see images, only raw data so you can't use this.
You need to actually type <img src=" in a cell. The "url-to-the-image" part refers to the actual URL of the image you're trying to add. There's no way to "add" it, you need to type it in.
Thanks for the quick reply. I've changed the Google sheet cell to the img src format (see attachment as pasting the exact entry results in the image appearing in this dialog box). An image placeholder appears on the WPdatatable but not the image. I've verified the url and the caching is complete as other text entries are showing the updated data.
Will using the API interface behave any differently? I'm open to trying that.
I'll also need to add another column to the Google sheet so the image appears on the sheet as changing to 'img src' doesn't display the image there.
Lastly, is there a way to export all the settings of a WPdatatable (eg. which columns are visible, filtering settings, etc) so those can be used on a different domain?
Please cancel the first part of the request for help.
The "trick" was to have the column defined as a URL link and not as an image.
Second question still remains: Is there a way to export all the settings of a WPdatatable (eg. which columns are visible, filtering settings, etc) so those can be used on a different domain?
Other than cloning the site, another option would be to copy all database tables (wp_wpdatatable_#) along with tables wp_wpdatatables, wp_wpdatacharts, wp_wpdatatables_rows and wp_wpdatatables_columns. Then, in wp_options table, you would also need to export the following option_names:
wdtPreventDeletingTables
wdtUseSeparateCon
wdtSeparateCon
wdtTimepickerRange
wdtTimeFormat
wdtTabletWidth
wdtTablesPerPage
wdtSumFunctionsLabel
wdtRenderFilter
wdtRenderCharts
wdtIncludeBootstrap
wdtIncludeBootstrapBackEnd
wdtPreventDeletingTables
wdtParseShortcodes
wdtNumbersAlign
wdtBorderRemoval
wdtBorderRemovalHeader
wdtNumberFormat
wdtMobileWidth
wdtMinifiedJs
wdtMinFunctionsLabel
wdtMaxFunctionsLabel
wdtLeftOffset
wdtTopOffset
wdtInterfaceLanguage
wdtGeneratedTablesCount
wdtFontColorSettings
wdtDecimalPlaces
wdtCSVDelimiter
wdtDateFormat
wdtCustomJs
wdtCustomCss
wdtBaseSkin
wdtAvgFunctionsLabel
wdtInstallDate
wdtRatingDiv
wdtMDNewsDiv
wdtTempFutureDate
It is rather cumbersome to do all this, but unfortunately at the moment, it's the only way. Also, for tables linked to an existing data source, you would need to change the file path, because at the moment the file path depends on the domain, so if you change the domain, the URL to the file will also have to be changed.
Our developers are working on creating an "Export" function, so this will be much simpler in the future.
Just to add up to this, wpdatatables is excellent in reading HTML code. Anything you need, just write it in HTML code (even in google sheets) and send it over to wpdatatables, and they will be shown exactly as you have written them in HTML... of course, you can change the CSS as you desire. Good luck.
Hello
I have a table imported from google sheets, and one column has image in it (.svg country flags)... it does not show anything in wpdatatables.... why?
Hello Edwin
The plugin can't see the image from external sources, so images, hyperlinks, custom formatting, formulas or custom styles can't be imported in wpDataTables.
To show images in wpDataTables, you would need to add the image source in the Google Spreadsheet with <img src... HTML tag, like this:
And it would appear in the table with the width of the image set to 50px.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Is there an updated answer to this as the current formula in Google Sheets for having an image appear in a cell is:
=IMAGE (url, parameters) which, when used, the image appears in the Google Sheet but not in WPdatatables.
eg. =image(URLtoImage,4,100,100)
I don't see how to add <src img=...> to a cell ??
Thanks.
PS. The WPdatatable column was set to be an Image
Hello Joe
The plugin doesn't see images, only raw data so you can't use this.
You need to actually type <img src=" in a cell. The "url-to-the-image" part refers to the actual URL of the image you're trying to add. There's no way to "add" it, you need to type it in.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Thanks for the quick reply. I've changed the Google sheet cell to the img src format (see attachment as pasting the exact entry results in the image appearing in this dialog box). An image placeholder appears on the WPdatatable but not the image. I've verified the url and the caching is complete as other text entries are showing the updated data.
Will using the API interface behave any differently? I'm open to trying that.
I'll also need to add another column to the Google sheet so the image appears on the sheet as changing to 'img src' doesn't display the image there.
Lastly, is there a way to export all the settings of a WPdatatable (eg. which columns are visible, filtering settings, etc) so those can be used on a different domain?
Thank you.
Please cancel the first part of the request for help.
The "trick" was to have the column defined as a URL link and not as an image.
Second question still remains: Is there a way to export all the settings of a WPdatatable (eg. which columns are visible, filtering settings, etc) so those can be used on a different domain?
Hello Joe
Thanks for letting me know about #1.
Other than cloning the site, another option would be to copy all database tables (wp_wpdatatable_#) along with tables wp_wpdatatables, wp_wpdatacharts, wp_wpdatatables_rows and wp_wpdatatables_columns. Then, in wp_options table, you would also need to export the following option_names:
It is rather cumbersome to do all this, but unfortunately at the moment, it's the only way. Also, for tables linked to an existing data source, you would need to change the file path, because at the moment the file path depends on the domain, so if you change the domain, the URL to the file will also have to be changed.
Our developers are working on creating an "Export" function, so this will be much simpler in the future.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
In short (forgot to add this to the previous response), the configuration of tables is found in wp_wpdatatables and wp_wpdatatables_columns.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Thanks for your reply. I think I'll be just duplicating my actions on the new domain once I get everything looking as I want on the test site.
Alright, Joe.
Please feel free to reach out to us if you have any further questions.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Just to add up to this, wpdatatables is excellent in reading HTML code. Anything you need, just write it in HTML code (even in google sheets) and send it over to wpdatatables, and they will be shown exactly as you have written them in HTML... of course, you can change the CSS as you desire. Good luck.
I can think of a lot of great uses for that. Will play around with it more once the main project is completed.
Thanks Edwin.
I hope you'll be able to achieve what you're looking for, Joe.
Please feel free to reach out to us if you have any further questions.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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