I am trying to do two things in a response table for a form. First, i would like to know if I am able to use a function to auto convert the populated text to either proper or upper case as needed. Second, is there a way to rearrange the column order in the response table?
You can use the "UPPER" formula from http://helpx.adobe.com/acrobat-com/formscentral/help/formula-syntax-built-in-functions.htm l
I think you'd insert/add a new column adjacent the one you want to convert, let's say you want to convert the responses in column "J" so you insert a colulmn to the right "K", in cell "K1" you'd put "=UPPER(J1)" and when you hit "Enter" column K would be populated with the data from the cells in column J in all caps. You could then hide column J to keep the form cleaner and all new responses would be reflected in all caps in the new column K.
A video on using formulas: http://tv.adobe.com/watch/acrobat-xi-tips-tricks/how-to-work-with-formulas-in-formscentral /
On your other question, you can re-arrange the columns by dragging and dropping them where you want them, click/drag on the column header at the top of the column to drag or select multiple columns and then click/drag.