Check the color of text?

[BowDown]

I have 4 rows of 96 *'s.

I used a script that I found on here that will allow the user to select a section of the row and change the text color to red. Now I want to write a script that will go through the string of 96 *'s and count the red ones, or maybe the black ones if it's easier...

I don't see a scriptMaker function that can check the color of the text? Anyone have any ideas?

Mainly I'm using this to create a graph of a 24hr period (broken into 15min sections) to show where our drivers have been.

Off Duty

Sleeper

Driving

On Duty Not Driving

Any help would be appreciated.

[comment]

The function you need to use is GetAsCSS. But it won't be easy. Also, IMHO, there are better ways to let users input data (buttons, for example).

NOTE: GetAsCSS is a calculation function. There are no script functions in Filemaker - only script steps.

[Raybaudi]

Hi

this will count the rows with full red ( RGB (255;0;0) ) inside:

PatternCount ( GetAsCSS ( Substitute ( yourTextField ; ¶ ; TextColor ( ¶ ; RGB ( 0 ; 255 ; 0 ) ) ) ); "#FF0000" )