Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Check the color of text?

BowDown
in Script Workspace and Script Triggers

Featured Replies

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.

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.

Hi

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

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

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.