I have data being pulled across from my spreadsheet, this works. I have then added a query to show only rows where the column E shows specific data (select * where E = 'No') This works brilliantly as-well and i only see entires where the E column has a No in it.
Finally when i apply the proxy to filter users the query stops working, the user sees all of the data with there permissions regardless of column E being Yes or No.
Users should just see records in the spreadsheet that are No
Thanks in advance
Please sign in to leave a comment.