Looking at your screenshot, it seems that you did not set the Editor Type for the column Image to "Attachment".
Please go to this column settings, and choose "Editor input type" as Attachment, let me know if that helps?
-
Once you do that, it should look like this :
Issues to note:
If the Column type is set to Image, the uploader will automatically insert a ‘thumb’ size in the table cell (the resolution is defined in WP config), and link it to a full-size image. If you have a WP Lightbox 2 plugin installed, each image will automatically open in a lightbox,
Since wpDataTables is using the native WP Media Library for uploading and managing files, the standard WP restrictions apply. This means that front-end users that edit the table must have the upload_files capability to be able to upload attachments. You can add this capability to Subscribers if needed (e.g. with Capability Manager Enhanced or User Role Editor plugin). If you want to allow uploads for non-logged-in users, you will need to remove the check for this capability (see our FAQ).
Files should be with extensions WP allows.
Files shouldn’t be bigger than the current PHP configuration allows.
Please check more details about how the Attachment Editor input type works on this page.
My others questions are (if you have videos tutorials in each questions i will be glade to know ):
How can to make front-end MySQL-based editable wpDataTables and allow ( Users to see and edit only own data ) ??
where can we found the "User-ID" Column ??
Can we have all types of fields in it ?? ( Upload PDFs, Upload Pictures, Listbox; ....) ?
in the final connect this entries value in charts and reports , ( and show some statistic count ; like: TOTAL of entries in a specific queries ) in FrontEnd home page, using Elementor, for example..
Let us know if you have any additional questions. :)
Thank you
Hi, Bahae
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.
-
We will now answer the new questions, but for the future, please note :
When you have questions or issues which are not related to the title of the active ticket, please open a new ticket, and we will help you there. In that way, issues and questions which are related to different subjects will be in separate tickets so other customers or our support agents can find them easily. Our policy is to have one issue or question per ticket because of the reasons that are described already.
Thank you for understanding.
-
How can to make front-end MySQL-based editable wpDataTables and allow ( Users to see and edit only own data ) ??
you will have to create an integer column that will serve as user ID.
Our plugin is only adding an auto-populated row ID column, and this is only for Manual Tables,
this column is hidden by default and is called wdt_ID.
But for user ID column - you have to create this one yourself.
You will see more about this in the Documentation i sent.
3. Can we have all types of fields in it ?? ( Upload PDFs, Upload Pictures, Listbox; ....) ?
If you mean, for uploading files as attachments in tables,
for uploading, we are using WordPress function wp_upload_dir() for location of upload files.
If you need to change the upload location,
by default is set to the upload folder (wp-content/uploads). However, you should be able to change that location. On this link, you can see how to do that.
-
If you wish to set which file types will be allowed for upload on your Wordpress :
4. in the final connect this entries value in charts and reports , ( and show some statistic count ; like: TOTAL of entries in a specific queries ) in FrontEnd home page, using Elementor, for example..
For grouping data like this in charts, here is my example.
If i have this table with some users, user ID's and Status column.
Then we have to make additional column that will serve as the "count".
We set a predefined auto-populate editing value to always be 1 in this column.
-
Then we can make a chart from this table, and enable "Chart Grouping".
For this chart example i will only choose column "Status" and column "Count status".
then i can filter only user 1 , and the chart will follow :
-
If you just want to show "Approved" and "rejected" count, and exclude "open", you can add a checkbox Filter to the column "Status" , and just select these two :
Of course, you can hide or show columns from table, depending on what you wish users to see.
Additionally, if you just want to leave the filters for the chart and hide the table from the page, there is a CSS workaround ( let me know if you need it).
-
Let me know if you have any additional questions about what we already covered,
if you have new/unrelated questions, please open a new ticket for that. Thank you
Hello,
When I want to Edit a record in DataTable, i have this Error ??
How can I have the "Upload Attachement" button in Editing a only "Loged-in" Submited ? I want to have a "Delete" Button too..
its like a CRUD Operation System .
I want also that this data be imported automatically by a Form Builder, like WpForm.
Thank you.
Hi Bahae
Sorry for the delay
-
Looking at your screenshot, it seems that you did not set the Editor Type for the column Image to "Attachment".
Please go to this column settings, and choose "Editor input type" as Attachment, let me know if that helps?
-
Once you do that, it should look like this :
Issues to note:
Please check more details about how the Attachment Editor input type works on this page.
Let us know if you have any questions.
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 | 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,
My others questions are (if you have videos tutorials in each questions i will be glade to know ):
Thanks.
Let us know if you have any additional questions. :)
Thank you
Hi, Bahae
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.
-
We will now answer the new questions, but for the future, please note :
When you have questions or issues which are not related to the title of the active ticket, please open a new ticket, and we will help you there. In that way, issues and questions which are related to different subjects will be in separate tickets so other customers or our support agents can find them easily. Our policy is to have one issue or question per ticket because of the reasons that are described already.
Thank you for understanding.
-
Please check this documentation that will show you how to create Editable Tables.
And here you will see how to use "Limit users to edit and see only own data".
2. where can we found the "User-ID" Column ??
The user ID column does not exist automatically,
you will have to create an integer column that will serve as user ID.
Our plugin is only adding an auto-populated row ID column, and this is only for Manual Tables,
this column is hidden by default and is called wdt_ID.
But for user ID column - you have to create this one yourself.
You will see more about this in the Documentation i sent.
3. Can we have all types of fields in it ?? ( Upload PDFs, Upload Pictures, Listbox; ....) ?
If you mean, for uploading files as attachments in tables,
for uploading, we are using WordPress function wp_upload_dir() for location of upload files.
If you need to change the upload location,
by default is set to the upload folder (wp-content/uploads). However, you should be able to change that location. On this link, you can see how to do that.
-
If you wish to set which file types will be allowed for upload on your Wordpress :
Please check out this useful resource that explains How to Restrict Uploads to Specified File Types Only in WordPress.
4. in the final connect this entries value in charts and reports , ( and show some statistic count ; like: TOTAL of entries in a specific queries ) in FrontEnd home page, using Elementor, for example..
For grouping data like this in charts, here is my example.
If i have this table with some users, user ID's and Status column.
Then we have to make additional column that will serve as the "count".
We set a predefined auto-populate editing value to always be 1 in this column.
-
Then we can make a chart from this table, and enable "Chart Grouping".
For this chart example i will only choose column "Status" and column "Count status".
I made a column chart on this example, but you can check out all the available chart engines and examples of wpDataCharts documentation here .
Now, if we want to use filtering on the table, to just show data for user ID 1,
we enable "Follow table filtering" on the chart and place table on same page,
then i can filter only user 1 , and the chart will follow :
-
If you just want to show "Approved" and "rejected" count, and exclude "open", you can add a checkbox Filter to the column "Status" , and just select these two :
Of course, you can hide or show columns from table, depending on what you wish users to see.
Additionally, if you just want to leave the filters for the chart and hide the table from the page, there is a CSS workaround ( let me know if you need it).
-
Let me know if you have any additional questions about what we already covered,
if you have new/unrelated questions, please open a new ticket for that. Thank you
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 | 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