Sorting by Linked record date

1843 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have related tables with clients and appointments. the appointments are dates that are selected via linked record in the client table. I need to be able to sort by date in the client table, but it is not working. I have tried to create a formula field with the related date being parsed but it still does not sort by that. Please help!

2 Replies 2
8 - Airtable Astronomer
8 - Airtable Astronomer

I’m not sure I’m following your description, but here’s my best attempt:

Client Table

  • Name
  • link to Appointment

Appointment Table

  • AppointmentID (autogenerated by formula)
  • Start Time (date field with time turned on)
  • back link to Client

From here, add to the Client table a Lookup field that pulls in the “Start Time” column from the linked Appointment record. Then you should be able to sort by that lookup column.


4 - Data Explorer
4 - Data Explorer

Thanks for posting this solution. I think it is working!!