Jump to content

Script to automatically change text color


This topic is 5685 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm working on a database that tracks the ads placed in a publication. Some of the advertisers place ads in multiple editions, so I created an "edition" field to track which ones they appear in. But I would like all of the fields for listings that are older than 2 editions to appear in red so that I can easily distinguish at a glance which ones are old and which ones are still pending.

This is the script that I wrote using the text color function. Then I created a button for each record and set it to run this script. I know I would have to add the other fields to it, but I can't even get it to work on the one field.

If (Database::Edition ≠ "May" or "June" ; TextColor ( Database::Edition ; RGB ( 255 ; 0 ; 0 ) ) ; TextColor ( Database::Edition ; RGB ( 255 ; 255 ; 255 ) ))

I've never worked with the text color function, so I'm sure I'm using it wrong. Anyone have any ideas on how I can make this work, or some other way I can automatically distingush the old records from the new ones? I'm open to suggestions. As an alternative, I can have a new field that just calls them OLD, but I would prefer to have the listing change to a different color altogether.

Thanks.

Link to comment
Share on other sites

Try:

If (Database::Edition ≠ "May" or Database::Edition ≠"June" ; TextColor ( Database::Edition ; RGB ( 255 ; 0 ; 0 ) ) ; TextColor ( Database::Edition ; RGB ( 255 ; 255 ; 255 ) ))

You don't need a script though. If you set all the fields that you want to change colors to Text Auto-Calc (with replacing), it should work too, and just put the above if statement as the Auto-Calculation. Make sure to replace "Database::Edition" which the name of the field you're making an auto-calc.

Just incase, you may want to back up your data for this one. It's not dangerous when it's in place. But if you accidently put the above calculation for the field "database::Title" then all your titles will be replaced with the edition field.

I hope this helps!!

:)

Martha

P.S. i attached a file with that concept in Topic#176709

Link to comment
Share on other sites

This topic is 5685 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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