Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 15, 2021 08:17 AM
I have a bunch of table linked to different events. I want to create a view that filters out all future events except for the next one.
Anyway to do this without having to manually check and uncheck a box?
Jun 15, 2021 08:23 AM
Are your “events” date fields? If so, would simply filtering your dates like this work:
Jun 15, 2021 08:24 AM
They are but that is not the solution because that will show me all future not just the next date.
Jun 15, 2021 08:30 AM
If it is important to only show the next date (after tomorrow), then I don’t know. I don’t believe Airtable lets you limit views to only one row, though there may be some other way to achieve this. However, if the main concern is to see the next date, this will work:
The first row will always be the next date/time if you combine that filter with “Sort By > Date Field > 1-9”.
Jun 15, 2021 08:32 AM
Thanks but yeah that doesn’t solve it either. I have all that set up. I need a view for a form that just shows me the next date in the series. Seems like we should be able to filter a view and then set to say show X number of records Max. That would solve it.
If I can filter I don’t understand why I can’t just filter the number of rows to show.
Jun 15, 2021 08:34 AM
You can’t put a filter limiting the number of records because that is not a feature in Airtable, but yes, it should be a feature. In SQL, for example, you would type LIMIT X at the end of your query and it would only show the number of records you requested.
May I ask, do you have a Pro Account? There appears to be a solution that involves an app, but you need Airtable Pro to access it: Limit a view to a specific number of records
Jun 15, 2021 09:13 AM
Yah that doesn’t really help either. I need that selection on the filter!
Jun 15, 2021 07:32 PM
It’s not a view, but the Record List App will let you limit your list of records to just the next event.
Jun 15, 2021 09:03 PM
The only way to make calculations involving multiple records is to have linked record fields. It is theoretically possible to link all of the records to a single control record and then use a system of conditional roll ups and formula fields to determine the most recent future record. However, the system is rather complicated and does not scale well to large datasets.
Another option is to have a script that ensures that a checkbox is set for only the earliest future event. Then filter your view on the checkbox. The script could be run from a button or an automation, although finding the right trigger can be tricky.