# Extract specific data to a collection

**URL:** <https://community.glideapps.com/t/extract-specific-data-to-a-collection/71520>\
**Category:** Ask for Help\
**Tags:** collections\
**Created:** [March 8, 2024, 3:24pm UTC](https://community.glideapps.com/t/extract-specific-data-to-a-collection/71520 "2024-03-08T15:24:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Arsar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arsar/32/67141_2.png) [@Arsar](https://community.glideapps.com/u/Arsar)\
**Post date:** [March 8, 2024, 3:24pm UTC](https://community.glideapps.com/t/extract-specific-data-to-a-collection/71520/1 "2024-03-08T15:24:21Z")

</div>

Hi, guys.  
I have a little hurdle that I still can’t get over.  
I am making reports with information that was previously collected from a form, the report looks like this:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/52181ed367488fffedbb412bfaed164838103e5d.png)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6e878e01331a909354f358f0bf483fac5f5385ab.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7b90e34223adb681dd766407a12cf04a6a8210f7.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7a6f8a08bcddaba39b5ba4c2b44fa0a494f118ae.png)

My problem is that I want to make a collection only extracting the data of Estado(Status), Tiempo(Time) and assign the corresponding concept, for example “1.1 Amortiguador derecho delantero”, or the concept 1.2, 1.3, etc. I don’t know how to relate this information in another table.

What I want to achieve is a Collection where the information looks like this, it would be a summary of all the information where only the status, time and concept would be shown.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/aee543cbf180f03b948d0bd0099f823eed2741f8.png)

I plan to add a filter to sort by status and time, this example I did it in the following way and it is not the best because I think I can not apply a general filter for both collections, I’m stuck on this issue, thank you in advance, I hope I could explain correctly.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/3/2394e5805920c1a0a12b198164aee16ec6b79277.png)

---

<div class="post-metadata">

**Author:** ![Arsar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/arsar/32/67141_2.png) [@Arsar](https://community.glideapps.com/u/Arsar)\
**Post date:** [March 8, 2024, 5:07pm UTC](https://community.glideapps.com/t/extract-specific-data-to-a-collection/71520/2 "2024-03-08T17:07:47Z")

</div>

Ok, I don’t know if this is the best practice but it seems to work for me this way, I’ll leave it in case someone else finds it useful 🙂  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/5/6507e0f1760bad8bb037e8296ed489339518da56.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 9, 2024, 1:10am UTC](https://community.glideapps.com/t/extract-specific-data-to-a-collection/71520/3 "2024-03-09T01:10:07Z")

</div>

Can you explain to us what kind of info the data table screenshots contain? I assume those are from the same table, the same 3 rows?