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.
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
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.
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |