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:
- The table were I have the information of the employees.
- 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.