# Approval Tiles **URL:** \ **Category:** Get Answers\ **Created:** [October 26, 2021, 9:46am UTC](https://forums.knack.com/t/approval-tiles/11426 "2021-10-26T09:46:50Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Luke1](https://avatars.discourse-cdn.com/v4/letter/l/4bbf92/32.png) [@Luke1](https://forums.knack.com/u/Luke1)\ **Post date:** [October 26, 2021, 9:46am UTC](https://forums.knack.com/t/approval-tiles/11426/1 "2021-10-26T09:46:51Z")
Hi all, Wondering if anyone else has a solution to this problem. We have various objects that have an approval process. Some of these are a few screen into the menu (e.g., Customer \> Vehicles \> Individual Vehicle). We do send an approval request to our internal team, but so nothing gets missed, I’d like a way to present how many records there are of particular objects with a status of Pending Approval. Since these records can be from multiple objects (e.g., Customers, Vehicles, Services, etc.) tables look messy as some tables are just blank. Is there someway to have a simple tile or card that shows the number of records that satisfy the criteria without making the page too busy? ---
**Author:** ![Arjun](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/arjun/32/4149_2.png) [@Arjun](https://forums.knack.com/u/Arjun)\ **Post date:** [October 26, 2021, 12:30pm UTC](https://forums.knack.com/t/approval-tiles/11426/2 "2021-10-26T12:30:23Z")
Would a floating window like the one I’ve attached make sense? You can write a JS function to query the necessary views and display the information if it’s present…! [Screenshot from 2021-10-26 17-58-56|406x252](https://forums.knack.com/uploads/short-url/dNEE7oab97eioQot1Jk5VWhLRpk.png) ---
**Author:** ![NancyM](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/nancym/32/1120_2.png) [@NancyM](https://forums.knack.com/u/NancyM)\ **Post date:** [October 26, 2021, 5:17pm UTC](https://forums.knack.com/t/approval-tiles/11426/3 "2021-10-26T17:17:30Z")
Hi, Have you thought about using the pivot table in the report section of add view. In the pivot Calculations use The total record count ![image 1](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/8/8d38bbc79b42d5b87ac5d99329b8b966cb107be9.gif) then you can add your criteria for the calculation. In your case you can choose if the status is pending approval. If you have more than one table, you can add more than one pivot table. ![image 2](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/b/b09a0b994fcfee8640b0c9d11a4398d1436eda54.gif) Then you can check exclude the empty group in the options sections. ---
**Author:** ![Sunny\_Singla](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/sunny_singla/32/1007_2.png) [@Sunny\_Singla](https://forums.knack.com/u/Sunny_Singla)\ **Post date:** [October 26, 2021, 5:26pm UTC](https://forums.knack.com/t/approval-tiles/11426/4 "2021-10-26T17:26:39Z")
Hi Luke, Yes, this is possible using some formula fields. and one extra object. With some javascript and css to show count in card like below ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/5/5f054d6c3b095c12ce99e5ba4e069247c921cc51.jpeg) Regards, Sunny Singla [ssingla1985@gmail.com](mailto:ssingla1985@gmail.com) +919855089359 [https://sandt-consultancyservices.com](https://sandt-consultancyservices.com) ---
**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\ **Post date:** [October 26, 2021, 9:19pm UTC](https://forums.knack.com/t/approval-tiles/11426/5 "2021-10-26T21:19:06Z")
I’m assuming my college @JulianKirkness wont mind me referencing his article for cards. > **[Creating Dashboard 'Cards' in Knack](https://www.onlinedatabase.expert/post/creating-dashboard-cards-in-knack)** > > Those of you who have been looking at alternatives to Knack often cite the ability to create 'cards' on their dashboards and other pages. For those who don't know what I mean by cards, this is what we're going to create: In this case the numbers... ---
**Author:** ![JulianKirkness](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/juliankirkness/32/770_2.png) [@JulianKirkness](https://forums.knack.com/u/JulianKirkness)\ **Post date:** [October 27, 2021, 8:18am UTC](https://forums.knack.com/t/approval-tiles/11426/6 "2021-10-27T08:18:40Z")
@CarlHolmes - thanks for the signpost! ---
**Author:** ![DeanBozzan62116](https://avatars.discourse-cdn.com/v4/letter/d/ad7895/32.png) [@DeanBozzan62116](https://forums.knack.com/u/DeanBozzan62116)\ **Post date:** [October 27, 2021, 11:37pm UTC](https://forums.knack.com/t/approval-tiles/11426/7 "2021-10-27T23:37:39Z")
The Dashboard Cards referenced above works well ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/e/e9c02d1bb431b8106942fe7247f2c996e3b88ff2.png) ---
**Author:** ![Luke1](https://avatars.discourse-cdn.com/v4/letter/l/4bbf92/32.png) [@Luke1](https://forums.knack.com/u/Luke1)\ **Post date:** [October 28, 2021, 5:46am UTC](https://forums.knack.com/t/approval-tiles/11426/8 "2021-10-28T05:46:36Z")
Thanks all. I’ll be looking to test some of these over the weekend. Have a great week all, and thanks for the contribution. 😀 ---
**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\ **Post date:** [October 28, 2021, 8:56pm UTC](https://forums.knack.com/t/approval-tiles/11426/9 "2021-10-28T20:56:43Z")
Nice dashboard cards @DeanBozzan62116 👍 ---
**Author:** ![Luke1](https://avatars.discourse-cdn.com/v4/letter/l/4bbf92/32.png) [@Luke1](https://forums.knack.com/u/Luke1)\ **Post date:** [November 2, 2021, 9:07pm UTC](https://forums.knack.com/t/approval-tiles/11426/10 "2021-11-02T21:07:18Z")
Hi Julian, When you created the text formula, did you create a new object and link that object to the other records, or did you just add the text formula to the original object? Thanks for the help all. Luke ---
**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\ **Post date:** [November 2, 2021, 9:48pm UTC](https://forums.knack.com/t/approval-tiles/11426/11 "2021-11-02T21:48:46Z")
Hi @Luke1 - the text formula is in the original object ✅ ---
**Author:** ![JulianKirkness](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/juliankirkness/32/770_2.png) [@JulianKirkness](https://forums.knack.com/u/JulianKirkness)\ **Post date:** [November 2, 2021, 9:57pm UTC](https://forums.knack.com/t/approval-tiles/11426/12 "2021-11-02T21:57:29Z")
As @CarlHolmes said! ---
**Author:** ![Luke1](https://avatars.discourse-cdn.com/v4/letter/l/4bbf92/32.png) [@Luke1](https://forums.knack.com/u/Luke1)\ **Post date:** [November 3, 2021, 12:02am UTC](https://forums.knack.com/t/approval-tiles/11426/13 "2021-11-03T00:02:15Z")
Sorry Carl and Julian, I don’t understand where to count the fields though. I want to create a count of filtered data (which I can do from a connected object), but not from the original object itself. If I try to add a count field (which I was then going to reference in the text formula field) to the same object, it doesn’t let me count itself. Thanks ---
**Author:** ![NancyM](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/nancym/32/1120_2.png) [@NancyM](https://forums.knack.com/u/NancyM)\ **Post date:** [November 3, 2021, 2:32pm UTC](https://forums.knack.com/t/approval-tiles/11426/14 "2021-11-03T14:32:12Z")
Hi, in your table your create a new field type Sum ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/9/9a38299a0fbb6374f7a749e5b222456b32441126.png) at the bottom of the new field you can choose your formula filtered ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/c/c10b87866f79519ae1fc2e0fd9b05e32ef7c75ee.png) ---
**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\ **Post date:** [November 4, 2021, 6:25am UTC](https://forums.knack.com/t/approval-tiles/11426/15 "2021-11-04T06:25:41Z")
@Luke1 - as you stated, you can’t sum records in its own table. It’s always a sum of related (connected) line items. You may need to create another connected table just to use for summing the values for your cards.