Skip to main content

I have two tables.



Table 1: Client


Table 2: Appointments



Each appointment is tied to a client. I’m looking to see how many days from the client’s last appointment.



E.g. the client’s has 3 appointments however his last appointment was 1/1/2020 then the cell would display ‘14’ since that was 14 days ago.



Any ideas?

Edit: Nevermind - what you’re requesting is possible via roll-up fields.



Clients


Names (single line text)


Aaron Schiff



Appointments (linked records)


11/14/00,11/13/00,11/14/01,11/12/02



Last Appointment (roll-up)


11/12/02


Settings: Sort by 'max' on date field in Appointments



Time Since Last Appointment (formula)


6272


DATETIME_DIFF( TODAY(), {Date}, 'days' )



Appointments


Date (date field)


11/14/00


11/13/00


11/14/01


11/12/02


Edit: Nevermind - what you’re requesting is possible via roll-up fields.



Clients


Names (single line text)


Aaron Schiff



Appointments (linked records)


11/14/00,11/13/00,11/14/01,11/12/02



Last Appointment (roll-up)


11/12/02


Settings: Sort by 'max' on date field in Appointments



Time Since Last Appointment (formula)


6272


DATETIME_DIFF( TODAY(), {Date}, 'days' )



Appointments


Date (date field)


11/14/00


11/13/00


11/14/01


11/12/02




Awesome, works great, thanks!


Reply