# Using a table aggregation to sort by file name

**URL:** <https://community.tulip.co/t/using-a-table-aggregation-to-sort-by-file-name/10078>\
**Category:** Product Suggestions\
**Tags:** feature-request\
**Created:** [December 18, 2023, 6:06am UTC](https://community.tulip.co/t/using-a-table-aggregation-to-sort-by-file-name/10078 "2023-12-18T06:06:07Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Preston](https://avatars.discourse-cdn.com/v4/letter/p/a587f6/32.png) [@Preston](https://community.tulip.co/u/Preston)\
**Post date:** [December 18, 2023, 6:06am UTC](https://community.tulip.co/t/using-a-table-aggregation-to-sort-by-file-name/10078/1 "2023-12-18T06:06:07Z")

</div>

I’d like to implement a drop-down in my app based on unique filenames in my table. With a text value property, I’d use a Single Select widget with table aggregation to list the options.

Rather than create a separate text property to store the filename, it’d be nice to be able to select a record via a table aggregation of the filename, using a Single Select widget.

---

<div class="post-metadata">

**Author:** ![Beth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/beth/32/5987_2.png) [@Beth](https://community.tulip.co/u/Beth)\
**Post date:** [December 18, 2023, 6:17pm UTC](https://community.tulip.co/t/using-a-table-aggregation-to-sort-by-file-name/10078/2 "2023-12-18T18:17:03Z")

</div>

Hey Preston - thanks for the suggestion 🙂

Correct me if I am misunderstanding your question, but what you are asking for should be possible currently!

Here are the steps:

1. In your Tulip Table, create a blank query (this is just a placeholder for the unique values aggregation)
2. In your Tulip Table create an aggregation to filter all the unique values for your file names  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/8/8d9ab397339acb1aaff4cc1b968eabd199188540.png)
3. In your app under the Records menu, add the table, create a record placeholder, add the blank query, and add the unique value aggregation  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/1/1117532a6193433f843b89959f41c5cd0e95f9ff.png)
4. Create a single select, and under Data Source, select the unique values aggregation for filenames  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/a/ae5aae80aef49927d55583df969674650e9d8cd7.png)

Now, when you test the app, you should see the single select dropdown populated with the unique file names from your table!  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/9/97bc9ccd5f4fee8c49d511d2a6088792ed3bea95.png)

---

<div class="post-metadata">

**Author:** ![Preston](https://avatars.discourse-cdn.com/v4/letter/p/a587f6/32.png) [@Preston](https://community.tulip.co/u/Preston)\
**Post date:** [December 18, 2023, 9:58pm UTC](https://community.tulip.co/t/using-a-table-aggregation-to-sort-by-file-name/10078/3 "2023-12-18T21:58:49Z")

</div>

Thanks for your reply Beth.

Sorry, I should have been clearer in my initial message. I have a table property of the file field type. It’d be nice to query/aggregate based on that name, rather than having another text property to store it in.  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/b/beb14cce2783877acaf052ca563294e284d2becc.png)

On another note, it’d be nice to be able to edit those filenames from with the app.

I don’t believe either of these functions currently exist, but I could be wrong!

---

<div class="post-metadata">

**Author:** ![thorsten.langner](https://avatars.discourse-cdn.com/v4/letter/t/4bbf92/32.png) [@thorsten.langner](https://community.tulip.co/u/thorsten.langner)\
**Post date:** [December 19, 2023, 3:04pm UTC](https://community.tulip.co/t/using-a-table-aggregation-to-sort-by-file-name/10078/4 "2023-12-19T15:04:33Z")

</div>

> [@Preston](#):
>
> On another note, it’d be nice to be able to edit those filenames from with the app.

I find this the more important one …

---

<div class="post-metadata">

**Author:** ![Beth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/beth/32/5987_2.png) [@Beth](https://community.tulip.co/u/Beth)\
**Post date:** [December 22, 2023, 1:40pm UTC](https://community.tulip.co/t/using-a-table-aggregation-to-sort-by-file-name/10078/5 "2023-12-22T13:40:33Z")

</div>

@Preston thanks for the additional information! A internal ticket has been made and the product team will see what they can do.

@thorsten.langner, thanks for your input as well 🙂