Thank you @Sho ! This is indeed what I would like the end result to be only Without the users being able to access ALL the data..
I would'n like them to see the Filtered by ... as the attached picture and subsequently being able to view the whole table.
Which means I must be able to do the filtering in a previous step and present them with the results only.
Just how a pre-filtered shared view ends up only showing the filtered results without URL filtering.
@Sho Do you know if I can do the same URL filtering to an embedded view? I could maybe pass my filters in the URL of the embedded view before it loads and since the URL is not visible to the user in the embedded view do it there?
EDIT: Yes this is possible. So I get the static embed link for the whole table, and I pass the filters in the embed URL which is not visible. If you know, does this surely protect the whole thing from being shown? I guess someone could get the embed link from the webpage inspector ?
I can also pass a list of record IDs which I have gathered before hand through the API filter by formula, "somewhere" and view them nicely, if this helps you .. It doesn't have to be filter by formula directly on the view, I can do it beforehand.
Finally, I wouldn't mind if the "view" was a pdf/document with the filtered data that was produced on the fly and I somehow was able to get it quickly and throw it as embedded on my website
