Skip to main content
Solved

User Tracking Reporting

  • March 30, 2022
  • 5 replies
  • 98 views
Z
Forum|alt.badge.img+4

Hello,

I have multiple team members using our airtable system. We are all in the same database and I am looking to track productivity from the team based on records updated within a day. Is there anyway to pull a report or set something up so I can see who completed what per day, month, etc?

Example. Sally and John both work for Company ABC. Sally completes 5 tasks in the system and John completes 2. Currently the only way I know to see this is by clicking in the record making it not feasible to be able to view the productivity.

Thanks,

Best answer by ScottWorld

There are special field types for WHEN the record was last modified, and WHO last modified the record.

5 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • Answer
  • March 30, 2022

There are special field types for WHEN the record was last modified, and WHO last modified the record.

Z
Forum|alt.badge.img+4
  • Zak_Kennedy
  • Author
  • Participating Frequently
  • March 30, 2022

There are special field types for WHEN the record was last modified, and WHO last modified the record.


Thanks that is perfect!

Tom_Embaugh
Forum|alt.badge.img+3
  • Tom_Embaugh
  • Participating Frequently
  • January 3, 2023

There are special field types for WHEN the record was last modified, and WHO last modified the record.


Hey Scott,

Do you know if the Last Modified fields work for changes made via interface, or only when working in one of the Airtable editors? I have been told they do not work for changes made via interface.

G
Forum|alt.badge.img+1
  • Ghaith_H
  • New Participant
  • February 15, 2023

Hey Scott,

Do you know if the Last Modified fields work for changes made via interface, or only when working in one of the Airtable editors? I have been told they do not work for changes made via interface.


Hey! Yes, it does. However, I have discovered that those fields will not track the comments. Meaning if someone leaves a comment or replies to a comment, the Modified by and when fields will not be impacted. 

Tom_Embaugh
Forum|alt.badge.img+3
  • Tom_Embaugh
  • Participating Frequently
  • February 15, 2023

Hey! Yes, it does. However, I have discovered that those fields will not track the comments. Meaning if someone leaves a comment or replies to a comment, the Modified by and when fields will not be impacted. 


Thanks.

Terms & ConditionsAccessibility statement