Greetings. I am using wpDataTables as well as the Gravity Forms integration to capture data entered into a Gravity Form and display it on the front end. Below is a very brief example of the table on the front end:
I need to execute and display some time calculations, and I was wondering if you had any ideas on how I could do that. There are two general categories of time calculation that I need to set up:
1) the difference in time between entries in the table above; and
2) the difference in time between certain entries and the current time.
I am aware that the formula columns in wpDataTables supports only integers and not times, so it does not appear that I can use a formula like that. I do have the ability to conduct time calculations in a gravity form, but I haven't been able to pull specific times into a gravity form (e.g., the last time the form was updated).
Ideally, I would like to handle this calculation internally within wpDataTables, without the need to use something external like a Google sheet.
I know that I can use an SQL query to pull specific data from a table, but again I'm having trouble figuring out how to then create a time calculation.
Any assistance would be greatly appreciated. If you need any more information, please let me know.
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.
-
We also don't have any workaround examples to share, at this time it is not possible in any way to make calculations in our plugin by using time values;
we can only perform calculations with numeric values.
-
Of course, you can try to research sources such as Stack Overflow, to see if any user comes up with any new solution;
and if you need help by a developer to look for custom solutions, our developers are not able to provide custom work;
so we can only recommend reaching out to someone like WP Kraken Team, but we can't advise on their pricing.
Greetings. I am using wpDataTables as well as the Gravity Forms integration to capture data entered into a Gravity Form and display it on the front end. Below is a very brief example of the table on the front end:
I need to execute and display some time calculations, and I was wondering if you had any ideas on how I could do that. There are two general categories of time calculation that I need to set up:
1) the difference in time between entries in the table above; and
2) the difference in time between certain entries and the current time.
I am aware that the formula columns in wpDataTables supports only integers and not times, so it does not appear that I can use a formula like that. I do have the ability to conduct time calculations in a gravity form, but I haven't been able to pull specific times into a gravity form (e.g., the last time the form was updated).
Ideally, I would like to handle this calculation internally within wpDataTables, without the need to use something external like a Google sheet.
I know that I can use an SQL query to pull specific data from a table, but again I'm having trouble figuring out how to then create a time calculation.
Any assistance would be greatly appreciated. If you need any more information, please let me know.
Thank you!
Hi, Frank
Sorry for the delay
At this time, we don't have any built-in feature to achieve any kind of calculations with time values,
but you can suggest it to 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.
-
We also don't have any workaround examples to share, at this time it is not possible in any way to make calculations in our plugin by using time values;
we can only perform calculations with numeric values.
-
Of course, you can try to research sources such as Stack Overflow, to see if any user comes up with any new solution;
and if you need help by a developer to look for custom solutions, our developers are not able to provide custom work;
so we can only recommend reaching out to someone like WP Kraken Team, 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