Finding out, which record is in which column?

Topic Labels: Formulas
960 4
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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
Bildschirmfoto 2022-04-19 um 08.31.03
Bildschirmfoto 2022-04-19 um 08.30.34
Bildschirmfoto 2022-04-19 um 08.44.50

4 Replies 4

Hi @Thomas_Giegerich and welcome to the community!

Have you taken a look at the Timeline view for this?

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.

Maybe the pivot table app might be what you’re looking for:

Thanks - I tryed some of the tutorials, but did not really get how that works.