conditional hide row, per record

[Steve Wood]

Edward,

No, that's not it! I read that topic beforehand. That will hide the particular FIELD, not the row. The row will still exist along with its label.

[martin horzempa]

hi Steve
i you want to do this and you cant find another way
you could use a bit of javascript
just a thought
martin

[Edward Larrabee]

Steve,

In a previous post you said a "row" was a field, so what is the problem?

-ed

[Steve Wood]

I've had to say "row" a lot in this conversation. But I believe you are referring to where I said "[a row] is the projection of the field value, along with its label".

[[email protected]]

I've had to say "row" a lot in this conversation. But I believe you are referring to where I said "[a row] is the projection of the field value, along with its label".

Have you tried to use

.field_info[1].Column.Hide = iif(pseudo code to exclude)

concept in the filtering section?

[Pat Bremkamp]

Steve,

If it is really that important, and not just a "nice to have" feature, and as long as you only want to display one record at a time, then you could do it by going through an intermediate page that looks at the data and sets session variables to the record values. Then in your display page, filter on the session variables to hide the rows.

I use the following filter in the filter section of a page to hide columns based on session variable values. If the column heading is blank, then the column is hidden.

 
with tmpl_Pe_List
 componentName = "Pe_List"
'==== Add a filter and hide blank columns ====
 .DBF.filter = "Li_Id=" + s_quote(session.Li_Id)
 for x=1 to 12 
 field_info[x+3].column.heading=session.PL[x]
 if alltrim(session.PL[x])=""
  field_info[x+3].column.hide=.t.
 end if
 next
'==== end of filter and hide ====

You could do the same thing by going first to a code only page that reads the values in the row, assigns them to session variables, then redirects to your display page which if filtered by the session variables.

Pat

[Nathan Zeiset]

Re: conditional hide row, per record

I realize that this is an old thread, but I came across it while trying to accomplish the exact same thing that Steve described. In case anyone else is trying to find the answer to this problem, I thought I'd share what I've come up with.

1. Select the field that you want to be conditionally displayed, and change the control type to custom. Put your conditional statements in the Custom Control Properties definition. For example:

'Write Xbasic code here that returns the HTML to be displayed by this control
select
    case data.Msg_date=""
	Msg_date_render = <<%html%
	%html%

    case data.Msg_date<>""
	Msg_date_render = <<%html%
	{Msg_date}
	%html%

end select

2. Insert conditional code in the row label. For example:

<div align="right">
<%a5
select
    case data.Msg_date<>""
	? "Date"
end select
%>
</div>

Using this approach, the row will disappear if the Msg_date field is empty. However, there will be an extra dividing line where the row would have been. It's not perfect, but suitable for me.

I should also note that this was done in version 8. I can't say whether or not it will work in v7.

Nathan

[peteconway]

Re: conditional hide row, per record

Many thanks I'll give it a go. A rule on this, working the way field rules work with a calculated field would be the answer.

[peteconway]

Re: conditional hide row, per record on a grid - solved

I have managed to do just what I want by using field rules in the table.

Example:

Say I want to display the current url of an entry, make it avalable to edit and be able to use it as a link all at the same time.

Normally you would assign a static text link like email, view. The problem is this would appear even if there was no link (no data within the field being linked to), so what to do?

In my table I have a field called {primaryweb} that contains the web address I wish to use, I also have (what I call) a shadow {webshadow} field the same attributes. I then have a third field called {weblick} that's six characters long (the display link).

The shadow filed is a calulated field, if the {primaryweb} field is <> "", then the shadow filed populates with the data in the {primaryweb} field e.g. (IF(PRIMARYWEB <> "",PRIMARYWEB,"")).

The {weblick} field is also a calculated field, it depends on the {webshadow} field being <> "", e.g. (IF(WEBSHADOW <> "","Visit","").

To make this work in the grid, all that is needed is to use the shadow field as a linked {webshadow} field, with the webclick field as the "Display what in the link? - Value from another field, being {weblink}, and link address type is "Field value is link address".

You can also use the {primaryweb} field on the same grid for editing the data if required.

Also works for conditional image links.

IF(LOGO=.T.,ALLTRIM("\media\logo\ ")+ ALLTRIM(STR(ID)) +"."+ LOGOTYPE,"\media\logo\none.jpg")

Hope people find this of assistance.

Peter