I’m setting up Airtable for our fleet of drivers and want to do a call log for our Monitoring and Quality team. The table consists of a ‘Call Log’ tab for our outgoing calls and a ‘Drivers’ tab for the driver information.
Three things I’m trying to accomplish:
First, In the ‘Drivers’ tab, I have two columns ‘Name’ & ‘ID’. In my ‘Call Log’ tab, I would like when I fill out the ‘Driver Name’ it automatically inputs the ‘ID’
Secondly, when I click on the Driver Name and the cell expands I would like the history (entries and calls) made to that driver to be moved at the top. Is this possible?
And thirdly, the last column in the ‘Call Log’ tab is the cell called ‘Last Contact’. I would like it to automatically display the last time a ‘Driver’ was associated with a row.
Thank you all in advance