Differentiate portal rows based on past or future

[Jason Goldsmith]

I have a portal which shows events. I would like events scheduled for the future to be displayed in a different color, or perhaps underlined or in italics. Any suggestions?

Thank you,

Jason

[Ugo DI LUCA]

You can do all of this through calculations.

The Highlight would be based upon a container calculation in related file.

Case(Date>Status(CurrentDate), GetRepetition(globalContainer,1), GetRepetition(globalContainer,2)) - could even be only one choice.

The Italics or bold or underline would be done by some "articifical" fields, calculated.

c_returnBold = Case(Date>Status(CurrentDate), FieldValue, "")

c_returnStandard = Case(Date<=Status(CurrentDate), FieldValue, "")

Place both fields one over the other, set the field to be transparent. Format the c_returnBold to be bold, the standard standard, the underlined underlined,....

Et voil

[Jason Goldsmith]

Thanks Ugo,

I'm not quite sure what I'm doing wrong here. Your suggestion makes sense conceptually.

Jason

Events.zip

[-Queue-]

The calculations are most easily performed in the related file, as Ugo suggested. Also, you must display only related fields in a portal, unless you want to see only information from the current file.

See attachment for fix.

RelatedFormatting.zip

[Ugo DI LUCA]

Here are 8 variations on this topic...

Enjoy

Events.zip

[-Queue-]

Is someone bored? Perhaps they have have no projects on which to work?

[Ugo DI LUCA]

I was just waiting for my secretary to bring the project I had left on my desk at the office...

But HE forgot the coffee....for this busy night....

[Jason Goldsmith]

That works just great (all of them). Thanks so much.

Jason