Hi Erik,

1. When it comes to each user inserting their own data :

We have an easy built-in solution for that, if you need each user to only see and edit their own rows, please check out more on this Page.

In short, you would create a column and name it anything you wish, which serves as 'user id', so it picks up and stores the currently logged user ID in each row and it is used for that feature as explained on the Documentation.

2. Compare their achievements in a nice visual format :

Can you please elaborate in more details on that point, if possible please add any example with screenshots or a Video to clarify it as much as possible and we can advise if we have a solution for that part?

If a video gets too large, you can upload it to something like weTransfer or GoogleDrive and send us a download link.

If it shows any sensitive data, please mark the reply as PRIVATE, for security reasons, then only we can see it.

3. I need to display personal information only for logged in users, and

I need to display certain aggregate information publically for everyone.

Our plugin does not have any capability to limit access to a table/post/or page for logged users/members , and to restrict/block access for others;

but you should be able to achieve this use-case by combining our plugin with any Membership plugin;

and if needed you can also install "user role editor" plugin if you need to make custom roles on your site.

So, you could set up a page where a table with limited access would be, and you can set the access for this page to be available only for users with certain Role; and have it restricted/blocked for non-logged users.

For example, you can have one main/master Manual table which will store all the data in the database.

Then, you can check this table's MySQL Table name from the Editing tab in the back-end table settings,

and you will be able to make multiple SQL tables that pulls data from the same "master table",

and any editing you do on all these other SQL tables are going to be stored in the same table in the database,

This will be my example table :

Now, to make a new SQL Table from it,

first, check in Editing Tab/MySQL table name for editing:

in my example, the Manual table name is wp_wpdatatable_39,

so i make a new SQL table that will pull data from it;

and we can choose all columns like :

SELECT * FROM Table_Name

or just specific columns;

we can also have completely different settings/filtering/sorting and limitations for front-end users on each table;

and you can make multiple SQL Query tables that pull the same data from the "main table".

SELECT  column_name1,
        column_name2,
        column_name3
FROM table_name

-

In this example, if i want to limit to only show the "Company" column, and i will leave wdt_ID ( because we got to have row ID)  and userid ( if we want userID for limiting rows per currently logged user ID),

when i hide those columns in the end, the front-end user will only see the "company" column.

SELECT  wdt_ID,     
   userid,     
  company    
   FROM wp_wpdatatable_39

Later, you can make another SQL Table that will show some other columns, have other filters and so on ( depending on what you need to achieve)...

You can see my Video example here https://watch.screencastify.com/v/jOXrsJ9jaspWG5m3VqZH

Let me know if that makes sense and if you have any questions

We can't recommend which Membership Plugin could be the best with our plugin,

basically, you can't go wrong if you choose one of the most popular ones.

We don't have any reports of any Membership Plugin having a conflict with our plugin at this time.

4. Showing certain aggregate information :

Can you please elaborate on that part, too, what kind of information should be presented/ I presume maybe some calculated info, etc?

If you can add any screenshots or a Video, that can help to clarify it, that would be great.

And i just wanted to point out that you can try wpDataTables before purchasing

 on our sandbox Demo sites ( you can find links for the main plugin Demo,  

as well as add-on Demos, in my signature),

and there is a 15-day money-back guarantee period, 

so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

Let me know if you have any additional questions.