Hi Matt,

Apologies for late replies today, thank you for your patience.

Yes, we have a workaround for non-editable ( linked to a file source) tables, to restrict only showing the rows for the currently logged-in user ID.

I will show you an example for using tables linked from Excel, but it is exactly the same 'logic' how the Tables linked from Google Sheets work.

- First, you would have to add a custom "user_id" column on the source Excel side, which you can hide if needed in our plugin from the front-end. 

We will add a predefined filter value to it, using a PlaceHolder "Current User ID";

- Check that the filter type is set as "Text", as shown on this screenshot.

- Here is how an example table linked to a source file looks before we make any changes, with visible filters above the table.

And now, when we set the pre-filter, with Administrator logged in ( In our case, the user ID is 1), we only see rows matching that user ID.

- (If you need more detailed information about using Place Holders in wpDataTables, here is our documentation about that https://wpdatatables.com/documentation/table-features/using-placeholders/);

And you can optionally set it to "exact filtering" to avoid having it load partial result data for 'similar' user ID's that have like user ID 1 and user iD 12, etc.

With exact filtering it will only return that user ID rows.

- The user_ID filter is still visible, which means, if someone changes/deletes this value, they could see the whole table.

We will hide it from the front-end with some custom CSS added in the "Customize" section of the main table settings.

- It should be easy to do, depending on your knowledge of HTML and CSS.

You have to find the correct selector using the browser inspector tool, add the style "display:none" property to it, and it will disappear from the front-end.

On our example table, the custom CSS is :

#table_1_5_filter_sections  {
    display:none; }

- Now, the user_ID filter is gone from the front-end.

- Optionally, you can hide the user_id column from the front-end, if needed, either using the column settings tab or the "column list" button from the back end Admin area.

- If you need more details about this, don't hesitate to contact us further.