We're using WPTables to create a leaderboard for cycling events and the app is picking up our tome formats (hh:mm:ss.ms) and converting it to (hh:mm:ss am). Essentially it takes an amount of time and converts it to a clock time.
As I do not have access to your spreadsheet, can you please give me more details about how it is stored in the google sheet and how you want it displayed in the table?
The only way to currently present these custom values, is if you use our String Type Columns.
-
So, at this time, we don't have a built-in feature to achieve this, but you can suggest it for our developers - they will do their best to make a solution in the future.
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 page if you'd like ( it is also available in the plugin dashboard), 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.
-
If you need a solution for it now, maybe it can be done with a high level of custom work, but I am not sure, to be honest. Our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future.
We can recommend reaching out to someone who does custom solutions, such as WP Kraken, but we can't advise on their pricing.
Hey guys
We're using WPTables to create a leaderboard for cycling events and the app is picking up our tome formats (hh:mm:ss.ms) and converting it to (hh:mm:ss am). Essentially it takes an amount of time and converts it to a clock time.
How our table looks in google
https://docs.google.com/spreadsheets/d/1KU1nW-kYYAyPcBvxCY0elLbIOtldcS3pB6uey1SnU1c/edit#gid=0
How the table looks in WPTables
https://www.rgtcycling.com/arl-results/
What would we need to do to display the amount of time and not the time from a clock?
Thanks in advance
James
Hello James,
Thank you for reaching out to us.
As I do not have access to your spreadsheet, can you please give me more details about how it is stored in the google sheet and how you want it displayed in the table?
Looking forward to your reply.
Kind Regards,
Uros Jovanovic
[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
Hey
Thanks for the reply
We use the custom format option and format the time as follows:
Format
Number
Custom number format
hh:mm:ss.ms
We need to display time as a unit of measure.
We do not want to display time to express the time of day
Hi, James
Firstly, apologies for all the waiting time.
Sorry to disappoint you, but currently our plugin does not support custom time format as you need here.
If you use our Time Columns, we currently only have these two formats to choose from :
1:25 PM (12hour)
13:25 (24hour)
-
-
You can check more details on this Documentation about our Time columns.
-
The only way to currently present these custom values, is if you use our String Type Columns.
-
So, at this time, we don't have a built-in feature to achieve this, but you can suggest it for our developers - they will do their best to make a solution in the future.
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 page if you'd like ( it is also available in the plugin dashboard), 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.
-
If you need a solution for it now, maybe it can be done with a high level of custom work, but I am not sure, to be honest. Our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future.
We can recommend reaching out to someone who does custom solutions, such as WP Kraken, but we can't advise on their pricing.
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