Is there a way to export a view to CSV and filter it by USEREMAIL?

I am trying to enable users to export data only for the rows of data that they are responsible for.

I have created a slice and added the row filter of: USEREMAIL()=[Supervisor email]. I also created the Action to export to view to CSV.

When I preview the App as one of the Supervisors, the export contains all rows of the data. Is there a way for it to only contain rows where USEREMAIL()=[Supervisor email]?

I also tried to create another data table and put a security filter where USEREMAIL()=[Supervisor email], and the CSV export still contained all rows.

0 3 350
3 REPLIES 3

In troubleshooting, it might help to compare your app's configuration to the sample apps linked from the Actions: The Essentials - AppSheet Help article's section about the export to csv action.

debes hacer lo siguiente primero debes crear un slice y en el filtro aplica la siguiente expresion

[EMAIL]=USEREMAIL()

luego selecciona los campos a mostrar y en la automatizacion procura por seleccionar que el pais sea tipo Peru para los formatos o el que desees

FEI
Bronze 4
Bronze 4

Have you found a solution?
I also encountered the same problem,
The current approach is to add a new "action",
Select "App: go to another view within this app",
use
"LINKTOFILTEREDVIEW("viewname",USEREMAIL()=[Supervisor email])"
I can use this to open a filtered view to download the csv data I need.

Use it directly through slice, USEREMAIL()=[Supervisor email],
The information I see in the filtered view is what I need.
But downloading csv requires filtering out the data by creating the owner's email.

Top Labels in this Space