Conditional format in every other portal row

[stefangs]

I have a portal with the alternate row colors turned on. There is a field in the rows that is overlayed on top of another one. So as to not mess up the appearance, the upper field needs a fill. But this looks ugly in every other portal row.

Is there a way to format this, depending on whether it's an odd or even row? At least in my v13 I can 't see this, but perhaps there's a better way to accomplish the same thing.

Thanks

[comment]

8 hours ago, stefangs said:

Is there a way to format this, depending on whether it's an odd or even row?

There is, but it is a bit complicated because Get ( RecordNumber) in a conditional formatting formula will be evaluated from the context of the parent record. The solution is to define an unstored calculation field in the child table as =

Get ( RecordNumber)

then use:

Mod ( Child::cRecordNumber ; 2 )

or:

not Mod ( Child::cRecordNumber ; 2 )

as the formula for conditional formatting. If the relationship is allowed to create child records, you may need to expand the expression to handle the "ghost" record's fields.

 

[stefangs]

Perfect, thanks! I'm glad I don't need to deal with ghost fields 😉