Discussions

Expand all | Collapse all

Populating Table With Existing Form Fields

  • 1.  Populating Table With Existing Form Fields

    Posted 05-18-2020 11:12
    Hello,

    I am attempting to export a table into a CSV file. However, the table only contains two fields when I actually need all of the fields displayed in the associated form shown in the table. The form contains the fields in a specific order that I would like replicated in the table form. The solution I've discovered is by going into "Customize This Report" > "Columns To Display". All of the columns I need to display are there, however, there are 300+ of them. I could do this one at a time, but this is obviously inefficient and makes room for of error. Furthermore, the fields are displayed in alphabetical order so I would need to search for the name of the field. The challenge is populating the table report with the fields from the forms report in the order shown in the form. What is an efficient way to do this?

    ------------------------------
    Kyle Prince
    ------------------------------


  • 2.  RE: Populating Table With Existing Form Fields

    Posted 05-18-2020 11:41
    You can highlight blocks of fields and drag them across,   But I can't think of a way to sequence them to match a form other than manually dragging them up and down.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Populating Table With Existing Form Fields

    Posted 05-18-2020 13:25
    Yeah, it appears that is the only way to do it. Thanks for the response.

    ------------------------------
    Kyle Prince
    ------------------------------



  • 4.  RE: Populating Table With Existing Form Fields

    Posted 05-19-2020 21:34
    Edited by Sam Jones 05-19-2020 21:34
    Kyle,
    The other way to do this would be through the API. It allows you create reports and specify the order of fields that appear by Field ID.

    That said, unless you're already pretty fluent in the Quick Base API, there's a substantial learning curve there.

    Or, you could hire a Quick Base Service Provider to do it for you, right @Mark Shnier (YQC)?

    Happy to help out more during Data Collaborative's free office hours, every Thursday at 1pm Eastern.
    Sign up here: https://data.quickbase.com/db/bqeqqj33i

    ------------------------------
    - Sam

    ______________________________________________
    Sam Jones
    Vice President, Product and Technology
    he/him

    The Data Collaborative, Inc.
    sjones@datacollaborative.com
    366 Massachusetts Ave, Suite 203 | Arlington, MA 02474
    ------------------------------



  • 5.  RE: Populating Table With Existing Form Fields

    Posted 05-22-2020 11:08
    Hey Sam,

    Thank you for the response. I managed to format the report as needed. However, the system is stating that the table is too large to export. So it appears I need to use the API, which would have killed two birds with one stone if used in the first place.

    I can learn how to use the API, have some experience with them. Could you suggest an efficient way to parse the XML returned into a spreadsheet?

    ------------------------------
    Kyle Prince
    ------------------------------