i need to know if your plugin can do the next thing:
i want to create a website with a sign up section, where every user can register.
i want to upload a huge excel with columns with name column and number column.
2 questions:
1. i want to know how to show the rows from the table which contains just the same user name - by user name. is it possible to show it from the same excel for each user?
2. how to do a sum option for all of the number columns and rows, for that same user that sees his relevant columns?
Thank you for your interest in our plugin, and I apologize for the late response.
If your users need to log into WordPress first, I believe the first point may be easy to do.
When users register/log-into WP, they get a unique User ID, which is stored in the database, in wp_users table. wpDataTables can use that to display only the rows which contain their user ID, so each user can only see and edit only their own data. To have the table show only their username, instead of an actual user ID, you would need to have a separate table which would have the user information, and each row would be associated to a separate user. Then, you can use the User ID column in the first table, and connect it to the other table via Foreign Keys, so the plugin displays their user name instead of User ID. If you have all that info in an Excel file, you can use it to display the data from there by linking to that Excel file. That table will not be editable though, as it is only used to display information from an existing data source.
2. If you wish to simply add a SUM option at the end of a column, you just need to go to the column's settings, and turn the SUM option on. You can take a look at our calculation functions to see how it actually works.
hi,
i need to know if your plugin can do the next thing:
i want to create a website with a sign up section, where every user can register.
i want to upload a huge excel with columns with name column and number column.
2 questions:
1. i want to know how to show the rows from the table which contains just the same user name - by user name. is it possible to show it from the same excel for each user?
2. how to do a sum option for all of the number columns and rows, for that same user that sees his relevant columns?
Hello itay
Thank you for your interest in our plugin, and I apologize for the late response.
If your users need to log into WordPress first, I believe the first point may be easy to do.
When users register/log-into WP, they get a unique User ID, which is stored in the database, in wp_users table. wpDataTables can use that to display only the rows which contain their user ID, so each user can only see and edit only their own data. To have the table show only their username, instead of an actual user ID, you would need to have a separate table which would have the user information, and each row would be associated to a separate user. Then, you can use the User ID column in the first table, and connect it to the other table via Foreign Keys, so the plugin displays their user name instead of User ID. If you have all that info in an Excel file, you can use it to display the data from there by linking to that Excel file. That table will not be editable though, as it is only used to display information from an existing data source.
2. If you wish to simply add a SUM option at the end of a column, you just need to go to the column's settings, and turn the SUM option on. You can take a look at our calculation functions to see how it actually works.
Best regards.
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