I need the ability for my users to export a list of applicants for their events to a CSV from the app. I have followed these instructions.
I have two tables: events and applications. I have the “related applications” view embedded in the events detail view. When an event organizer clicks on “view” or “expand”, I have set the “export” action to show on the expanded view.
Regardless of how I set up that view - pointing to a slice or the whole table - which columns are displayed - searches - filters - whatever - the CSV always downloads with every record associated to that event and every column in the entire table.
I also tried it thru a “link to filtered view” action that links to a view based on a slice that only has the columns that I want to show in the export (including the key column and reference column just in case). Same results.
I truly don’t know how to fix this and it’s getting incredibly frustrating.
1 Like
Hi @colodev
If you want to instantly filter data in AppSheet for export to CSV, simply filter it first using the search menu. Click the triangle symbol. Options will appear. You can filter them. Once you’ve filtered the data you want to display, click the Export CSV action. This is the most instant and effortless method.
just an example, CSV must be from a computer, not from a HP
1 Like
I feel like we are not getting all the details about your app implementation. I’ve just recently setup multiple features to download CSV’s and re-tested those just now. Whether I filter with the Search bar or use Filter criteria, the resulting CSV reflects only the rows included.
It is true that the CSV will download every column in the datasource. To control that, you would want to create a Slice and include in that Slice ONLY the columns you want in the CSV.
Can you provide more details about your specific CSV action and the view it is operating against?
3 Likes
Here are my screenshots that should help. Right now, the CSV isn’t populating ANYTHING, which is very strange. I was able to get the slice setup so that the fields work (at least from this view).
Here’s the view that is embedded in a dashboard view (there are no other constraints placed on the view):
Here is the slice
Here’s the view with the download button. This is unfiltered, but you can see that there are results.
Here is the resulting CSV:
I have also tried running it after filtering and it also did not have any results.
1 Like
Make sure you are grabbing the LAST downloaded file. The files are most likely NOT overwritten.
Your Slice seems ok.
I’ll assume your “Download Applications” is just a straight CSV type action.
In the View Name you have “_Inline”. I don’t know if including that might confuse AppSheet. Views with “_Inline” are typically reserved for displaying List columns. I’ve never tried naming a “normal” view with “Inline” before.
I would try duplicating that view, remove the “_Inline” portion and use that as your Applications view to see if it makes a difference.
Otherwise I am not seeing a problem. If the Application views has rows, there should be data downloaded in the CSV file.
2 Likes
