Submitted by WayneK on 2019/03/22 09:59
Is there a way to set a field to  load hidden?  I couldn't find a setting in the fields dialogue.
 
If there isn't, consider this a suggestion.  I have a number of fields I always want hidden, and it's a pain to have to do that manually every time I create a grid.
 
An equally good alternative is my previous suggestion that the "load columns" command should recognize hidden columns (right now they don't).
 
Wayne

Comments

Hi Wayne,
 
I'll see how I can do this without causing more confusion to users
Can you detail why you use many hidden columns ?
 
Pierre_Admin
IQ Designer
 

WayneK

2019/03/28 17:49

In reply to by Pierre_Admin

I'm using columns to emulate the "text touchups" tool in Ecco Pro:  Allows you to assign multiple formatting options with one click (bold, text color, underline etc).
I have 6 or 7 combinations I use regularly, each requiring a column.  So I have to load the whole set with each grid but I don't want them cluttering up my grid view, so I have to go in and hide each column manually.
 
Options:
 
1) Allow column sets to include hidden columns (as suggested here)
2) Allow column sets to load grouped columns (would be just one column to hide instead of multiple individual columns)
3) Another way to accomplish what I'm doing now?
 
#2 would be my preferred solution if it's not too difficult because it solves not only the hidden column issue but also the grouping issue, which I've brought up before.  It would allow you to truly replicate the exact layout of another grid without having to adjust the columns each time.
 
The bottom line is saving horizontal screen space without having to manually fiddle with the columns every time you create a new grid.
 
I understand that it might be difficult to implement and not worth the effort, which is of course your call.  I don't see why it would be confusing for new users since it's only better accomplishing the purpose of column sets: to emulate an existing column arrangement.  It seems more confusing to me that loading column sets now does not do that:
 
1) Hidden columns are not preserved
2) Grouped columns are not preserved
2) Item column position is not preserved (it always loads at the far left, even though it was in a different position in the original grid)
 
Wayne
 

Pierre_Admin

2019/03/28 18:11

In reply to by WayneK

[quote=WayneK]
I'm using columns to emulate the "text touchups" tool in Ecco Pro:  Allows you to assign multiple formatting options with one click (bold, text color, underline etc).
I have 6 or 7 combinations I use regularly, each requiring a column.  So I have to load the whole set with each grid but I don't want them cluttering up my grid view, so I have to go in and hide each column manually.
[/quote]
Interesting. Would you like to share what is typically in those columns ?
Wouldn't it be easier to use something like AHK or some other hotkey manager ?
 
Pierre_Admin
IQ Designer

WayneK

2019/03/29 00:41

In reply to by WayneK

I'm using conditional formatting in the item field to assign highlighting, boldness etc. 
 
In the conditional formats section of the items field, I have formatting combinations I like to use.  eg:
 
[F-Hdg1]<>0; Bold=1|BackColor=&h82B4CD
 
[F-Hdg2]<>0; Bold=1|BackColor=&hC1DDDD
 
I assign items to different fields to get get different formatting combinations.  Maybe there's a better way to do it.
 
Using fields rather than in-text formattng has the added advantage of allowing you to pull together notes of a certain type if you're systematic about it. 
 
I've thought about learning AHK but haven't found the time to get into it.  I have a text expander that's pretty simple.  With AHK I presume I'd be inserting HTML code into the text.  Not a big fan of that because it's too hard to change formatting (have to hunt down, select, and delete existing code).  Using
 
Wayne
 
 
 

Pierre_Admin

2019/03/29 01:24

In reply to by WayneK

Fine use of conditional formatting then !
 
FYI, you could do this with a single column (of field in the Properties pane) and auto-assign rules which would set the item font and color
(it is not exactly the same, and has advantages / disadvantages w.r.t your method)
 
Pierre_Admin
IQ Designer
 

WayneK

2019/03/29 09:53

In reply to by WayneK

Pierre,
 
Could you give a little more info on this method so I can try it out?  I thought you were talking about just using the properties pane fields but that doesn't work because the field still has to be in the grid for the autoassign to take effect>
 
 
Wayne
 

Pierre_Admin

2019/03/29 12:08

In reply to by WayneK

[quote=WayneK]
Could you give a little more info on this method so I can try it out?  I thought you were talking about just using the properties pane fields but that doesn't work because the field still has to be in the grid for the autoassign to take effect>
 [/quote]
The field only needs to be in the grid for conditional formatting, not for other means
 
You could even have IQ show a messagebox when you toggle a checkbox where you enter the format code (1, 2, or 3, or whatever) and it will format the item
 
For a straight auto-assign, in a text field TF_tmp, enter the following auto-assign rule:
 
AM:[ItemColor]=iif([TF_tmp]="1","red","&HFF0000)
E:[TF_tmp]=""
 
HTH !
 
Pierre_Admin
IQ Designer