It would be the same table, the order of the drivers would be depending on the Points column, I would also need that after saving the table once entered the points of the race for each driver save this information in a field of a custom content post type that would be by running a php function.
As you can see my requirements are many, so I would like to ask you if all my requirements are possible with your plugin, both at design and technical level taking as reference, as I mentioned before the satandings of the formula 2.
You could create a table that looks like that using some custom CSS - it's not possible to achieve this design without it. Please note, though, that our support refers only to advice, and writing custom code is not included.
If you can achieve the desired design, sorting the table per "Points" column would be easy - just access column settings, and set this column to be the default sorting column that sorts in descending fashion.
The table can store data only in the source, so if this table is supposed to be an editable table, it needs to be either a manual tableor a MySQL query-based table which is pulled from a single database table, with a unique auto-increment column. So, if you're pulling the data from a custom post type, it has to be an SQL query-based table, but in that case, you'll most likely need to JOIN or UNION multiple database tables to get the data you need.
Please note: Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables.
We're using a 3rd party PHP SQL parser, which isn't perfect, and the plugin can't function as a database management plugin. There's a possibility to create SQL query-based tables, and to edit them if they come from one source, but editing tables that come from multiple sources is not yet possible.
Hello,
I have in my mind to make a table of results of races, I would like to know if with your plugin I can make a design like this link that is of the standings of the formula 2.
It would be the same table, the order of the drivers would be depending on the Points column, I would also need that after saving the table once entered the points of the race for each driver save this information in a field of a custom content post type that would be by running a php function.
As you can see my requirements are many, so I would like to ask you if all my requirements are possible with your plugin, both at design and technical level taking as reference, as I mentioned before the satandings of the formula 2.
Thank you.
Hello Kevin
Sorry for the late response.
You could create a table that looks like that using some custom CSS - it's not possible to achieve this design without it. Please note, though, that our support refers only to advice, and writing custom code is not included.
If you can achieve the desired design, sorting the table per "Points" column would be easy - just access column settings, and set this column to be the default sorting column that sorts in descending fashion.
The table can store data only in the source, so if this table is supposed to be an editable table, it needs to be either a manual tableor a MySQL query-based table which is pulled from a single database table, with a unique auto-increment column. So, if you're pulling the data from a custom post type, it has to be an SQL query-based table, but in that case, you'll most likely need to JOIN or UNION multiple database tables to get the data you need.
Please note: Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables.
We're using a 3rd party PHP SQL parser, which isn't perfect, and the plugin can't function as a database management plugin. There's a possibility to create SQL query-based tables, and to edit them if they come from one source, but editing tables that come from multiple sources is not yet possible.
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