Thanks for all your help here, but this does not address the issue.
I do not want to control the order of the columns.
They already appear in the correct order.
Each table that I am referring to has the exact same column structure, and should display in the same order, which they both do already in AppSheet, in the detail view.
So I don’t have to set any manual order, since they are already showing up in the correct order, in the detail view.
What I want to do is control which column appears in the MAIN VIEW of each table.
I attached screenshots to my original post (see below).
2 columns show up in the Main Table View for each table.
Chart 10s shows column A (2 SETS OF 10 REPS) and column B (Incr.) from the Google Sheets table.
Chart 5s shows column A (2 SETS OF 5 REPS) and COLUMN I (5 MAX).
I never set any setting or sort order for these to show up in the MAIN TABLE VIEW in AppSheet.
BUT THEY SHOULD BOTH SHOW COLUMN A AND COLUMN I for each respective Google Sheets table.
HOW DO I SET THIS?
How do I get Chart 10s Table View to display Column A (2 SETS OF 10 REPS) AND Column I (10 MAX)?
MAIN TABLE VIEW OF “CHART 10s”:
(This should be Column I “10 MAX” on the right hand side, not “Incr.” which is Column B in the spreadsheet… just like the Chart 5s, below, is “5 MAX” on the right side, which is Column I in its corresponding spreadsheet.)
MAIN TABLE VIEW OF “CHART 5s”: