Hello,

Sorry to disappoint you, but you won't be able to store a file on OneDrive or SharePoint and have an URL like that linked or imported to our Tables.

In regards to connecting an URL from any domain for CSV or Excel files;

Basically there are two options when selecting a file source path;

From the WP Library or from any Domain;

1. If you choose from WP Library, then it needs to be on the same domain as WordPress;

2. but if you choose from any URL - then the main point is that the file path needs to be directly accessible online.

That means no login is required to access that path;

and also this path needs to end with the file name and the file extension.

So, something like : https://someWebsite/someDirectory/fileName.xls

that will work.

If your current file path does not end with the CSV/or Excel extension, that will not work.

At the moment, we don't have a way to change that, but if you wish, you can make a future development suggestion for the option of having a file on SharePoint or Microsoft OneDrive and having that as data source URL, but I can't say a realistic ETA if or when that might be available.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

Let me know if that makes sense.

Hi Dominic,

If I understand this use-case you described;

You basically have all this data in the source Excel file and you linked a table, but now you just wish to limit each logged User to filter the table - so each user can only see the rows associated to their user ID, right?

If that is the case, 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.

I will show you an example.

- 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 Place Holder "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/);

- 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.

Thank you.