Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
5 years ago

Get Table Structure Data

Is there a quick way to get the field names and types for a table?  I have two large tables and need to compare the fields in both to see which ones need to be updated. ----------------------------...
App builders
Ask about Quickbase functionality
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Not tested but did you try copy paste into excel off the field list screen?

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

    I was hoping for a nice way to get the names and field types.  I have been doing something similar, created a report in both tables with all fields, selected 1 record so I could export the data, copied the header and used paste transpose to put each in their own column and wrote a formula to compare 1 column to the other.  Not pretty, but it will give me a good idea of what updates need to be made.

    This entire exercise would be a moot point if quickbase would use some from of version control.



    ------------------------------
    Paul Peterson
    ------------------------------