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
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.
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
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
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
If you’d like to connect to chat it through I’d be able to find some time to help, if I can. 
Hi Andrew
I agree with Nick & Carl and hopefully these screenshots which show you how we record our asset maintenance will help.
You’ll want to write the Inspection Date to the Asset record, where we write the upcoming Expiry/Maintenance Date, using Record Rules.
Dean
Use a 1 line grid and then use css to remodel the ook so you are left with something pleasing.
Sorry if I wasnt clear…
I have a text formula which shows the date of an inspection
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!
@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?
Hope this helps.
