Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

I'm trying to get a calculation that switches two container graphics. User enters a text and the checkmark switches from black to red. I saw a solution like this before but could not find a post of it. Any Help?

Thanks

Graphic_Calc.fp7.zip

Posted

Change cTextValidate to:

If ( IsEmpty ( Text ) ; cContainer ; cContainer [ 2 ] )

When specifying repetitions, the first repetition is the default if left unspecified.

Posted

One more example, color change in text.

Is it possible to have a entered value change colors? In this file the "Item in Stock" should change color and not "cCalc", is this possible this way or is it only possible with 2 different colored fields?

Text_Color_Change.fp7.zip

Posted (edited)

Change calc type to text and it will change when the value changes. You have it as a number and that's why it doesn't work.

UPDATE: You can also apply color directly to a standard field by leaving it a standard field and applying your calc under the Auto-Enter tab, via calculation. After you enter your calc, UNCHECK 'Do Not Replace Existing Value' in the Auto-Enter tab. I prefer not to colorize my original text because printing can then look odd.

And you can shorten your calculation to:

If ( Item in Stock < Item Reorder Level ; TextColor ( Item in Stock ; RGB ( 255 ; 0 ; 0 ) ) ; Item in Stock )

You can use as many colors as you wish - just define them within the calculation ( using a Case statement etc).

Edited by Guest
Added update

This topic is 6737 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
×
×
  • Create New...

Important Information

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