# Display 'last updated' **URL:** \ **Category:** Ask Developers\ **Created:** [May 29, 2025, 5:41pm UTC](https://forums.knack.com/t/display-last-updated/19396 "2025-05-29T17:41:04Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![andrew.uk](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/andrew.uk/32/2130_2.png) [@andrew.uk](https://forums.knack.com/u/andrew.uk)\ **Post date:** [May 29, 2025, 5:41pm UTC](https://forums.knack.com/t/display-last-updated/19396/1 "2025-05-29T17:41:05Z")
Hi, I have a public defibrilator database, and within this is a table for when defibs are inspected. I would like to be able to display in a text field or similar, “last inspection 26th May 2025” - and it to get that data from the date filed on the most recent entry in the inspection table… or total inspections “total records in table”. Having to use Grids all the time for displaying simple stats / data such as this makes the page look so web 1.0 any thoughts? thanks ---
**Author:** ![NickKnack](https://avatars.discourse-cdn.com/v4/letter/n/73ab20/32.png) [@NickKnack](https://forums.knack.com/u/NickKnack)\ **Post date:** [May 29, 2025, 7:17pm UTC](https://forums.knack.com/t/display-last-updated/19396/2 "2025-05-29T19:17:30Z")
Hi Andrew, If I understand your problem correctly, this should be relatively straightforward. Add a date field to your table called “Last Inspected” ensure that it is set to Default Date “None” and Default Time “None” You will need a form that updates the data in that table - I presume that you collect data when a defib is inspected such as who inspected it etc ? On the Form go into Actions & Rules and chose Record Actions, add a rule to either update this record or update connected records (depending on how you have structured the data). From here you can have a submission rule that updates the “Last Inspected” field to “the current date” I hope this makes sense. ---
**Author:** ![andrew.uk](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/andrew.uk/32/2130_2.png) [@andrew.uk](https://forums.knack.com/u/andrew.uk)\ **Post date:** [May 29, 2025, 7:58pm UTC](https://forums.knack.com/t/display-last-updated/19396/3 "2025-05-29T19:58:23Z")
Hi Nick, Thanks for your note - so the records are all fine etc - I want to be able to enter into a text area or header etc - "Last update: ( $$ most recent value from [inspected on field] in table called [inspection log] $$ ) if you look at site - [Knack](https://cidata.knack.com/defibjersey) I have a pivot table showing inspections - but underneath - and maybe elsewhere say “last inspection 29th May 2025” I know I could do with with a grid etc - but it just looks so clunky. cheers ---
**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:** [May 29, 2025, 8:45pm UTC](https://forums.knack.com/t/display-last-updated/19396/4 "2025-05-29T20:45:10Z")
It’s been a long day and I’m almost asleep on the sofa so I may not be reading the thread correctly. Personally, I often struggle trying to visualise someone else’s setup from a text description. On the detail page for a specific defibrillator, add a list view of the connected inspections - Set the list to sort by the inspection date in descending order (most recent first). - Limit the list to just 1 record so only the latest inspection shows up. If you’d like to connect to chat it through I’d be able to find some time to help, if I can. 😎 ---
**Author:** ![Dean2](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@Dean2](https://forums.knack.com/u/Dean2)\ **Post date:** [May 29, 2025, 10:39pm UTC](https://forums.knack.com/t/display-last-updated/19396/5 "2025-05-29T22:39:05Z")
Hi Andrew I agree with Nick & Carl and hopefully these screenshots which show you how we record our asset maintenance will help. ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/f/f0060eab57a8a5b0ce54d242fcb11bee1c28635b.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/0/033d97dfb9bcf3057b327fe0ee906c5750ade2b4.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/6/68e878f392a36e77918fbcdd1a55743b54204f32.png) You’ll want to write the Inspection Date to the Asset record, where we write the upcoming Expiry/Maintenance Date, using Record Rules. ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/1/1e5f5a1f1485551fd35bd010bb7f35afaa56e0ae.png) Dean ---
**Author:** ![LeighBerre96926](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/leighberre96926/32/4896_2.png) [@LeighBerre96926](https://forums.knack.com/u/LeighBerre96926)\ **Post date:** [May 29, 2025, 10:54pm UTC](https://forums.knack.com/t/display-last-updated/19396/6 "2025-05-29T22:54:54Z")
Use a 1 line grid and then use css to remodel the ook so you are left with something pleasing. ---
**Author:** ![andrew.uk](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/andrew.uk/32/2130_2.png) [@andrew.uk](https://forums.knack.com/u/andrew.uk)\ **Post date:** [May 29, 2025, 11:47pm UTC](https://forums.knack.com/t/display-last-updated/19396/7 "2025-05-29T23:47:11Z")
Sorry if I wasnt clear… I have a text formula which shows the date of an inspection ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/5/5d534efe0536090b74aef07228871a1a165405f9.png) I was trying to find out of there is a way of inserting a single field from a table without having to use a grid… ie inline html… rather than having to use a grid to just show the single record. I know I can use CSS etc but I’m trying to break away for a very old school look with blocks of text (html) being separate from blocks of grids. I’m guessing not… I was hoping you could use code etc to call essentially a sql command that selects field from table etc. chess for your help - sorry I went clear enough. I knew what I meant lol! ---
**Author:** ![Nick](https://avatars.discourse-cdn.com/v4/letter/n/f9ae1b/32.png) [@Nick](https://forums.knack.com/u/Nick)\ **Post date:** [June 3, 2025, 2:37pm UTC](https://forums.knack.com/t/display-last-updated/19396/8 "2025-06-03T14:37:31Z")
@andrew.uk you can use the max function to find the latest date of a record entered. I use it a lot. [How do I find the most recent date from a connected table?](https://learn.knack.com/article/23ugh4sa6t-how-do-i-find-the-most-recent-date-from-a-connected-object) Hope this helps.