Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Dynamic Dropdown Based on Dates

I am making an attendance App, I want to remove the names of the person whoโ€™s attendance has been done and I did that by (List of Employees[Emp Name] - Attendance[Emp Name]). When the date changes it still remove the names(Previous Date) which are present in Attendance Table.

Is there any way where the dropdown changes daily, where it checks whether the name is present in the table for today and if the name is there for todayโ€™s date then it removes the name from the dropdown for that date.

Solved Solved
0 3 215
1 ACCEPTED SOLUTION

I believe, you will need to use the SELECT() statement on the second part of the expression to qualify the employee attendance list for todayโ€™s date.

View solution in original post

3 REPLIES 3

I believe, you will need to use the SELECT() statement on the second part of the expression to qualify the employee attendance list for todayโ€™s date.

Do you mean like this
List of Employees[Emp Name] - SELECT(Attendance[Emp Name], [Date]=TODAY(), true)

Correct.

Top Labels in this Space