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?
You may want to make a Query Column with the filters you want and the sorts you want:
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:
OR
For the template, what data do you want it to have ? Only one column for each item ?
Thanks for responding.
No, I need two columns
Name and Number
What is the format you want ? I will make it for you and then explain it to you step by step 
In reality there are 3 fields
You want these three field in a single field like : “Daniela Menezes - 1 - 18” ?
What output format do you want ?
The ordering is from largest number to smallest.
The name and game belong to the numbers.
Same or similar to the image.
By “template” you meant a “template column” ?
yes.
Unlike the collection format, all those registered must be in the template, without the need for pagination.
Yes
Name - Game - Total hits
No need to add a query column then.
You need to add a template column in your table:
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:
Remove all other values:
Add the style you want:
Set a high page size (but not too high to avoid performance issues).
In the options tab, set the filters, sorting and even in-app filter that you want:
For the sorting, make sure to select the number column that you wanted to sort from “biggest to smallest”.
And VoilĂ !
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
I can make the template too but it doesn’t stay in ascending order. Only in database order.
Just like what you did.
But it doesn’t meet the need.
At that point, now you might want to do a query column and use the lookup to get that template column.
Create a joined List column that take the lookup column and separate by “new line” (enter):
It will look like this:
Then, create a button that would trigger send to WhatsApp and set the message to that joined list column:
I think I was missing something, sorry.
I did exactly as explained but I can’t search for the 3 data. Just the name.