Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula to check if a record exists on another filtered table

Topic Labels: Automations
719 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey guys,

I’m trying to develop an app to keep track of employees schedule (entrance and exit hour). With that, build an application to show the employes that are working and absent. I have two tables:

  1. The table were I have the information of the employees.
  2. The table of attendance, in this table a field is link to table 1.

My question is, can I make a formula that return TRUE if the worker is in table2 (which is filtered to only show the records that have the date of TODAY), and FALSE if it isn’t.

If you need any extra information about the tables, feel free to ask.

Thank You :slightly_smiling_face:

1 Reply 1

Hi @Luis_Pedro_Cuellar - yes you can do this. If you attendance table is something like this:

Screenshot 2020-11-14 at 16.50.30

Then you can get the max date from this table in the “people” table using a rollup:

Screenshot 2020-11-14 at 16.51.26

Then add a formula field to show TRUE or FALSE if the max date for each employee equals “today”

IF({Max Date Attended} = TODAY(), 'TRUE', 'FALSE')

You don’t need to filter the attendances table to achieve this - the rollup is doing the work for you.