Forum Discussion

JessicaAdkins's avatar
JessicaAdkins
Qrew Cadet
8 years ago

Is there any way to copy data from an Excel file and paste it in the Grid Edit report?

I am attempting to copy data from an Excel file and past it into the Grid Edit report. I know you can manually click each field and edit data in the grid edit, but I thought at one point, you could pa...
Grid edit
AdamKrzyzanek's avatar
AdamKrzyzanek
Qrew Captain
BTW - I issued this question with example to Google Chrome team.
Wondering if they replay anything :)
TateForgey's avatar
TateForgey
Qrew Assistant Captain
4 years ago
Just putting my +1 on this and bumping. 

I realize this is a browser issue and I realize this might not be in the category of main functionality, but I really need this right now.  The simple act of being able to copy and paste into a grid edit report will allow us to effectively integrate reports from disparate systems easily and efficiently.  Sadly, it is not easy because copy and paste is not consistent across browsers.  Any workaround is appreciated, but something akin to the paste special in Firefox integrated directly into Quick Base so that it works regardless of browsers would be ideal.

------------------------------
Tate Forgey
------------------------------
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    4 years ago
    Often-times, copy/pasting from Excel introduces hidden/special characters into your Quick Base, so there's that. Aside from this, I know it doesn't solve for every scenario, but is this spreadsheet something that you could setup to be used as the basis of a Sync table or an Import? Even if you import too much data into a dummy table and then have a way - whether manual or automated with Pipelines - to pull just the data you want into your actual records might be a solution.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • MartinSuske1's avatar
      MartinSuske1
      Qrew Member
      3 years ago
      Just came across that issue too and it seems to be a feature of the grid edit function to not allow external clipboard data to be inserted. I had no problems copying the same data into other QB fields.

      I cannot understand the restriction though. Seems quite common to insert data from other sources in a data grid. Validation could be implemented for special types.

      Giving every user the possibility to upload/merge data or build individual pipelines for that purpose would be worse for me.

      Edit:
      I just learned about the "Paste Special" function that can be called from the context menu of a cell in grid edit mode. I guess that'll solve my issue.
      ​

      ------------------------------
      Martin Suske
      ------------------------------