Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Formula to check entries for the same date

Topic Labels: Formulas
Solved
Jump to Solution
1559 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Adrian_Raszkie1
4 - Data Explorer
4 - Data Explorer

Hello Everyone!

Would greatly appreciate any help on this matter.

I have a base with two rows: people can enter their name and a date.

Is there a formula I can use in the third row which would check how many entries are recorded for the same date, and could show a message along the line of: “Too late, there are already 8 entries with this date”.

Thank You!

1 Solution

Accepted Solutions

Not currently. Airtable forms are pretty bare-bones in terms of logic features, and they don’t check the existing data in the table when a user is filling out the form.

To apply the solution that @Kamille_Parks suggested, create a new [Dates] table, with each record’s primary field containing a unique date. Back in your main table, turn the {Date} field into a link field where users can pick an entry from the [Dates] table, making sure to turn off the “Allow linking to multiple records” feature to prevent multiple dates from being picked.

Back in the [Dates] table, you’ll see that there’s a new link field there as well. That’s the “other side” of the link coming from your main table. To count how many links each date record has, add a count field and name it something like {Responses}.

On that same table, create a new view named something like “Open Dates”, and add a filter to only show records where Responses < 8. That will automatically hide any date records that have eight responses.

In the form view that you made on your main table, edit the properties of the link field to only select records from that “Open Dates” view. Once a date has eight responses, it won’t appear as an option for anyone responding after that.

See Solution in Thread

3 Replies 3

I’m going to assume you mean “columns” or “fields”, not “rows”.

If you had a table of [Dates] and use a Link to another record-type field linking to that table instead of using a date field, you would be able to prevent new records from linking to a date that already has 8 linked records.

Thank You for the response!

Yes, silly mistake, I meant rows.

Do you perhaps have any examples of what you mean? I am a beginner still, not exactly sure what you are referring to.

So it there currently no way to simply limit the number of new entries that can be added given a single cell value? (i.e. too many entries with ta particular value entered)

Not currently. Airtable forms are pretty bare-bones in terms of logic features, and they don’t check the existing data in the table when a user is filling out the form.

To apply the solution that @Kamille_Parks suggested, create a new [Dates] table, with each record’s primary field containing a unique date. Back in your main table, turn the {Date} field into a link field where users can pick an entry from the [Dates] table, making sure to turn off the “Allow linking to multiple records” feature to prevent multiple dates from being picked.

Back in the [Dates] table, you’ll see that there’s a new link field there as well. That’s the “other side” of the link coming from your main table. To count how many links each date record has, add a count field and name it something like {Responses}.

On that same table, create a new view named something like “Open Dates”, and add a filter to only show records where Responses < 8. That will automatically hide any date records that have eight responses.

In the form view that you made on your main table, edit the properties of the link field to only select records from that “Open Dates” view. Once a date has eight responses, it won’t appear as an option for anyone responding after that.