Re: Display of the last/ newest entry

782 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there,

I hope this is the correct section for my question.

I have a database with 3 tables.
Once a table for vehicles. A table for drivers.
And thirdly, a table in which I enter the date on which a new driver enters a vehicle - or a vehicle is turned off / parked.

Now I would like to always have the name of the driver displayed in the Vehicles table, who took over the vehicle last (seen back from $today) - or it should be displayed that the vehicle is turned off / parked. In both cases, the date of the last vehicle pick-up / the last time the vehicle was parked should be displayed.

Can someone help me to realize this?

Many Thanks !!
01 Fahrer
02 Fahrzeuge
03 Fahrerwechsel

2 Replies 2
7 - App Architect
7 - App Architect

Hi @KevinDax,

Welcome to the community!

It looks like you record a date on the third table and you could use that date to sort or filter by. You could also use the “Created time” or “Last modified time” field types. These auto populate, either when the record was created for “Created time” or when its updated for “Last modified time”. These fields format as dates that you could sort and filter by.


Thanks for the tip. It worked. :winking_face: