Conditional formatting in portal

[jorfasan]

Hi,

In a multiuser system I have a layout with a portal that shows Jobs of the current team. It is ordered by customer and, logically, appears the expected data:

customer_1

customer_1

customer_1

customer_1

customer_2

customer_2

customer_3

customer_4

In this field of the customer that I would like to control its appearance. And I would like to have a conditional formatting option or trick in order to show the first customer_1 in black type and the 2nd, 3rd, 4th in grey; the first customer_2 in black, the 2nd in grey characters. Obvious reading confortness that I have implemented in list views thanks to the GetNthRecord is now the standard in this solution. But in portals I have not such a easy option.

The only solution I have in mind is a combo of loop script and conditional formatting

go to related records of portal to new window

sort

loop to

grab the uniqueID of each first ocurrence in variable

close window

conditional formatting of the portal should do the rest of the trick: for example, if the row's uniqueID is in the variable, black, setting the portal format to grey.

Any way to avoid the script?

Thanks in advance.

[comment]

See if this helps:

http://fmforums.com/forum/topic/54781-getting-a-value-from-previous-portal-row/page__p__258830#entry258830

[bruceR]

Or see if this helps:

http://fmforums.com/forum/topic/77765-compare-dates-in-portal-rows/page__view__findpost__p__364689

GetNthInPortalMOD.fp7.zip

[jorfasan]

Hi comment and BruceR

Thanks a lot. It does help. And the linked threads also bring other interesting material.

The file provided by BruceR perfectly solves the issue. Simple, direct, effective.

Now I have to work out a bit in order to play with the usual portal sort tricks). Just to adapt the basic and brilliant technique to the UI challenges, you know. I think that two sort buttons are necessary in most valuable portals. The portal I have to work has more than 30 rows, when managers want to examinate the Jobs for a given team. By the moment, two text fields involved in the sort buttons.

I appreciate so much your both contributions to the FMaker Community.

Thx a lot

[jorfasan]

HI,

I have to mention that I have found a complete article and complementary file in the Weetbicks blog. The issue is completed with a line that enhances de effect I was pursuing.

Portal formatting

HTH