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
Nov 13, 2020 07:48 AM
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:
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:
Nov 14, 2020 08:53 AM
Hi @Luis_Pedro_Cuellar - yes you can do this. If you attendance table is something like this:
Then you can get the max date from this table in the “people” table using a rollup:
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.