Reordering fields (columns) in table

Question

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!

markshnier__you · Answer

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
------------------------------

hanaliu · Answer

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------------------------------

markshnier__you · Answer

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
------------------------------

hanaliu · Answer

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, stateI then want to add a new field called "customer ID" and this is the new order I want: date, customer ID, customer name, stateHow do I insert the new field "customer ID" in between "date" and "customer name"?------------------------------Hana Liu------------------------------

markshnier__you · Answer

You cannot do that and that concept is "foreign" to how Quickbase developers normally think.&nbsp; The fields can be listed in the order that you created them or alpha.&nbsp; 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.&nbsp; We just create the fields we need and get on with building functionality quickly.&nbsp; 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------------------------------

Forum Discussion

Reordering fields (columns) in table