Announcement

**GGandhi** · 08-04-2017, 06:36 PM

Re: OnGridInitialize

here is something for you to try:

Code:

        dim controlID as n
	controlID = e.tmpl.field_info.find("id","fieldname")

        dim controlLastName as n
	controlLastName = e.tmpl.field_info.find("lastname","fieldname")

        e.tmpl.field_info[controlID].Column.Hide = .t.
	e.tmpl.field_info[controlLastName].Column.Hide = .t.
        e.tmpl.flagMustRecalculateGridLayoutAndControls = .t.

and so on so forth.
see if this works for you

**Jberry** · 08-05-2017, 09:38 AM

Re: OnGridInitialize

Hi Gandhi,

Thanks for replying. I tried your suggestion but I must be doing something wrong because I just can't seem to get it to work, however, your suggestion pointed me into a similar direction and I used a loop to loop through the fields and it works. IE:

x = e.tmpl.fields
for k = 1 to x
if e.tmpl.field_info[k].fieldname = "Y1_P1_Actual" then
e.tmpl.field_info[k].Column.Hide = .t.
end if
next k

Thanks for your help.

-John

**GGandhi** · 08-05-2017, 10:29 AM

Re: OnGridInitialize

why it did not work, it work fine here in version 11?
secondly, in your loop you are verifying a single value, it looks like that to me. is that you wanted?
your example showed you are hiding two different fields.
you want me to post a video show it works or you are okay with what you have?

**Jberry** · 08-05-2017, 10:38 AM

Re: OnGridInitialize

Hi Gandhi,

Yes, in the loop example I was only verifying one value, in reality I'll be verifying many values; I just tried to narrow it down for the brevity sake.

If it's not too much trouble then yes, I'd love a video.

Appreciate your help.

-John

**GGandhi** · 08-05-2017, 11:50 AM

Re: OnGridInitialize

okay here is a simple example.
https://www.screencast.com/t/kWK6EPCs7t
post back if you need something else.
look for documentation array.find() which is what i utilized, sine tmpl field info is an array. click on the xbasic below the grid you will understand.

**GGandhi** · 08-05-2017, 12:12 PM

Re: OnGridInitialize

you said something about some conditions met, may be that needs to be addressed.
let me know what that is, so i know.

**Jberry** · 08-05-2017, 12:27 PM

Re: OnGridInitialize

Hi Gandhi,

Thanks, I understand it now. The reason it didn't work for me the first time is because I misunderstood this piece: controlID = e.tmpl.field_info.find("id","fieldname") I thought you wanted me to replace "fieldname" with the name I was looking for! Hence it didn't work. I went to the help to find out what I needed to do but in the help when I typed in array.find I get

References > Methods > ARRAY.FIND Method
Object moved to here.

References > Methods > ARRAY.FIND Method
Send Feedback on This Topic
Add note

and not the help screen you were looking at in the video. Clicking the link only brought up an error message so that's when I decided to use a loop instead.

Anyway, really, thanks for spending time on this. I'll let you know how it goes.

Thanks

-John

**GGandhi** · 08-05-2017, 12:33 PM

Re: OnGridInitialize

okay
two things:
click on documentation on the top and will get you to where i was in the video.
the field name ids the property and the value is id or lastname or firstname or whatever.
so you are looking array find("id", "fieldname") will give you the element of the array where id is located like array[1].fieldname = id
same with last name
array.find("lastname", "fieldname") will give you array element where the fieldname is lastname like array[2].fieldname = lastname
you are identifying the element value then using that again to hide.

**GGandhi** · 08-05-2017, 12:47 PM

Re: OnGridInitialize

how was it done:
https://www.screencast.com/t/1PYS5mwP

**aburningflame** · 09-01-2017, 03:23 PM

Re: OnGridInitialize

I add the following to the Code as a function

Code:

function HideGridColumnsByFieldname as V(BYREF e as P,fields_to_hide as C)
                fields_to_hide=upper(fields_to_hide) 'case insensitive
                for i=1 to e.tmpl.field_info.size()
                                if is_one_of(upper(e.tmpl.field_info[i].FieldName),fields_to_hide)
                                                e.tmpl.field_info[i].Column.Hide=.t.
                                                e.tmpl.flagMustRecalculateGridLayoutAndControls = .t.
                                end if
                next
end function

and then use it like so in the OnGridInitialize

Code:

HideGridColumnsByFieldName(e, "column1,column2,column3")

**Jberry** · 09-11-2017, 05:38 PM

Re: OnGridInitialize

Thanks guys.

Announcement

The Alpha Software Forum Participation Guidelines

OnGridInitialize

OnGridInitialize

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment