What you are showing is the raw data from the datasource. You can achieve an export to give this result but you may need to do some additional work to make it happen.
As I mentioned, the CSV Export function in AppSheet is a View Export. It will show the exported values as seen in the view. This means that REF columns will display a Label value rather than the actual REF value. If you want the REF value in the export (as implied by your screenshot), you will need to
...EITHER....
include columns that provide the REF value and show those in the view instead
...OR...
change the referenced table so that the Label is the REF value(i.e. Key column of that table). Note that this affects ALL views - they will all show the REF value instead of the normal user friendly Label.
There may be other columns that need similar attention.
Creating the Export Button
After addressing the above concerns, this is relatively simple.
- Create a view to show all the columns you wish to Export and in the order you wish. If you don't need a special order then just accept the View default - i.e. need to nothing else in the view for column.
- Create the Export action for the table.
- Set the action to "Overlay" so it shows a button on the view
To get more details on how to set this up, refer to this article:
https://support.google.com/appsheet/answer/11579391?hl=en
NOTE: That export only works on Desktop Browsers. Additionally, you will want to setup the capability to filter the rows into the view. The article above does go into how to do that using LINKTOFILTEREDVIEW() function.
If you still need more help, please ask.
LinkedIn
Twitter
