I have an excel document that is roughly 210 rows by 10 columns that I am remaking manually in WP Data Tables. It needs to be edited by 10 users (1 per column), that can edit only their own data. Different rows require different input types, some are numeric, some are dropdowns.
It seems that the best way to implement this is to set it up as 210 columns by 10 rows instead.
However, this will be an EXTREMELY long datatable that will not display properly. What is the best way to implement this datatable? Can the data be implemented as 210 columns x 10 rows, but display the columns horizontally like rows?
Thank you for your purchase, and sorry for the late response.
Unfortunately, something like this is not possible with the plugin's built-in features. The ID is being added in rows, not columns, and there's no PIVOT option in wpDataTables, so you couldn't do that either.
You would need to create a Pivot table in the database; then prepare a MySQL view (a stored query), which will return the data from that Pivot table, call it e.g. “view1” and then build a wpDataTable based on a simple query like “SELECT * FROM view1″.
However, I am not sure that this would help you out, but you can try.
I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.
Tables linked to an existing data source are not database tables (all except for MySQL Query-based tables), so there's no way to query them.
Gravity Forms' entries are stored in the database, but they are split into several database tables, and wpDataTables' integration add-on for Gravity Forms constructs a dynamic MySQL query in the back-end which pulls the data from the forms. This query is not accessible, nor is it alterable, so you can't use it.
If you know your way around MySQL, you could construct your own query which would pull the data from Gravity Forms' database tables, but this is not a simple task.
Hello,
I have an excel document that is roughly 210 rows by 10 columns that I am remaking manually in WP Data Tables. It needs to be edited by 10 users (1 per column), that can edit only their own data. Different rows require different input types, some are numeric, some are dropdowns.
It seems that the best way to implement this is to set it up as 210 columns by 10 rows instead.
However, this will be an EXTREMELY long datatable that will not display properly. What is the best way to implement this datatable? Can the data be implemented as 210 columns x 10 rows, but display the columns horizontally like rows?
Hey Michael
Thank you for your purchase, and sorry for the late response.
Unfortunately, something like this is not possible with the plugin's built-in features. The ID is being added in rows, not columns, and there's no PIVOT option in wpDataTables, so you couldn't do that either.
You would need to create a Pivot table in the database; then prepare a MySQL view (a stored query), which will return the data from that Pivot table, call it e.g. “view1” and then build a wpDataTable based on a simple query like “SELECT * FROM view1″.
However, I am not sure that this would help you out, but you can try.
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
If a data table is created and linked to an existing data source, can that data table itself be access via mySQL queries?
Ex: ===============================
A table created from the Gravity Forms integration addon/MySQL Queries
|
| SQL Query with pivot
V
Pivoted version of first data table
==================================
Hi again Michael
I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.
Tables linked to an existing data source are not database tables (all except for MySQL Query-based tables), so there's no way to query them.
Gravity Forms' entries are stored in the database, but they are split into several database tables, and wpDataTables' integration add-on for Gravity Forms constructs a dynamic MySQL query in the back-end which pulls the data from the forms. This query is not accessible, nor is it alterable, so you can't use it.
If you know your way around MySQL, you could construct your own query which would pull the data from Gravity Forms' database tables, but this is not a simple task.
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