Hey there,

i am super new to Airtable but already love it. I am trying to write a little overview tool for our employees and gotten to a point where I could not find answers in tutorials.

I have setup a example database to explain what I am trying to do. I guess it is pretty easy and I just don’t know where to look.

i have one table with all the emplyoes in it. And I have another table with dates and 3 locations. I can now easily assign one employee to a location per day.

What I am trying to achieve is a table, where I would have a overview “the other way around”. Where Names of the employees are in the rows (line in the “Personal” table) and dates are in the colums. With this would like to see, who is where on which day. Is that possible?

I have setup a mockup in photoshop to explain what I am trying to do. Hope someone can give me a short guise on what to do.

Thanks in advance, Thomas