I have three tables.
One has business information.
One has Employee information.
One has information about the workshops the business have signed up for.
I want to create a table that tracks employee attendance for all workshops at all businesses. All employees attend all the workshops the businesses sign up for.
I don’t know how to do this without a left table join. It seems like it should be simple, but it is not.
+31Let’s assume your data looks like this:
We then have two ways to potentially handle this:
For this we create a new linked field to Employees in the ‘Workshops’ table and populate it to indicate that they’ve attended. In the gif below, Workshop 1 has full attendance while Workshop 2 had no attendees
You’ll also notice that only the Employees linked to that Business are available for selection, and that’s done via a conditional in the linked field:
For this, we set up a new table called ‘Attendance’ that’s linked to ‘Employees’ and ‘Workshops’ where each record represents the attendance of a single
This then lets us add additional fields to note details per attendance, like so:
And I’ve set it up here for you to check out!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
