Formatting text colour

[1616]

Formatting text colour on individual rows of a portal, how would i do this.

[John Mark Osborne]

Use the TextColor function in an Auto-Enter calculation. Here is an example of the calculation updating when the category field changes:

http://www.filemakerpros.com/HOT.zip

[Genx]

..Yes but on portal row number? Maybe try an unstored calc that uses get(portalrownumber)... if thats not a function, get(recordnumber).

~Genx

[John Mark Osborne]

Since latinoheat was not specific about the circumstances under which the text color in the portal rows should change, I provided a very basic example that will work fine in a portal row. If there is a field in the portal that determines what color the text should be, use the example I provided on a field in the related table and it will work great. If latinoheat gets more specific, maybe we can provide a more specific solution.

[Genx]

Formatting text colour on individual rows of a portal, how would i do this.

... I thought this implied that they wanted to know how to do it based on individual rows, yet your right, the criteria wasn't specified. We'll have to wait and see.

[comment]

A separate UNSTORED calculation field referencing Get ( RecordNumber ) should do it.

Perhaps there should be a rule requiring a minimum of words for the first post in a thread.

[LaRetta]

... calc that uses get(portalrownumber)... [color:blue]if thats not a function, get(recordnumber).

Some might question whether you are providing assistance at all if you suggest something that you don't even know exists. Yes. There is a Get(PortalRowNumber). But even though it exists, you haven't provided ANYTHING in the way of assistance. What should they do with Get(PortalRowNumber) or Get(RecordNumber)? Put it in a bank and draw interest?

I could have responded with, "On Tuesdays sometimes but I think green would work better." And if voted upon by the Forum, it'd probably be a tie on which of us was the most helpful. Make sense, Genx? :wink2:

[Genx]

Johns post prior to mine covered this. All i suggested was swapping an auto enter text field for a calc field and perhaps utilize the get(recordnumber) function.

I too think green would work better on tuesdays, and every day :

Once again, until the OP specifies exactly what they want, there's no real point in going in to detail (even though john did and i just specified a different criteria and field type with the same method).

[Genx]

In future i won't question myself...

[LaRetta]

Well, you missed my point. But that's okay. :smirk:

[Genx]

No i didn't your point is taken, but

a) i really am in a bit of a rush and this is my real last post,

: ... your point is taken

c) Green really is a nice color on tuesdays

d) that was a joke and your point is taken

e) i don't usually question whether functions exist (even though i know i shouldnt at all)

f) that post was more querying johns method than trying to provide a real solution

Jokes aside, i'm not daft, i really do get the point of your post and will think about it in future.

~Genx

[comment]

In any case, Get(PortalRowNumber) will not work here, because it returns the number of the currently selected portal row. IOW, there's only one PortalRowNumber per window at any time.

[1616]

Thank you to everyone for the help, i decided to take the easier way out and create 3 separate portals and format them indivdually, setting the intial row to the next value needed.