Record date and person who last attached a file to a sheet

Meredith Rhodes

I love data shuttle - and have built so many of them into my systems, both automated data shuttles and integrating data on attachment.

We are a team of 2 people managing a common database, we have divided our tasks up into weekly and monthly tasks. We swap who is responsible for these tasks on a monthly basis to shake things up a bit.

Our weekly tasks are currently organized into a to-do list that gets updated when one of us attaches a file to the sheet (see below). At present, I have the contents of the file completely replacing all rows on the sheet with new rows from the file (then, they get moved to another sheet that we report off of).

I am trying to record the name of the person who attached the last file as they are responsible for those particular tasks (see that Celia attached the last file below). The problem is, I am the sheet owner and the person who set up the data shuttle - every time my colleague attaches a file, it looks like I have made the last updates to the sheet. I can see her name in the Attachments panel - and what time she attached the file. But at present there is no way to get that information into rows / columns on the sheet.

This would be so helpful for a number of reasons, including tracking how current the data is (when the file was last attached to the sheet) - and enable us to automatically parse our reports/to-do list to specific users.

Thanks for considering this feature.

Meredith