Not saving most current report

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
We created a new tab titled "documents", here we have an excel spreadsheet that is updated monthly by various employees. Each take turns adding new data for the month. When we review at the end of the week it appears it's not saving the most currently saved report, because every month at least one of the employee's data is missing. Even when they verify no one is currently working on the report. It seems it's not saving the most recently saved, so when the next employee goes to make their changes, they are likely working on an order version, therefore missing 1-2 employee's updates by the end of the months reviews. Is there a way to avoid this? Is there a better way of having each employee update the same document without data saving issues? How does a url work on here, and can it help?
Photo of Diana Connolly

Diana Connolly

  • 90 Points 75 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Are they working on the "excel" report of the QuickBase report/records? 
Does the QB report have some type of filtering or sorting that hides the new additions?

Not sure what you mean by 'does a url work here?'

Just looking for some clarity of the issues.
Photo of Diana Connolly

Diana Connolly

  • 90 Points 75 badge 2x thumb
I have no idea what a URL does, I just saw it was an added section on here, I recently removed. I didn't know if that would apply some benefit to making sure each excel workbook was saved properly and each employee was working off the most current. Here is an image of the table with the link to the saved workbook.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,038 Points 50k badge 2x thumb
Chriming in here. I think they are successively posting new file attachments. I.e., Excel workbooks.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,038 Points 50k badge 2x thumb
Diana,
Have you considered moving the data off of rows of Excel entries and actually have those be individual QuickBase records.  That way everyone is always working off the latest information.

It is typically pretty easy to convert rows of excel data to be a QuickBase table.

From your description of the problem, it just sounds like confusion and timing issues of who is updating the excel sheet and that there are multiple staff thinking they have the most current version when they don't.

ie user A grabs the excel sheets and hangs onto it for a few days while they update it.  but meanwhile another user grabs a copy and updates the excel sheet.  That data will get lost when the first user posts their updated sheet.

One way to see that is that if you click on Revisions a button beside the file attachment on the record (not the report) , you can see at least the previous three versions (and you can set that higher), and you can see when each version was posted and by who.  Check that out and I think it will tell you that the file attachments are not being as rigorously controlled as you thought.