# Collection

**URL:** https://community.glideapps.com/t/collection/77549
**Category:** Ask for Help
**Created:** [November 1, 2024, 12:32pm UTC](https://community.glideapps.com/t/collection/77549 "2024-11-01T12:32:12Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)
#### Post date: [November 1, 2024, 12:32pm UTC](https://community.glideapps.com/t/collection/77549/1 "2024-11-01T12:32:12Z")

</div>

Good morning,  
Is it possible to create a template from a collection with a filter?  
Example:  
I have a table with numbers that are not in sequence and I use the collection to show the customer the numbers in ascending order.  
It turns out that he wants to receive the numbers ordered via WhatsApp.  
So I have to throw the result of the collection filtered in ascending order into a template.  
Can anyone help me?

---

<div class="post-metadata">

### Author: ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [November 1, 2024, 12:39pm UTC](https://community.glideapps.com/t/collection/77549/2 "2024-11-01T12:39:43Z")

</div>

You may want to make a Query Column with the filters you want and the sorts you want:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/0/50872a53208a95a2d7aa0eefae69373e996ca542.png)

To be able to get the data you want inside a template, you could actually use a lookup column first to get the column you want from the query:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/32396569adeb2b3b6ba1d19419999c473996df27.png)  
OR  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b58635238705a60bcdc3a7e75e8cf6926a26aed5.png)

For the template, what data do you want it to have ? Only one column for each item ?

---

<div class="post-metadata">

### Author: ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)
#### Post date: [November 1, 2024, 1:04pm UTC](https://community.glideapps.com/t/collection/77549/3 "2024-11-01T13:04:16Z")

</div>

Thanks for responding.  
No, I need two columns  
Name and Number

---

<div class="post-metadata">

### Author: ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [November 1, 2024, 1:05pm UTC](https://community.glideapps.com/t/collection/77549/4 "2024-11-01T13:05:39Z")

</div>

What is the format you want ? I will make it for you and then explain it to you step by step 🙂

---

<div class="post-metadata">

### Author: ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)
#### Post date: [November 1, 2024, 1:08pm UTC](https://community.glideapps.com/t/collection/77549/5 "2024-11-01T13:08:24Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/abcaa73603af8d7c653e9dd1bfb7bc4cd374303b.jpeg)

---

<div class="post-metadata">

### Author: ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)
#### Post date: [November 1, 2024, 1:08pm UTC](https://community.glideapps.com/t/collection/77549/6 "2024-11-01T13:08:57Z")

</div>

In reality there are 3 fields

---

<div class="post-metadata">

### Author: ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [November 1, 2024, 1:10pm UTC](https://community.glideapps.com/t/collection/77549/7 "2024-11-01T13:10:10Z")

</div>

You want these three field in a single field like : “Daniela Menezes - 1 - 18” ?  
What output format do you want ?

---

<div class="post-metadata">

### Author: ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)
#### Post date: [November 1, 2024, 1:10pm UTC](https://community.glideapps.com/t/collection/77549/8 "2024-11-01T13:10:51Z")

</div>

The ordering is from largest number to smallest.  
The name and game belong to the numbers.

---

<div class="post-metadata">

### Author: ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)
#### Post date: [November 1, 2024, 1:11pm UTC](https://community.glideapps.com/t/collection/77549/9 "2024-11-01T13:11:25Z")

</div>

Same or similar to the image.

---

<div class="post-metadata">

### Author: ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [November 1, 2024, 1:12pm UTC](https://community.glideapps.com/t/collection/77549/10 "2024-11-01T13:12:44Z")

</div>

By “template” you meant a “template column” ?

---

<div class="post-metadata">

### Author: ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)
#### Post date: [November 1, 2024, 1:13pm UTC](https://community.glideapps.com/t/collection/77549/11 "2024-11-01T13:13:37Z")

</div>

yes.

Unlike the collection format, all those registered must be in the template, without the need for pagination.

---

<div class="post-metadata">

### Author: ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [November 1, 2024, 1:17pm UTC](https://community.glideapps.com/t/collection/77549/12 "2024-11-01T13:17:20Z")

</div>

Just to be sure that I understand, you want it to show in a simple text like that ?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/4/d4e4dd814875566aaf2acac928253cf72a2a96f4.png)

---

<div class="post-metadata">

### Author: ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)
#### Post date: [November 1, 2024, 1:19pm UTC](https://community.glideapps.com/t/collection/77549/13 "2024-11-01T13:19:29Z")

</div>

Yes

---

<div class="post-metadata">

### Author: ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)
#### Post date: [November 1, 2024, 1:20pm UTC](https://community.glideapps.com/t/collection/77549/14 "2024-11-01T13:20:32Z")

</div>

Name - Game - Total hits

---

<div class="post-metadata">

### Author: ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [November 1, 2024, 1:25pm UTC](https://community.glideapps.com/t/collection/77549/15 "2024-11-01T13:25:57Z")

</div>

No need to add a query column then.

You need to add a template column in your table:

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

Then use it in the layout:  
Create a collection with that table as the source.  
Set the title to that template column you just created:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a4b96912ba993ff773aa1f55a78ae3279a57524b.png)

Remove all other values:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b165bf4ffd3448d657778a7c3f282fc1e03b7e73.png)

Add the style you want:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fbb74518c5207a1271fdfede183de4ba0a7756a2.png)

Set a high page size (but not too high to avoid performance issues).  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/2/92b7991d1f7ba27fb061809e3dc5e0d9e2b4bea2.png)

In the options tab, set the filters, sorting and even in-app filter that you want:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d3c213b0b36a7f8ab8856cbd98e711f6daff2a72.png)  
For the sorting, make sure to select the number column that you wanted to sort from “biggest to smallest”.

And Voilà!

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/af4e5487e7ce6330cc2fc6883d519a7b616bb241.png)

---

<div class="post-metadata">

### Author: ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)
#### Post date: [November 1, 2024, 1:29pm UTC](https://community.glideapps.com/t/collection/77549/16 "2024-11-01T13:29:38Z")

</div>

The image I sent is like this, the problem is that I need to send it to WhatsApp and it’s not possible just through collection.  
I think. hahahaha

---

<div class="post-metadata">

### Author: ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)
#### Post date: [November 1, 2024, 1:30pm UTC](https://community.glideapps.com/t/collection/77549/17 "2024-11-01T13:30:55Z")

</div>

I can make the template too but it doesn’t stay in ascending order. Only in database order.

---

<div class="post-metadata">

### Author: ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)
#### Post date: [November 1, 2024, 1:31pm UTC](https://community.glideapps.com/t/collection/77549/18 "2024-11-01T13:31:45Z")

</div>

Just like what you did.  
But it doesn’t meet the need.

---

<div class="post-metadata">

### Author: ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [November 1, 2024, 1:38pm UTC](https://community.glideapps.com/t/collection/77549/19 "2024-11-01T13:38:10Z")

</div>

At that point, now you might want to do a query column and use the lookup to get that template column.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/f/7f45bcb7a65e4d3a6dba31027f3bc42821227546.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/051889af1fda9302ae1fc997bf5978cdb946f2da.png)  
Create a joined List column that take the lookup column and separate by “new line” (enter):  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/e/1e965fc5b59f0eeb7ea29028065038d543719814.png)  
It will look like this:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1a595e9ad283826e829547113ed6529b41e35a00.png)

Then, create a button that would trigger send to WhatsApp and set the message to that joined list column:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/1/7197a20a5cf8c072f82474bb94c0979910e7a241.png)

---

<div class="post-metadata">

### Author: ![Lomanto](https://avatars.discourse-cdn.com/v4/letter/l/7993a0/32.png) [@Lomanto](https://community.glideapps.com/u/Lomanto)
#### Post date: [November 1, 2024, 1:51pm UTC](https://community.glideapps.com/t/collection/77549/20 "2024-11-01T13:51:28Z")

</div>

I think I was missing something, sorry.  
I did exactly as explained but I can’t search for the 3 data. Just the name.

[Next page](https://community.glideapps.com/t/collection/77549.md?page=2)