# Export CSV filtré

**URL:** <https://community.glideapps.com/t/export-csv-filtre/77372>\
**Category:** Ask for Help\
**Created:** [October 27, 2024, 11:42am UTC](https://community.glideapps.com/t/export-csv-filtre/77372 "2024-10-27T11:42:52Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Perrio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrio/32/81208_2.png) [@Perrio](https://community.glideapps.com/u/Perrio)\
**Post date:** [October 27, 2024, 11:42am UTC](https://community.glideapps.com/t/export-csv-filtre/77372/1 "2024-10-27T11:42:52Z")

</div>

Bonjour à la communauté.  
J’ai fait un app qui evalue des apprenants sur plusieurs stages.  
Je voudrais exporter en fin de stage la liste des évaluations en fonction du stage.  
pour ce faire, j’ai :

- Une datatable avec toutes les évaluations

Dans l’app, j’ai une page export dans laquelle j’ai un “Choice” qui sélectionne le stage voulu dans la data table, me rempli une table sur la page avec les évaluations concernées.

A partir de là, je voudrai faire un export csv… C’est là qu’est l’os !  
Ma table étant remplie par la datatable, le csv reprend toutes les évaluations et non pas celles du “Choice” uniquement.

Qui peut m’aider ??

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 27, 2024, 11:54am UTC](https://community.glideapps.com/t/export-csv-filtre/77372/2 "2024-10-27T11:54:38Z")

</div>

Create a Query or Multiple Relation column that matches the choice with the same value in the Ratings table, then use that column as the source of the CSV Export.

---

<div class="post-metadata">

**Author:** ![Perrio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrio/32/81208_2.png) [@Perrio](https://community.glideapps.com/u/Perrio)\
**Post date:** [October 27, 2024, 11:59am UTC](https://community.glideapps.com/t/export-csv-filtre/77372/3 "2024-10-27T11:59:49Z")

</div>

Thanks for your answer, but i need more help.  
I make a Datatable named csv with a query column.  
In the fild source i put may eval datatable  
In filter i put that the cours in the eval datatable is the choice cours  
But i have no response

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 27, 2024, 12:02pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/4 "2024-10-27T12:02:20Z")

</div>

Some screenshots would be helpful.

---

<div class="post-metadata">

**Author:** ![Perrio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrio/32/81208_2.png) [@Perrio](https://community.glideapps.com/u/Perrio)\
**Post date:** [October 27, 2024, 12:03pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/5 "2024-10-27T12:03:49Z")

</div>

Sorry

 ![Capture d’écran 2024-10-27 130252](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/c/6c4d5fa66bd04ed24b325b9a25d4721abd3787b4.jpeg)

In this windows, i put CA1E - 1 by custom.  
When i choose it in a datatable, it dont work (i cant save)  
It like the field in the datatable have not the good format

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 27, 2024, 12:05pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/6 "2024-10-27T12:05:52Z")

</div>

Looks like you are hard-coding the Session value in the filter. I thought you wanted to filter by the value of a choice component?

---

<div class="post-metadata">

**Author:** ![Perrio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrio/32/81208_2.png) [@Perrio](https://community.glideapps.com/u/Perrio)\
**Post date:** [October 27, 2024, 12:06pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/7 "2024-10-27T12:06:23Z")

</div>

Yes that what i want

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 27, 2024, 12:06pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/8 "2024-10-27T12:06:54Z")

</div>

> [@Perrio](#):
>
> It like the field in the datatable have not the good format

Can I see a screen shot of the data table please? (including the column headers)

---

<div class="post-metadata">

**Author:** ![Perrio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrio/32/81208_2.png) [@Perrio](https://community.glideapps.com/u/Perrio)\
**Post date:** [October 27, 2024, 12:07pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/9 "2024-10-27T12:07:17Z")

</div>

Here the column with the choice value

 ![Capture d'écran 2024-10-27 130555](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aa7d1c4965e03be90b936c81fa0728b94834ce2b.png)

---

<div class="post-metadata">

**Author:** ![Perrio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrio/32/81208_2.png) [@Perrio](https://community.glideapps.com/u/Perrio)\
**Post date:** [October 27, 2024, 12:09pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/10 "2024-10-27T12:09:00Z")

</div>

The source datatable

 ![Capture d'écran 2024-10-27 130743](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/d/5d0090c64f87a0c0147dea5aeb9d0e8683a2bae4.jpeg)

The app screen

 ![Capture d'écran 2024-10-27 130814](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/7/17db92b2fc259dcc4910c4de17a8dcd3119fd61c.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 27, 2024, 12:25pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/11 "2024-10-27T12:25:34Z")

</div>

In your Query, set the filter to “Session is This row-\>Poubelle”

---

<div class="post-metadata">

**Author:** ![Perrio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrio/32/81208_2.png) [@Perrio](https://community.glideapps.com/u/Perrio)\
**Post date:** [October 27, 2024, 12:28pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/12 "2024-10-27T12:28:00Z")

</div>

That means that the query should be in the eval (source) table ???  
For the moment it is in a destination table

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 27, 2024, 12:29pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/13 "2024-10-27T12:29:19Z")

</div>

The Query should be in the same table that the screen is attached to.

---

<div class="post-metadata">

**Author:** ![Perrio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrio/32/81208_2.png) [@Perrio](https://community.glideapps.com/u/Perrio)\
**Post date:** [October 27, 2024, 12:31pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/14 "2024-10-27T12:31:17Z")

</div>

Ok after how convert the query as csv ?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 27, 2024, 12:32pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/15 "2024-10-27T12:32:08Z")

</div>

I assume you are using the CSV Integration? You would set the Query as the source of that.

---

<div class="post-metadata">

**Author:** ![Perrio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrio/32/81208_2.png) [@Perrio](https://community.glideapps.com/u/Perrio)\
**Post date:** [October 27, 2024, 12:33pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/16 "2024-10-27T12:33:39Z")

</div>

Yes i have a button to create csv, open it

But in the column i cant see the query column

My query column is named “Selection”

 ![Capture d'écran 2024-10-27 133247](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/b/6b57fdb430336cf44725f3d7a7bdceea567d1d84.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 27, 2024, 12:37pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/17 "2024-10-27T12:37:06Z")

</div>

As long as the query column is in the same table, you should be able to select it.

---

<div class="post-metadata">

**Author:** ![Perrio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrio/32/81208_2.png) [@Perrio](https://community.glideapps.com/u/Perrio)\
**Post date:** [October 27, 2024, 12:38pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/18 "2024-10-27T12:38:54Z")

</div>

You can see the evals(source) datatable

 ![Capture d'écran 2024-10-27 133752](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8cb46742912c321fe613a8d95485446ae223f81c.png)

The query is right. The data are true

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 27, 2024, 12:46pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/19 "2024-10-27T12:46:12Z")

</div>

You need to select the Query column as the _source_ of the CSV, like below:

 ![CleanShot 2024-10-27 at 20.45.03@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/2/62400cfb26c91f343ea5b33c559e3903906c3074.png)

---

<div class="post-metadata">

**Author:** ![Perrio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrio/32/81208_2.png) [@Perrio](https://community.glideapps.com/u/Perrio)\
**Post date:** [October 27, 2024, 12:48pm UTC](https://community.glideapps.com/t/export-csv-filtre/77372/20 "2024-10-27T12:48:23Z")

</div>

Thank for your time  
Here is what i see

 ![Capture d'écran 2024-10-27 134757](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/3/23455694c9c98aa73a57e0970552162f26b6fbfe.png)

It is like if query column cant be seen in the app

[Next page](https://community.glideapps.com/t/export-csv-filtre/77372.md?page=2)
