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

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.

 

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