Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Sorting by Linked record date

129 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.

image

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