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
Does anybody find solution in Chrome to paste in Grid Edit?
Maybe there is a need to turn-on some chrome://flags which would allow such functionality?
AdamKrzyzanek's avatar
AdamKrzyzanek
Qrew Captain
6 years ago
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
        ------------------------------