# Show the latest entry only **URL:** \ **Category:** Support\ **Created:** [July 1, 2023, 7:08pm UTC](https://community.triggre.com/t/show-the-latest-entry-only/431 "2023-07-01T19:08:17Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![isaac](https://avatars.discourse-cdn.com/v4/letter/i/8e8cbc/32.png) [@isaac](https://community.triggre.com/u/isaac)\ **Post date:** [July 1, 2023, 7:08pm UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/1 "2023-07-01T19:08:17Z")
Hi. I am building an app where users add ratings to risks. When displaying the list of risks I only want the latest rating to appear. Currently, all ratings are visible: ![image](https://canada1.discourse-cdn.com/flex035/uploads/triggre/original/1X/cc57dd0ba8b192c572e0202ebcf0592949d91ea2.png) Iā€™m trying to figure out a filter or data lookup that will only show the latest rating per risk. Can someone please help šŸ™‚ ---
**Author:** ![Jesse](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/jesse/32/88_2.png) [@Jesse](https://community.triggre.com/u/Jesse)\ **Post date:** [July 1, 2023, 7:42pm UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/2 "2023-07-01T19:42:52Z")
Hi @isaac, When you do a lookup action in a flow part, you can select whether it should get you a single or multiple records from a data item. Choose single. Triggre will then ask you how to sort them, in case there are multiple. Here you can choose _date_ from your data item, and sort _largest to smallest_. This will get you a single item, that is always the latest. Hope this helps! ---
**Author:** ![isaac](https://avatars.discourse-cdn.com/v4/letter/i/8e8cbc/32.png) [@isaac](https://community.triggre.com/u/isaac)\ **Post date:** [July 1, 2023, 7:59pm UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/3 "2023-07-01T19:59:07Z")
Hi If I give it a list of ratings will it narrow it down to a smaller list with the latest rating per risk or it will only give me one rating? When I tried the method, the output was a **single data item** rather than **a subset of the larger list** : ![image](https://canada1.discourse-cdn.com/flex035/uploads/triggre/original/1X/ef5d8cab898406c2b13543845473256f331aa417.png) Input is a list but ![image](https://canada1.discourse-cdn.com/flex035/uploads/triggre/original/1X/b8f02c3d55c2b4dfadc04da8264b1c9907d1f2d8.png) Out is a single item rather than a smaller list with the latest per unique item. ---
**Author:** ![Jesse](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/jesse/32/88_2.png) [@Jesse](https://community.triggre.com/u/Jesse)\ **Post date:** [July 1, 2023, 8:02pm UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/4 "2023-07-01T20:02:20Z")
In that case I would just make a reference to the latest rating. Simply update it every time the user adds a new rating. I think that should work. ---
**Author:** ![isaac](https://avatars.discourse-cdn.com/v4/letter/i/8e8cbc/32.png) [@isaac](https://community.triggre.com/u/isaac)\ **Post date:** [July 1, 2023, 8:04pm UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/5 "2023-07-01T20:04:25Z")
Aaaah, yes. I have a sequence number therefore I can update it on the unique risk. Thank you! ---
**Author:** ![isaac](https://avatars.discourse-cdn.com/v4/letter/i/8e8cbc/32.png) [@isaac](https://community.triggre.com/u/isaac)\ **Post date:** [July 1, 2023, 8:32pm UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/6 "2023-07-01T20:32:22Z")
It worked! Yesssss. Thanks ![image](https://canada1.discourse-cdn.com/flex035/uploads/triggre/original/1X/0d5d189c7a431ba0caa6ec3e524a4c7504edafad.png) ---
**Author:** ![Ed1](https://avatars.discourse-cdn.com/v4/letter/e/958977/32.png) [@Ed1](https://community.triggre.com/u/Ed1)\ **Post date:** [July 7, 2023, 8:05am UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/7 "2023-07-07T08:05:50Z")
Hi Isaac, How did you build the graphics with the numbers in it? Regards, Ed ---
**Author:** ![Jesse](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/jesse/32/88_2.png) [@Jesse](https://community.triggre.com/u/Jesse)\ **Post date:** [July 7, 2023, 8:14am UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/8 "2023-07-07T08:14:19Z")
Hi @Ed1, I assume he used images. Alternatively, you can also use emojis, in for example a pick list. An easy way to find and copy emojis is [emojicopy.com](https://www.emojicopy.com/). This is also great for statuses. A good example is in My Triggre, where we use green and red circles to indicate the status of an application, subscription and DNS records for example. Hope this helps! ---
**Author:** ![isaac](https://avatars.discourse-cdn.com/v4/letter/i/8e8cbc/32.png) [@isaac](https://community.triggre.com/u/isaac)\ **Post date:** [July 7, 2023, 9:26am UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/9 "2023-07-07T09:26:28Z")
Correct. I had to create images for each possible scenario. It would be great if there was some form of **conditional formatting** available based on the properties of the data items. Any chance of this in the near future @Jesse? @Ed1 ---
**Author:** ![Jesse](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/jesse/32/88_2.png) [@Jesse](https://community.triggre.com/u/Jesse)\ **Post date:** [July 7, 2023, 11:09am UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/10 "2023-07-07T11:09:49Z")
Hi @isaac, We have some conditional formatting on our roadmap, though not on the short term. There are many pre-requisite requirements that have to be met first regarding the user interface before we can do this type of formatting. For now images or emojis will have to do. Pro-tip: the advantage of emojis is that you can also use them in menu items and buttons šŸ™‚ ---
**Author:** ![Ed1](https://avatars.discourse-cdn.com/v4/letter/e/958977/32.png) [@Ed1](https://community.triggre.com/u/Ed1)\ **Post date:** [July 7, 2023, 11:28am UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/11 "2023-07-07T11:28:45Z")
> [@Jesse](#): > > ume he used images. Thx, Thought so, because I did that also. ---
**Author:** ![Ed1](https://avatars.discourse-cdn.com/v4/letter/e/958977/32.png) [@Ed1](https://community.triggre.com/u/Ed1)\ **Post date:** [July 7, 2023, 12:32pm UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/12 "2023-07-07T12:32:54Z")
Hi Isaac, The performance with these images is quit bad. How is yours? I have made PNG images. regards, Ed ---
**Author:** ![isaac](https://avatars.discourse-cdn.com/v4/letter/i/8e8cbc/32.png) [@isaac](https://community.triggre.com/u/isaac)\ **Post date:** [July 7, 2023, 2:03pm UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/13 "2023-07-07T14:03:57Z")
The images have a delay loading. It reduced when I reduced their size. I want to try @Jesse idea of emojis because I believe those will load faster plus I can now use menus, buttons and pick lists ---
**Author:** ![Ed1](https://avatars.discourse-cdn.com/v4/letter/e/958977/32.png) [@Ed1](https://community.triggre.com/u/Ed1)\ **Post date:** [July 7, 2023, 6:48pm UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/14 "2023-07-07T18:48:02Z")
Hi Isaac, How many bytes are your images. Mine are about 3Kb a piece and some with text 21Kb. Regards, Ed ---
**Author:** ![isaac](https://avatars.discourse-cdn.com/v4/letter/i/8e8cbc/32.png) [@isaac](https://community.triggre.com/u/isaac)\ **Post date:** [July 8, 2023, 5:06am UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/15 "2023-07-08T05:06:59Z")
Hi @Ed1 they are 1KB. The emoji option is working perfectly now that I have used it as a replacement. Thanks @Jesse ---
**Author:** ![Ed1](https://avatars.discourse-cdn.com/v4/letter/e/958977/32.png) [@Ed1](https://community.triggre.com/u/Ed1)\ **Post date:** [July 8, 2023, 7:42am UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/16 "2023-07-08T07:42:07Z")
Hi Isaac, where can i find these emojis ---
**Author:** ![Jesse](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/jesse/32/88_2.png) [@Jesse](https://community.triggre.com/u/Jesse)\ **Post date:** [July 8, 2023, 7:45am UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/17 "2023-07-08T07:45:31Z")
> An easy way to find and copy emojis is [emojicopy.com](https://www.emojicopy.com/). ---
**Author:** ![Ed1](https://avatars.discourse-cdn.com/v4/letter/e/958977/32.png) [@Ed1](https://community.triggre.com/u/Ed1)\ **Post date:** [July 8, 2023, 7:58am UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/18 "2023-07-08T07:58:41Z")
And more important: can you adjust these with text or numbers? ---
**Author:** ![Jesse](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/jesse/32/88_2.png) [@Jesse](https://community.triggre.com/u/Jesse)\ **Post date:** [July 8, 2023, 8:10am UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/19 "2023-07-08T08:10:47Z")
You can use them in pick lists or concatenate them (paste together) with other texts. They are just text basically. Here is an example of how you could represent a percentage as 10 emojis (in this case, 30%): šŸŸ© šŸŸ© šŸŸ© ā¬œ ā¬œ ā¬œ ā¬œ ā¬œ ā¬œ ā¬œ For some inspiration; you could make a flow part that creates this, given an input number between 0 and 100. ---
**Author:** ![isaac](https://avatars.discourse-cdn.com/v4/letter/i/8e8cbc/32.png) [@isaac](https://community.triggre.com/u/isaac)\ **Post date:** [July 8, 2023, 8:29am UTC](https://community.triggre.com/t/show-the-latest-entry-only/431/20 "2023-07-08T08:29:28Z")
This is brilliant. I was wondering how to accomplish this for my progress tracking app [Next page](https://community.triggre.com/t/show-the-latest-entry-only/431.md?page=2)