export a field with records in CSV

[abarron3726]

good day Does anyone know what I need to do to export a value of a specific field with all its records to a CSV only what I select or specify

Thanks for the help

[WillowMobileSys]

You may need to clarify one thing...what do you mean by "to a CSV only what I select or specify".  What "things" do you want to select or specify?

So, the Export to CSV action in AppSheet is meant to be a View Export - mostly meaning it exports what is seen on the screen, both columns and rows.  I say "mostly" because if memory serves (it's been awhile) the Export does include some necessary column to maintain integrity.

What you can do, is create a View of the columns you want in the CSV and then use a LINKTOFILTEREDVIEW() function to apply criteria to filter the rows.  If you want that criteria to be user selected, then you will need to build a Form view that allows the user to select which columns to filter and by what criteria.  Then upon Save of that form, navigate to the view filtered by the LINKTOFILTEREDVIEW() function.  On this view would be the CSV Export button to create the CSV file.

What you CANNOT do in the filtered view, is dynamically choose which columns are included.   A compromise, depending on your need, might be to create a few views each with a different set of columns showing and then you can choose which filter view to navigate to upon SAve of the Filter Selection Form.

[abarron3726]

I leave you an example I only need to type the number 2005152 and call all the records that go in the rows only of that number

[WillowMobileSys · Accepted solution]

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.

1. 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.
2. Create the Export action for the table.
3. 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.  

[abarron3726]

Thank you very much friend for taking the time, I owe you one