CSV export not showing values with a Show-If formula that returns false

AppSheet AppSheet Q&A
, ,
1

Hi all

I just realised that values, that have a Show If formula that returns false, will not show in a csv export, although I unticked the “Apply show-if constraints universally”.

eddie61_0-1660554741073.png
eddie61_0-1660554741073.png288×146 6.95 KB

Is this how it is intended to work? If so, is there a workaround for including does values in a csv?

Thanks in advance.

Adrian

2

Hi @eddie61

You could make another view that shows the data you need and export that view as CSV.

2 Likes
3

I have the data in the view. It also shows the columns in the csv, but not the values.

4

I understand you may have unique requirment, i.e. not to show the value in the column inside the AppSheet view, but the values are downloadable inside the CSV file exported from the view.

Try this expression for Show if constrain in your target column.

context(“host”)=“server”

The values in this column is not displayed on the view, but they will be there when you download to CSV.

@takuya_miyai

8 Likes
5

Thank you @Koichi_Tsuji this does the job.

2 Likes
6

I personally think this should be viewed as a bug

  • If I don’t want to show a column in the CSV… I’ll restrict that column through the use of a slice

What purpose is there to include the column, if it’s only going to be empty?

  • If we’re going with the assumption that “the show ifs control CSV data export” - then the show if should completely remove the column from the CSV if it’s not supposed to be shown.

IMHO: it’s sloppy to have a column included that’s completely empty
- Makes someone look like an amateur