- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 27, 2023 05:42 AM
I am working with a subscription table and every row is an entry every time a customer subscribed to an account (It is possible for a customer to have more than 1 account). I have a field for Start Date and End Date, and I want to know the maximum account the customer had at some point, so I am thinking that if I would know which dates overlapped, I can then record it to a different table but is there any formula in airtable where I can do that?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 27, 2023 09:15 AM
Airtable formulas only have access to data in the single record, so formula fields cannot compare data across different records. Rollup fields can make limited calculations on a field value in linked records, but they also cannot provide the calculations that you want.
If you want to eyeball it for a single customer at a time, you could try using a timeline view grouped by customer, and then look for lots of records that have overlapping times. But I suspect this is not what you want.
You could calculate this with a custom script. I think a novice/beginner script writer would struggle with writing this script, but if you have experience writing scripts or know someone who can write scripts, that's the way to go.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 27, 2023 09:15 AM
Airtable formulas only have access to data in the single record, so formula fields cannot compare data across different records. Rollup fields can make limited calculations on a field value in linked records, but they also cannot provide the calculations that you want.
If you want to eyeball it for a single customer at a time, you could try using a timeline view grouped by customer, and then look for lots of records that have overlapping times. But I suspect this is not what you want.
You could calculate this with a custom script. I think a novice/beginner script writer would struggle with writing this script, but if you have experience writing scripts or know someone who can write scripts, that's the way to go.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 28, 2023 12:28 AM
I see,
I am a novice in terms of writing a script but I'll try to find a template and try to tweak it. Thank you!
