List Box - Hiding Columns

[Stephen J. Orth]

I see there are ways to hide List Box rows, but don't see any way to hide
columns.  Most of my forms have columns to the far right that contain
special values, only used by the system.  These columns make no sense to the
user, and should not be seen.

I've tried to procedurally resize the columns I want hidden to zero, but
that doesn't seem to work.  I also don't see any commands to accomplish
this.

How do you go about hiding columns in a List Box?


Steve

*****************************************************
  Stephen J. Orth                                                
  The Aquila Group, Inc.                       Office:  [phone]
  P.O. Box 690                                     Mobile:  [phone]
  Sun Prairie, WI 53590

  E-Mail:  s.orth@...
*****************************************************



**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Chip Scheide]

Set visible (column_reference;false)

On Fri, 6 Nov 2009 16:09:04 -0600, Stephen J. Orth wrote:

> I see there are ways to hide List Box rows, but don't see any way to hide
> columns.  Most of my forms have columns to the far right that contain
> special values, only used by the system.  These columns make no sense to the
> user, and should not be seen.
>
> I've tried to procedurally resize the columns I want hidden to zero, but
> that doesn't seem to work.  I also don't see any commands to accomplish
> this.
>
> How do you go about hiding columns in a List Box?
>
>
> Steve
>
> *****************************************************
>   Stephen J. Orth                                                
>   The Aquila Group, Inc.                       Office:  [phone]
>   P.O. Box 690                                     Mobile:  [phone]
>   Sun Prairie, WI 53590
>
>   E-Mail:  s.orth@...
> *****************************************************
>
>
>
> **********************************************************************
> Get the speed and power of 4D v11 SQL
> before upgrade prices increase - http://www.4d.com
>    
>
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4D.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4D_Tech-Unsubscribe@...
> **********************************************************************
>

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Cannon Smith]

Hi Steve,

I'm not sure if you're talking about columns you build in the form editor or not. If so, did you notice the Invisible property for columns? It works well.

Otherwise, here is some code that is working for me in 4D 2004.

If (vlSTATE_LotSelectionCount=1)ÊÊ`Only one lot selected
        SET LISTBOX COLUMN WIDTH(*;"atInCohort_LotName";0)
Else
        SET LISTBOX COLUMN WIDTH(*;"atInCohort_LotName";72)
End if
       
HTH.

--
Cannon Smith
Synergy Farm Solutions
P.O. Box 65 -- Hill Spring, AB CANADA -- T0K 1E0
[phone] or 1-866-626-3236
<cannon@...>
<www.synergyfarmsolutions.com>



Stephen J. Orth wrote:

> I see there are ways to hide List Box rows, but don't see any way to hide
> columns.  Most of my forms have columns to the far right that contain
> special values, only used by the system.  These columns make no sense to the
> user, and should not be seen.
>
> I've tried to procedurally resize the columns I want hidden to zero, but
> that doesn't seem to work.  I also don't see any commands to accomplish
> this.
>
> How do you go about hiding columns in a List Box?

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com


4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Stephen J. Orth]

Chip,

Ok, that is real intuitive....not.

I guess I should have figured that one out.


Steve



-----Original Message-----
From: Chip Scheide [mailto:4d_Only@...]
Sent: Friday, November 06, 2009 4:13 PM
To: s.orth@...; 4D iNug Technical
Subject: Re: List Box - Hiding Columns

Set visible (column_reference;false)

On Fri, 6 Nov 2009 16:09:04 -0600, Stephen J. Orth wrote:
> I see there are ways to hide List Box rows, but don't see any way to hide
> columns.  Most of my forms have columns to the far right that contain
> special values, only used by the system.  These columns make no sense to
the

> user, and should not be seen.
>
> I've tried to procedurally resize the columns I want hidden to zero, but
> that doesn't seem to work.  I also don't see any commands to accomplish
> this.
>
> How do you go about hiding columns in a List Box?
>
>
> Steve
>
> *****************************************************
>   Stephen J. Orth                                                
>   The Aquila Group, Inc.                       Office:  [phone]
>   P.O. Box 690                                     Mobile:  [phone]
>   Sun Prairie, WI 53590
>
>   E-Mail:  s.orth@...
> *****************************************************
>
>
>
> **********************************************************************
> Get the speed and power of 4D v11 SQL
> before upgrade prices increase - http://www.4d.com
>    
>
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4D.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4D_Tech-Unsubscribe@...
> **********************************************************************
>

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Stephen J. Orth]

Cannon,

Thanks...I'll play with this tonight and see how it goes.

BTW, it was good seeing you again at the Summit!


Steve




-----Original Message-----
From: Cannon Smith [mailto:cannon@...]
Sent: Friday, November 06, 2009 4:34 PM
To: 4D iNug Technical; s.orth@...
Subject: RE: List Box - Hiding Columns

Hi Steve,

I'm not sure if you're talking about columns you build in the form editor or
not. If so, did you notice the Invisible property for columns? It works
well.

Otherwise, here is some code that is working for me in 4D 2004.

If (vlSTATE_LotSelectionCount=1)ÊÊ`Only one lot selected
        SET LISTBOX COLUMN WIDTH(*;"atInCohort_LotName";0)
Else
        SET LISTBOX COLUMN WIDTH(*;"atInCohort_LotName";72)
End if
       
HTH.

--
Cannon Smith
Synergy Farm Solutions
P.O. Box 65 -- Hill Spring, AB CANADA -- T0K 1E0
[phone] or 1-866-626-3236
<cannon@...>
<www.synergyfarmsolutions.com>

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com


4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Kirk Brooks]

On Fri, Nov 6, 2009 at 4:10 PM, Stephen J. Orth <s.orth@...
> wrote:

> Ok, that is real intuitive....not.
>

I took me a while to get used to the idea the List Box is sort of like a
collection of arrays - and I can still refer to each array itself. Turns out
to be useful for setting enterability also.
--
Kirk Brooks
San Carlos, CA
=======================
**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Stephen J. Orth]

Kirk,

Thanks for the feedback. I’m just getting into List Box’s and I agree, it
takes a little bit of getting used to.


Steve

*****************************************************
  Stephen J. Orth                                                
  The Aquila Group, Inc.                       Office:  [phone]
  P.O. Box 690                                     Mobile:  [phone]
  Sun Prairie, WI 53590

  E-Mail:  s.orth@...
*****************************************************


From: Kirk Brooks [mailto:lists.kirk@...]
Sent: Friday, November 06, 2009 6:46 PM
To: s.orth@...; 4D iNug Technical
Subject: Re: List Box - Hiding Columns

On Fri, Nov 6, 2009 at 4:10 PM, Stephen J. Orth
<s.orth@...> wrote:
Ok, that is real intuitive....not.

I took me a while to get used to the idea the List Box is sort of like a
collection of arrays - and I can still refer to each array itself. Turns out
to be useful for setting enterability also.  
--
Kirk Brooks
San Carlos, CA
=======================

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com


4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Jack des Bouillons]

It's not the columns as arrays that I had getting my head around...it was
the header as buttons that was befuddling for the longest time.

Jack des Bouillons


On 11/6/09 4:47 PM, "Stephen J. Orth" <s.orth@...> wrote:

>
> Thanks for the feedback. I¹m just getting into List Box¹s and I agree, it
> takes a little bit of getting used to.
>
>
> Steve



**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com


4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Just In Time]

If the column is always going to be hidden, simply select the column in the form editor and set the Invisible property checkbox to false.

Plus, there's a contextual menu in the form editor when you select a column that lets you show or hide the invisible columns in the form editor, so that you are able to see the columns as the user might see them.

Chip Scheide wrote:

Set visible (column_reference;false)

On Fri, 6 Nov 2009 16:09:04 -0600, Stephen J. Orth wrote:
> I see there are ways to hide List Box rows, but don't see any way to hide
> columns.  Most of my forms have columns to the far right that contain
> special values, only used by the system.  These columns make no sense to the
> user, and should not be seen.
>
> I've tried to procedurally resize the columns I want hidden to zero, but
> that doesn't seem to work.  I also don't see any commands to accomplish
> this.
>
> How do you go about hiding columns in a List Box?

[Stephen J. Orth]

Justin,

Thanks for the tips...


Steve




-----Original Message-----
From: 4d_tech-bounces@... [mailto:4d_tech-bounces@...] On
Behalf Of Just In Time
Sent: Saturday, November 07, 2009 10:47 AM
To: 4d_tech@...
Subject: Re: List Box - Hiding Columns


If the column is always going to be hidden, simply select the column in the
form editor and set the Invisible property checkbox to false.

Plus, there's a contextual menu in the form editor when you select a column
that lets you show or hide the invisible columns in the form editor, so that
you are able to see the columns as the user might see them.

-----
-----
Justin Leavens
Just In Time Consulting, Inc
4D Application Consulting and A4/Foresight Financials/AcctVantage
customization
justin@... / www.justintimebusiness.com / [phone]


**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Chip Scheide]

advantage to Set Visible :
you can this on the fly - so If you are building your list boxes
dynamically you have a means to turn them on/off

On Fri, 6 Nov 2009 18:10:51 -0600, Stephen J. Orth wrote:

> Chip,
>
> Ok, that is real intuitive....not.
>
> I guess I should have figured that one out.
>
>
> Steve
>
>
>
> -----Original Message-----
> From: Chip Scheide [mailto:4d_Only@...]
> Sent: Friday, November 06, 2009 4:13 PM
> To: s.orth@...; 4D iNug Technical
> Subject: Re: List Box - Hiding Columns
>
> Set visible (column_reference;false)
>
> On Fri, 6 Nov 2009 16:09:04 -0600, Stephen J. Orth wrote:
>> I see there are ways to hide List Box rows, but don't see any way to hide
>> columns.  Most of my forms have columns to the far right that contain
>> special values, only used by the system.  These columns make no sense to
> the
>> user, and should not be seen.
>>
>> I've tried to procedurally resize the columns I want hidden to zero, but
>> that doesn't seem to work.  I also don't see any commands to accomplish
>> this.
>>
>> How do you go about hiding columns in a List Box?
>>
>>
>> Steve
>>
>> *****************************************************
>>   Stephen J. Orth                                                
>>   The Aquila Group, Inc.                       Office:  [phone]
>>   P.O. Box 690                                     Mobile:  [phone]
>>   Sun Prairie, WI 53590
>>
>>   E-Mail:  s.orth@...
>> *****************************************************
>>
>>
>>
>> **********************************************************************
>> Get the speed and power of 4D v11 SQL
>> before upgrade prices increase - http://www.4d.com
>>    
>>
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4D.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4D_Tech-Unsubscribe@...
>> **********************************************************************
>>
>
>

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Stephen J. Orth]

Cannon,

Yes, this is a very good point, since most of my interfaces would be built
on the fly.


Steve



-----Original Message-----
From: Chip Scheide [mailto:4d_Only@...]
Sent: Monday, November 09, 2009 9:20 AM
To: s.orth@...
Cc: '4D iNug Technical'
Subject: RE: List Box - Hiding Columns

advantage to Set Visible :
you can this on the fly - so If you are building your list boxes
dynamically you have a means to turn them on/off

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Philip Davis]

Funny that this would come up now. It is a topic I just covered in my  
podcast at www.taintRocketScience.com, a podcast I've been publishing  
for 4D to address issues for both the beginner and the expert. Check  
it out. It's also available via iTunes. The bottom line is I  
discovered that it was best to hide both the column and the header for  
columns created by the designer in the form editor.

Phil Davis

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************