Conditional formatting Flag?

[James Chung]

Could anyone help me solving this?

How to create a script for the Flag that can control the "NO" and make all fonts inside "Description" becoming bold + underline, even when I print out? Example attached.

Best

James

Portalrow.zip

[Fenton]

Here's my take on it. The Description is pretty easy to do, either with Conditional Formatting (9) or with an auto-enter by calculation. But the NO (number in the portal) is easier to do as a calculation.

What you are counting is the number of checked rows, which is a different relationship than the portal itself, a self-relationship in the PortalRow table. So I used the List() function (8.5), to get those. Then number is the line position of the record's unique ID in that list. Maybe you could do this with Conditional Formatting, I don't know, nor see the point.

There is a weakness in the method. Which is that if you change the Sort of either the portal's relationship or the portal itself, the numbers will no longer match the rows at all. That could be fixed by changing the sort of the self-relationship to match; both are targeting the same base table.

Portalrow9_fej.fp7.zip

Portalrow85_fej.fp7.zip

[James Chung]

Thanks for your reply.

About the NO(number in the portal), can we have a different result that is when we select the check box, it will skip counting the selected portalrow NO? I want to make the NO generated automatically like the result of inserting record number symbol (@@) in PortalRows and once the check box is X, it will not count the selected row. Can we do that?

Regards,

James

[Fenton]

What about the Description? Do you want it bold/red/underline for the ones that are checked, or the opposite?

[James Chung]

Yes. I still want bold/red/underline for the ones that are checked.

Thanks

[Fenton]

OK, this is how I'd do it. The numbers are the opposite of what they were before.

I added a script to set the checkbox, and then to Commit Record. This makes it a lot cleaner looking. I also overlaid a box on top of a red checkbox field.

Portalrow85_not.fp7.zip