James Chung Posted August 19, 2008 Share Posted August 19, 2008 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 Link to comment Share on other sites More sharing options...
Fenton Posted August 19, 2008 Share Posted August 19, 2008 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 Link to comment Share on other sites More sharing options...
James Chung Posted August 22, 2008 Author Share Posted August 22, 2008 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 Link to comment Share on other sites More sharing options...
Fenton Posted August 22, 2008 Share Posted August 22, 2008 What about the Description? Do you want it bold/red/underline for the ones that are checked, or the opposite? Link to comment Share on other sites More sharing options...
James Chung Posted August 22, 2008 Author Share Posted August 22, 2008 Yes. I still want bold/red/underline for the ones that are checked. Thanks Link to comment Share on other sites More sharing options...
Fenton Posted August 22, 2008 Share Posted August 22, 2008 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5739 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now