Skip to main content

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 !!





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

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:

Reply


Terms & Conditions