Apr 18, 2022 11:37 PM
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
Apr 19, 2022 05:39 AM
Hi @Thomas_Giegerich and welcome to the community!
Have you taken a look at the Timeline view for this?
Apr 19, 2022 10:46 AM
As I only have a basic account, I was not able to try that. But it does not really look like, what I am looking for.
Apr 19, 2022 11:42 AM
Maybe the pivot table app might be what you’re looking for:
Apr 22, 2022 11:58 AM
Thanks - I tryed some of the tutorials, but did not really get how that works.