First off, your wpDataTables plugin looks magical! Thank you for putting this plugin together! I hope I get to use it for this project.
I need to find a solution that can allow any web visitor to input numerical values, then calculate additinal fields based on those values, and display them in a table. The table will have a column for user generated values, and another column with pre-defined values. I also need to dispay the percentage difference between the user and pre-defined values. I've attached a screenshot of an Excel sheet.
Ideally, we need to display the user input, and table values in a chart while the user is on the page, and only their entry. Our users will not be wordpress logged in users. They will be unanimous website visitors.
Can wpDataTables be used to accomplish that?
I saw that you have an integration with Formidable and Gravity forms, and a way to display the data into a table. Can wpDataTables display only the current entry in a table format, and chart?
I've attached a screenshot of our Excel sheet prototype. Looking forward to your reply!
Thank you for your interest in our plugin, and for your kind words.
Sounds like something you could achieve with wpDataTables.
If you have a table with columns "Scenario 1" and "Scenario 2", to calculate the percentage difference, you'd need to add a Formula (Calculated) column with the following formula:
Scenario2/Scenario1 - 1
That would display the percentage difference in the formula column.
Unfortunately, if users are not logged into WordPress, there's no way wpDataTables can display only their values in the table. We use WordPress's user ID to show different values to each customer, and every logged-out visitor has the user role = 0, so it would be impossible to show different data per each visitor.
The chart will respond every time there's a change in the table if they are displayed on the same page, though.
As for integration with Gravity and Formidable Forms, you can only select the fields which would be generated as column in the table, but there's no way of telling which was the most recent entry in the table, and to differentiate it from all other entries. The only way this could be done, would be to add a datetime column which would be used for sorting the table in descending fashion, and then set the table display only 1 row.
Thank you for taking the time to understand the details of our situation, and explaining the solutions in detail~
If Gravity Forms can be set to display only the most current entry with a datetime column, and you think that will work, that’s good enough. But it is very important that the user only sees the table and chart with only their entry.
If multiple visitors are interacting with the same page, how would Gravity + wpDataTables handle that? Is it possible for the entries to get mixed up?
Another option to achieve a similar end result would be to create a table in wpDataTables with combinations of what would have been “user inputs”. The user only sees sliders on the front end, and sets those sliders to available values. The user is basically choosing a combination of pre-calculated values, but it appears as if it’s happening dynamically. Can we achieve that with wpDataTables + Gravity Forms?
We can set the table to display only one result per page, no worries about that.
However, like I mentioned - if users are not logged into WordPress, there's no way wpDataTables can display only their values in the table.
We couldn't even use queries with Gravity Forms Integration for wpDataTables because the tables created from existing Gravity Forms using this add-on are not stored in the database, but instead only used as a data source.
If your users would sign into wordpress, then there's no way they would be able to see each other's entries.
Hi,
First off, your wpDataTables plugin looks magical! Thank you for putting this plugin together! I hope I get to use it for this project.
I need to find a solution that can allow any web visitor to input numerical values, then calculate additinal fields based on those values, and display them in a table. The table will have a column for user generated values, and another column with pre-defined values. I also need to dispay the percentage difference between the user and pre-defined values. I've attached a screenshot of an Excel sheet.
Ideally, we need to display the user input, and table values in a chart while the user is on the page, and only their entry. Our users will not be wordpress logged in users. They will be unanimous website visitors.
Can wpDataTables be used to accomplish that?
I saw that you have an integration with Formidable and Gravity forms, and a way to display the data into a table. Can wpDataTables display only the current entry in a table format, and chart?
I've attached a screenshot of our Excel sheet prototype. Looking forward to your reply!
Thank you!
Boriana
Hello Boriana.
Thank you for your interest in our plugin, and for your kind words.
Sounds like something you could achieve with wpDataTables.
If you have a table with columns "Scenario 1" and "Scenario 2", to calculate the percentage difference, you'd need to add a Formula (Calculated) column with the following formula:
Scenario2/Scenario1 - 1
That would display the percentage difference in the formula column.
Unfortunately, if users are not logged into WordPress, there's no way wpDataTables can display only their values in the table. We use WordPress's user ID to show different values to each customer, and every logged-out visitor has the user role = 0, so it would be impossible to show different data per each visitor.
The chart will respond every time there's a change in the table if they are displayed on the same page, though.
As for integration with Gravity and Formidable Forms, you can only select the fields which would be generated as column in the table, but there's no way of telling which was the most recent entry in the table, and to differentiate it from all other entries. The only way this could be done, would be to add a datetime column which would be used for sorting the table in descending fashion, and then set the table display only 1 row.
I hope this helps.
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,
Thank you for taking the time to understand the details of our situation, and explaining the solutions in detail~
If Gravity Forms can be set to display only the most current entry with a datetime column, and you think that will work, that’s good enough. But it is very important that the user only sees the table and chart with only their entry.
If multiple visitors are interacting with the same page, how would Gravity + wpDataTables handle that? Is it possible for the entries to get mixed up?
Another option to achieve a similar end result would be to create a table in wpDataTables with combinations of what would have been “user inputs”. The user only sees sliders on the front end, and sets those sliders to available values. The user is basically choosing a combination of pre-calculated values, but it appears as if it’s happening dynamically. Can we achieve that with wpDataTables + Gravity Forms?
Thank you again for the assistance!
Hi again Boriana.
You're welcome.
We can set the table to display only one result per page, no worries about that.
However, like I mentioned - if users are not logged into WordPress, there's no way wpDataTables can display only their values in the table.
We couldn't even use queries with Gravity Forms Integration for wpDataTables because the tables created from existing Gravity Forms using this add-on are not stored in the database, but instead only used as a data source.
If your users would sign into wordpress, then there's no way they would be able to see each other's entries.
You can test this in our Gravity Forms sandbox, and wpDataTables sandbox. Please feel free to play around with the plugin there, and see what it can do.
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