New to Airtable and appreciate any feedback on my use case!
Employees at my 500 person company are currently filling out daily timesheets and emailing them to HR in an excel template (yes, that means 500 xlsx files per day…)
I want to use Airtable instead, and build out the timesheet template as a form that each employee submits once per day.
I’ve built out a skeleton, but am struggling with an issue:
-
On the form, employee needs to choose their department from a single select
-
Employee then needs to choose their main task from another single select. But I want the available options to only display tasks within their department.
I guess what I’m looking for here is some sort of conditional logic that filters tasks to their department only. But I dont think Airtable offers that natively (I’ll happily be proven wrong!)
How else could I accomplish this?
thanks! :slightly_smiling_face:
