Discussions

 View Only
  • 1.  Reordering fields (columns) in table

    Posted 07-19-2022 14:07
    Hi! Is there a way to reorder fields (columns) in a table? I've seen the drag and move feature (dragging a column and moving it to the right spot) but somehow it doesn't work on my end....I tried changing the order of fields in the form but then the new order only shows in the form and not in the table. Right now I've just been deleting fields and re-entering them in the right order, please tell me there is another way!! Thank you!


  • 2.  RE: Reordering fields (columns) in table

    Posted 07-19-2022 14:08
    Are you referring to the list of fields in the admin settings for the table, or the fields on a table report?

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Reordering fields (columns) in table

    Posted 07-19-2022 14:11
    I believe I'm referring to the fields in the admin settings for the table...I haven't created any table reports yet...

    ------------------------------
    Hana Liu
    ------------------------------



  • 4.  RE: Reordering fields (columns) in table

    Posted 07-19-2022 14:16
    If you want fields to sort together alphabetically then use the naming convention that has a prefix to get them in the sequence that you want.  You would never ever delete fields and re-create them just to get to them to appear in the correct sequence.  

    Click the field name column heading to get them to sort alpha.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Reordering fields (columns) in table

    Posted 07-19-2022 14:19
    I don't want to sort the field name alphabetically though.

    Say I have created a table with fields in this order: date, customer name, state
    I then want to add a new field called "customer ID" and this is the new order I want: date, customer ID, customer name, state

    How do I insert the new field "customer ID" in between "date" and "customer name"?


    ------------------------------
    Hana Liu
    ------------------------------



  • 6.  RE: Reordering fields (columns) in table

    Posted 07-19-2022 14:36
    You cannot do that and that concept is "foreign" to how Quickbase developers normally think.  The fields can be listed in the order that you created them or alpha.  Don't worry about the sequence. Just create the fields you need and get onto creating forms and reports and functionality of the app.

    There are many apps out there with hundreds of fields.  We just create the fields we need and get on with building functionality quickly.  To find a field on the list we sort alpha and scan or use the filter box or reverse sort by field ID# (click twice) to get the newly created fields at the top.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Reordering fields (columns) in table

    Posted 07-19-2022 14:46
    I see! So if I want to present them in a certain order, do I create a report and reorder it there?

    ------------------------------
    Hana Liu
    ------------------------------



  • 8.  RE: Reordering fields (columns) in table

    Posted 07-19-2022 14:59
    When  you start building your first basic "Table" Reports, you will see that you will select your fields, and their sequence (column sequence), the sort and grouping levels, and the filters.   A Table Report is just a list of records.  There are also many other report types like Charts and Summary report, but you can explore those later.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------