wpDataTables
Forum Replies Created
-
Hello again,
Apologies for not catching your reply here earlier.
Thank you for these details and the screenshot of the Table.
Since you use the free version, this is then a ‘table linked from Excel file source’.
And you are using our ‘second variant’ of the Single Cell Shortcode for dataTables.
So, as we have shown in the Documentation, if you go for this format as :
[wpdatatable_cell table_id=”1″ column_key=”column_name” column_id=”custom_id_column” column_id_value=”custom_id_column_value”]
That means that the column_key will be the Column in which your cell you need to render is located.
In this case, that is correct, you need a cell from ‘Course name’, right?
Just make sure to check what is the ‘origin header name’, go in the Column Display settings and use the origin header ( in case if you have a different display header name).
Now, the ‘column_id‘. It is the name of the column that contains unique values (origin header name* of the column)
Then, the column_id_value – is the value from column_id column which tells the table which row to look for.
So you need to give it a unique value in column_id_value to pinpoint which row from Column “Course Name” you need in your single cell value.
Let’s say if we wanted to pull cell value in your table from Column Course Name to be this row which has “Anthropology” ( and some special letters which I can not write due to language barier) showing on your screenshot, I will highlight it in my image :
In this case, your Single Cell Shortcode will be :
[wpdatatable_cell table_id=”26″ column_key=”Course Name” column_id=”JUPAS Code” column_id_value=”JS4006″]
And that would pull up the “Anthropology” cell value in your Shortcode.
Let us know if this points you in the right direction to solve the issue?
If you still can’t solve it, can you show us a screenshot when you have the value/row you need showing in the table and how it looks;
What is the value for that specific row in “JUPAS Code” and what is the value in “Course Name”?
You can also send us your source Excel file so we can make a table from it to show you an example how to pull the specific cell you need.Hello,
As we pointed out on this Documentation about Tables linked from JSON source;
The JSON should be available via an URL that wpDataTables can access.
Yes, if you wish to make any table linked from a JSON source file, inside the Input file path or URL, you have to insert the full URL path to the source file, including the domain name.
For the time being, we don’t have a way to use a ‘relative path’ to a file without the domain name.
For example, if we insert a JSON file in the root folder of a website, on this test we will use a LocalHost on a computer, and if the full URL path is : http://localhost/lite/employees.json.
We can remove the https:// part and just leave the domain name followed by the path on the FTP/the site folder where the file is stored as :
localhost/lite/employees.json and that will work.
But if we remove the domain name completely, at the moment, that will not work.
If you wish to see the ability to use ‘relative path’ without the need to insert the full URL to the file source including the domain name, you can make a development suggestion.
Please feel free to search on our suggestions page, to see if someone may be already suggested this feature. If you can’t see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list. You can certainly follow our changeLog if you’d like, where we state any changes/new features/bug fixes during updates;and our newsletter, so you’re informed about new features, bug fixes, freebies, etc.
Regarding the way we named the ‘input file path or URL’ field in the Table back-end settings, we will pass your feedback to our management and the developers.
They will do their best to update the way how we named that field and the tooltip for improved clarity for our users.
Let us know if you have any additional questions.
Thank you.Hello,
Firstly, we would like to extend our sincere apologies for the delayed response. We were facing a higher volume of inquiries than usual, which has caused this delay.
We regret any inconvenience this may have caused you, and appreciate your patience during this time.Thank you for reporting this behaviour.
We are able to reproduce it on a test/dummy Forminator Form and linked to our Table.Just a couple of screenshot that demonstrates how the submissions from the Form are rendering which ones are “pm” and which ones are “am”
We tried changing the WP time format from the general settings to see if that can help, but for now, we can’t seem to find a workaround solution, our developers need to get involved in debugging it.
We are sending this to our QA Team, just to get the official confirmation, but it seems this is definitely a bug from our end for our integration.
As soon as we get more information and to confirm if we have any kind of a temporary fix, we will report back right away.
For now, if it is possible for your use-case to temporarily switch to 24 hours time format until we work on fixing it.
Thank you for all your patience.