Submitted by WayneK on 2019/10/06 17:25
Is there a way to designate where columns are added?  If yes, ignore this suggestion.
 
Columns are added at the far right of the grid.  Most of the time I want the column at the far left.  That means the tedious moving all the way across the screen one step at a time across 20-30 columns.  It can get annoying if you often want to add a column to do a quick check of field assignments.
 
Suggestions in descending order of preference:
 
1) Always add column to left or right of selected column (or above/below the selected column in the add column dialogue).
 
2) Allow columns to be dragged/moved in the same way as selected cells:
last column>move right =  first column
first column>move left = last column
 
3) Option to set location of new columns to first or last position
 
Seems like I remember columns sometimes getting added at other positions but I don't know what I did to cause that nor am I able to reproduce it now.
 
Wayne
114c
 
 
 
 

Comments

Hi Wayne,
 
Good suggestions indeed. Right now, the only way is to drag-drop from the Properties pane...
 
Pierre_Admin
IQ Designer
 

WayneK

2019/10/07 11:36

In reply to by Pierre_Admin

Oh yeah, I forgot about dragging.  That's actually a viable solution as I have most of the fields I need readily available in forms. Thanks.
 
Wayne
 

Pierre_Admin

2019/10/07 12:07

In reply to by WayneK

Good !
Eventually, the Properties pane will select multiple selection, so it will be even easier to drag-drop fields
 
Pierre_Admin
IQ Designer
 

Hi Wayne,
 
Also of interest to you perhaps is that you can re-order columns in the Add Column dialog (drag-drop) and this will be reflected in the grid when you click OK
 
Finally, another quick way is to use the Current Grid section of the Properties pane: Alt + up/down will move columns in the current grid
 
HTH !
 
Pierre_Admin
IQ Designer
 

LeftEccoForIQ

2019/10/20 17:38

In reply to by Pierre_Admin

Drag and drop of columns in a grid and of fields from the properties pane could do with some polishing, even though you can get everything done as is (with some patience):
 
1. Can't drop field from prop.pane at far left
2. When dropping field from prop.pane right above the divider between two grid columns, the column for the field is added at the far right rather than between the two columns
3. Result of drag and drop from prop.pane on column header is not reliable. Sometimes the column for the field is added at the left of the one whose header it is dropped on, sometimes it is added to its right.
4. No indicator is shown between the column headers when dragging a field from the properties pane. Further down in the grid, a red indicator for a row position appears but when dropping the field is added as a column, not a row. (as expected but not as indicated)
5. When dragging columns within a grid, the green indicator does not show reliably where a column will "land". It seems to work okay when you drag to left but when dragging to the right, the column will often appear one column further to the right than was indicated. When trying to drag to the extreme right, the indicator is always shown to the left of the rightmost column rather than to its right where the dragged column will appear.

In v114i:
  • New: Grid: Columns added are now added to the right of the current (focused) column
Also keep in mind that there are commands to move columns and these work on all selected columns (Column > Header > Move left/right...)
 
Pierre_Admin
IQ Designer