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
LinkedIn
Twitter
