Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Display of the last/ newest entry

Topic Labels: Base design
284 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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,
Chris

Thanks for the tip. It worked. :winking_face: