
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 14, 2020 11:17 AM
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?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 14, 2020 08:10 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 14, 2020 08:10 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 15, 2020 09:11 AM
Awesome, works great, thanks!
