Forum Discussion

_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
Here is the code to log the fid and field name to the console as a table display and as CSV:

console.table(_.map(gTableInfo[gReqDBID].finfo, (field, fid) => {    return [fid, field.name];  }));      console.log(_.reduce(gTableInfo[gReqDBID].finfo, (memo, field, fid) => {    return memo + '${fid},${field.name}\n';  }, "" ));



Notes: 

(1) This code uses widely supported ES6 features:
  • backticks for string interpolation
  • fat arrow functions (ie =>)
I will increasingly use more ES6 features in my answers and demos and drop using jQuery. Ask if you need more information to make sense of the code.

(2) underscorejs is used to map gTableInfo[gReqDBID].finfo into an array of arrays in the first instance and to reduce gTableInfo[gReqDBID].finfo to a CSV string in the second.
TonyScott's avatar
TonyScott
Qrew Trainee
5 years ago
Late reply to an old thread, but how hard would it be for QB to put an export function here instead of worrying about changing reports and other features that make no meaningful difference?  This seems like a basis admin feature that is (still 4 years later) completely missed by QB.

------------------------------
Tony Tony
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    There is not a download button, but I was able to copy and paste the field list  from the Quickbase page into Excel.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • TonyScott's avatar
      TonyScott
      Qrew Trainee
      5 years ago
      Mark:

      Yes, I was able to do a copy/paste as well, and then mess with the data in Excel.  A little "export list" feature would be nice, and I don't think asking too much from QB.

      Thank you!

      Tony

      ------------------------------
      Tony Tony
      ------------------------------
      • JustinTorrence's avatar
        JustinTorrence
        Qrew Cadet
        5 years ago

        @Tony Scott

        Hey all!

        I created a utility using Tampermonkey that puts a button on the page that will download a CSV of all of the field info for the fields that are currently being displayed. Here's a link to the GitHub project with this and other admin utilities, follow the readme to install the QuickbaseFieldExport UserScript. It uses jQuery to capture all of the field information, so it will probably break easily, but oh well.

        Here's a gif of it in action:


        Let me know what you think.
        ​



        ------------------------------
        Justin Torrence
        Quickbase Expert, Jaybird Technologies
        jtorrence@jaybirdtechnologies.com
        https://www.jaybirdtechnologies.com/#community-post
        ------------------------------