Hi, Daniel 

Thanks for reaching out to us

-

I am not 100% sure if it is possible to edit the data pulled from the database, from the forminator forms, in the way that you described... i have to double-check this with my senior colleagues.

-

Could you allow us remote access, so that we can take a look at the table at the back-end?

Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

And point us to table ID, please.

Hi, Daniel 

Thanks for the access. I think i can understand the use case better, thanks for more details.

I believe you should be able to achieve your goal, if you can somehow add, perhaps a hidden column that would hold true or false values.

If you can set it up so that this field can have either true or false for possible values;

then you could use a selectbox as editing type of the column in wpDataTables, for the higher level user to edit and switch it between false or true.

-

For filtering data differently between users;

i suggest making two tables.

One for the users who will fill out their forms,

and you can use our "Users see and edit only their own data" feature, so that way they can see only their rows, please check more details on it here.

You can also control editing, by role;  or you can disable it by setting editing type of any column that should not be edited to "none".

- 

And you can create another SQL Query that would pull data for the higher Role user;

for this table you can disable the "Users see and edit only own data" feature; and you can set it up so that this user would see all the rows, and hidden fields, if there are any.

-

You could restrict access to the pages, using any Membership plugin, so that only users with higher role can access the page with editable table showing all data;

for other user roles it would block access.

-

Let me know if that makes sense, and if that might work as a solution?