Skip to main content
Question

Not saving most current report

  • May 4, 2017
  • 0 replies
  • 29 views
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?
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • May 4, 2017
      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.
      Chriming in here. I think they are successively posting new file attachments. I.e., Excel workbooks.
      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.
      Terms & ConditionsAccessibility statement