Dear AppSheet, Is there any way to filter a ...

(Hopp Karla) #1

Dear AppSheet,

Is there any way to filter a table before downloading to CSV? I see that one can control which columns are exported by creating a slice, but although I filter the table using LINKTOFILTEREDVIEW, the Export to CSV dumps all rows in the table. Not what I would have expected.

My table has a batch number column. I’d like to be able to export only those rows with a particular batch number, for import into another system. Is there currently any way to do this?

I think this is similar to the questions from Warang L and Sabio Soporte.

Thanks!

(Suvrutt Gurjar) #2

Hi @Hopp_Karla,One approach is to create a slice

on the table where it filters the rows by the batch number(s) you want.

A sample app mentioned below does something similar. It downloads in CSV the CarSales reports by the quarter.

appsheet.com - Sales Report - A sales reporting app with Dashboard and Deck views of sales data grouped by time, person and vehicle type. Sales Report - A sales reporting app with Dashboard and Deck views of sales data grouped by time, person and vehicle type. appsheet.com

(Aleksi Alkio) #3

You could ask the batch# with the usersettings for your slice and then you could control it better.

(Jader James) #4

in action of the type: “Export this view to a CSV” we can only use TABLES and dont SLICES @Aleksi_Alkio

(Hopp Karla) #5

@Suvrutt_Gurjar I had taken a look at that Car Sales app. Unfortunately, they aren’t filtering by rows in any of the csv downloads. For the export by make, they dump the entire contents of the CarSales table, and for the quarterly reports, they’ve denormalized the table so that by selected only certain columns, it filters by quarter (but this isn’t filtering the rows). Thanks for your suggestion though.

(Hopp Karla) #6

@Aleksi_Alkio I wonder if you could explain a bit more what you mean. I had been wondering if there was some way I could allow the user to select the batch (ideally from a table of available batches), save the id for the selected batch somewhere (either to a user prefs table I create in our database, or in the AppSheet user settings), and then use that batch in a security filter on a read only version of the table. However, I don’t know how to save that selected batch. Any wisdom?

(Hopp Karla) #7

@jader_james Hello, I realize this is the defined functionality right now…since you can’t select a slice in setting up the CSV download action. It is a shame though, and something I think need to be added. It’s not very useful to have to dump the entire table. @Aleksi_Alkio

(Hopp Karla) #8

@Aleksi_Alkio So it does work if I add a user settings field that is a ref to batches, then create a read only copy of the table I wish to export with a security filter based on the batch saved in the user setting. This seems so very clunky though. A lot of clicks and not very intuitive to the user. Do you know whether AppSheet has any plans to allow the use of slices in the CSV export function?