Forum Discussion

Qrew Trainee

4 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 havin...

Data import and export

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

4 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
Qrew Trainee
4 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
  Qrew Legend
  4 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
  ------------------------------