Forum Discussion

HannahDrake's avatar
HannahDrake
Qrew Trainee
3 years ago

Is there an import log or history anyway? Or is it creatable?

Hi, we need to track / view the import history on one of our apps - ideally, name of import (filename), table it was imported to, and by who/when.

I would think this MUST exist somewhere, but having trouble finding it. Does it exist? If so, where? If not, how would I create it?

------------------------------
Hannah Drake
------------------------------
Data import and export

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    My suggestion would be to do the imports using a Connected Sync table. Then you could look back on the file path of where the files are uploaded and you would have the history there.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • HannahDrake's avatar
      HannahDrake
      Qrew Trainee
      3 years ago
      Thanks Mark, was looking at Connected Tables documentation and it appears they are read-only once in QB? We would need them to be editable.

      ------------------------------
      Hannah Drake
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        3 years ago

        The fields which are connected are read only. But you can also have formula fields and manual fields. 


        You can also set up a scheme where data is imported to a connected table and then copied to an editable table. Then all fields would be editable. 

        A process could be set up to only copy new records to the editable table so that the edits don't get overwritten back to their original values  



        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------