How to download into a file csv an slide ?

HIII

So, i want to download a file csv, where the data cames from an slide .

I have two tables, one named users and the other one named timesheet, timesheet has a column named id_user of type ref, so the two tables a joined through that column(id_user)
I have an slide called SelectedUsers his data source is the table timesheet and it filters just the activities of the user selected, i use this formule: [ID_USER] = [_THISROW].[ID_USER]
Then i have 3 views, one named USERS in that view i can visualize a list of users,other one Users_detail in that view i can see the details of the user selected and the last view is ActivitiesperUser in that view i can see the activities that a user has registered in a table, the columns that shows that view are: Name_user, date, activity(description) and hours(dedicated to that activity).
So i want an action that is in the view Users_detail that download me into a csv file the slide SelectedUsers (where the data that is there, are the activities of the user).
this would be fixed if appsheet allowed that the data source of an action was an slide,but he doesn't.
i already tried creating an action with the option : import a CSV file for this view and it doesn't work.
I also already tried it using an google app script, where the script contain the code that download a csv file, it didn't work for me.
I also tried creating a bot and i got confuse,so failed again.

someone has a better idea?๐Ÿ˜…

 

thanks

0 1 59
1 REPLY 1

There are only two built-in actions - Import to a view and Export from a view.   I believe you want the export from a view action.   If you have a Slice with the information you want to export, then create a View on the Slice and add an export action to that view.  You should then be able to tap the action button to export the data.

Note that you can use the Slice to filter the columns you want in the CSV as well as the rows.  Be aware that some columns may not be helpful as is - e.g. a REF column which stores the row id - so you may need to create extra columns to pull in the details you wish to include in the export and have those included in the Slice.

I hope this helps!

Top Labels in this Space