Hi, Is it possible to create column headers that contain more then one column? For example, im trying to create a Cycling League Ranking Table. In the first race of the season, there's to race distances available that the cyclists can choose from. And each of those distances have a "points" and "time" column so we can input the race results. So id like a column header: FIRST RACE, above 4 columns, and underneath it, DISTANCE 1 (with two columns underneath: time and points), and DISTANCE 2 (also with two columns underneath: time and points).
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
This could be interpreted as merging cells, but that is not available in wpDataTables. You'd need to rename column headers to "45KM Official Time" and "45KM Points". What you could do here is paint the two columns, so they stand out as a whole.
Ok. Many thanks for your response. I will add this to the feature suggestions section.
One other question if I may please: I will be adding several hundred cyclists in the rows section. One column should be the Ranking position of each cyclist after each race. Other columns would be the Race points that would be input manually after each race. And at the end a Total Points column. Which formula or function should I use so when we input the points after each race manually, and the total points column sums them, it would automatically give the position of each cyclist in the Ranking position column. The highest total point would give Ranking position # 1, then #2, and so on. Many thanks
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
You can calculate the total for a column using Calculation Functions, and you can create new Formula Columns. However, they can't be combined, meaning you can't use the SUM from one column in a Formula column, nor can you add the calculation functions to Formula Columns.
If you manage to create a formula which would calculate the total number of points, the table could be sorted in descending order by that column, so it would automatically sort the positions. However, I don't believe you'll be able to do that since the Formula column is creating formulas based on the data from several columns, and including only one column in it wouldn't display the desired results.
ok. Many thanks for your response. One way of getting around the merging cells impossibility is what you mentioned, separate them by columns with details on each column. Another way Im thinking, is merge the columns in one columns, with the different race distances in it, but separate them by cell color. Then just specify, for example, red color cell 45kms, yellow color cell 60km, etc. And they could be sorted out using filters. This is doable right? Is this doable out of the box with the plug in I purchased or do I have to purchase an add on for this? Thank you!
Merging is not possible in any way - not merging cells, nor merging columns.
If you merge columns in Excel, and try to import that file, it may come up as you intend it to come up, but then there would be no cells you can color. It would all be in one cell. Conditional formatting applies to a cell, and if you import a file that has two cells merged, it would all be placed in one cell.
If you merge columns in the source file, the data for the second column (60km for example) would not be imported in the table, since there would be no column header to associate with that column.
Im sorry, my bad, I wasn't clear enough. I didn't mean merge cells. I meant something like one of the examples you have in your website, the monthly summary report temperature. Instead of merging cells, putting all the info of both columns in one longer column, but separate them by colors (instead of temperatures), and then be able to sort them by distance, where one distance is one color, and so on. Instead of a certain temperatures one color, etc. Does this make sense? Did I explain myself this time?
Im going to purchase the master data details in the next few days, as I need that functionality, so I can add each cyclist picture and team logo, like a profile pop up. Thank you!
Well, sure. You can add a custom color to every column:
That would apply to the entire column regardless of the data in it. If you need the cell color to change based on the data, you can go to "Conditional Formatting" tab in column settings, and apply a rule there. For instance, if a cell contains "45" it color the cell red; if it contains "60" it colors the cell blue, and so on.
Hi, Is it possible to create column headers that contain more then one column? For example, im trying to create a Cycling League Ranking Table. In the first race of the season, there's to race distances available that the cyclists can choose from. And each of those distances have a "points" and "time" column so we can input the race results. So id like a column header: FIRST RACE, above 4 columns, and underneath it, DISTANCE 1 (with two columns underneath: time and points), and DISTANCE 2 (also with two columns underneath: time and points).
Hello Alex
Thank you for your purchase.
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
This could be interpreted as merging cells, but that is not available in wpDataTables. You'd need to rename column headers to "45KM Official Time" and "45KM Points". What you could do here is paint the two columns, so they stand out as a whole.
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
Ok. Many thanks for your response. I will add this to the feature suggestions section.
One other question if I may please: I will be adding several hundred cyclists in the rows section. One column should be the Ranking position of each cyclist after each race. Other columns would be the Race points that would be input manually after each race. And at the end a Total Points column. Which formula or function should I use so when we input the points after each race manually, and the total points column sums them, it would automatically give the position of each cyclist in the Ranking position column. The highest total point would give Ranking position # 1, then #2, and so on. Many thanks
Hello again Alex
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
You can calculate the total for a column using Calculation Functions, and you can create new Formula Columns. However, they can't be combined, meaning you can't use the SUM from one column in a Formula column, nor can you add the calculation functions to Formula Columns.
If you manage to create a formula which would calculate the total number of points, the table could be sorted in descending order by that column, so it would automatically sort the positions. However, I don't believe you'll be able to do that since the Formula column is creating formulas based on the data from several columns, and including only one column in it wouldn't display the desired results.
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
Hi, Aleksandar,
ok. Many thanks for your response. One way of getting around the merging cells impossibility is what you mentioned, separate them by columns with details on each column. Another way Im thinking, is merge the columns in one columns, with the different race distances in it, but separate them by cell color. Then just specify, for example, red color cell 45kms, yellow color cell 60km, etc. And they could be sorted out using filters. This is doable right? Is this doable out of the box with the plug in I purchased or do I have to purchase an add on for this? Thank you!
Hi again Alex
I'm sorry, but I don't understand.
Merging is not possible in any way - not merging cells, nor merging columns.
If you merge columns in Excel, and try to import that file, it may come up as you intend it to come up, but then there would be no cells you can color. It would all be in one cell. Conditional formatting applies to a cell, and if you import a file that has two cells merged, it would all be placed in one cell.
If you merge columns in the source file, the data for the second column (60km for example) would not be imported in the table, since there would be no column header to associate with that column.
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
Hi, Aleksandar,
Im sorry, my bad, I wasn't clear enough. I didn't mean merge cells. I meant something like one of the examples you have in your website, the monthly summary report temperature. Instead of merging cells, putting all the info of both columns in one longer column, but separate them by colors (instead of temperatures), and then be able to sort them by distance, where one distance is one color, and so on. Instead of a certain temperatures one color, etc. Does this make sense? Did I explain myself this time?
Im going to purchase the master data details in the next few days, as I need that functionality, so I can add each cyclist picture and team logo, like a profile pop up. Thank you!
Hi again Alex
Well, sure. You can add a custom color to every column:
That would apply to the entire column regardless of the data in it. If you need the cell color to change based on the data, you can go to "Conditional Formatting" tab in column settings, and apply a rule there. For instance, if a cell contains "45" it color the cell red; if it contains "60" it colors the cell blue, and so on.
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