Entering data into a Calc field?

[Heathbo]

I have a calculation field(A.) that checks to see whats entered in another field(B.), and if a specific word comes up(in B.) it turns the text in it (in A.) white. By doing this I run into the problem that I can't type into that (A.) field. Is there a way to make (A.) typeable and yet keep the script to change the text in it's color?

Thanks for any help you can give.

[AFK]

could i see a copy of this script?

thanks

corey

[email protected]

[transpower]

A better way would be to use an auto-enter calculation for field B.

[Søren Dyhr]

You might be doing it entirely without script, is there a special reason for both having a calc'field and a script doing almost identical tasks?? I've made you a template exploiting the Autoenter (replace existing value) ...it's the closest you get to recursivity if don't have 7Dev!

--sd

CalidoscopeEyes.zip

[Søren Dyhr]

Is it the coloring/stylechange or is it the overwriting of the field you need under ver. 5.0??? In case it's the first is there som inspiration to get by tearing this template apart:

http://www.mogulsoft.com/fmpro/bldfrmat.zip

--sd

[Heathbo]

I am using Dev 7.

<--------- SEE!

This is what I have so far.

I have 3 fields.

One is called subject. Its a text field. This field can have 1 of 30 words in it based on a value list.

Two is called color. Its a calculation field wich has a calculation result of a container. This field has a case function which checks whats in the subject field and changes what it holds based on what it finds.

Three is called Number. Its a text field. This field is on top of the color field in the layout. One of the colors that goes into the color field is black. Because of that, when the color field is black, the black text in the text field doesn't show up. So I need a way to change the text color in the text field to white whenever the text in the subject field calls for the color field to change to black. The catch is, the text field must stay editable. Thats the problem I'm running into.

Note: this is in response to transpower

How would I do an auto-enter calculation for B?

[Søren Dyhr]

Ah yes you are!!! Try to ivestigate these two templates:

http://www.filemakerpros.com/HILITE3.sit

...as well as this:

http://www.filemakerpros.com/NUMFORM.sit

But also:

http://www.briandunning.com/filemaker-custom-functions/detail.php?fn_id=23

--sd

[Søren Dyhr]

How would I do an auto-enter calculation for B?

You seems to have overseen that I use them as well in the template I made you, which also needs to be done with the customfunctions work- otherwise won't you get access to them!!

--sd

[Heathbo]

The template you have given is checking to see if two fields match. I just need to know if 1 field has a word in it. If so, change the color of the text.

I tried the calculation below on a text field with a calculated value. But it doesn't work. It works great on a calculation field but not on a text field.

Case ( Dp0 SE Menu = "OLD"; TextColor ( Dp0 ; RGB ( 255 ; 255 ; 255 ) );

TextColor ( Dp0 ; 0 ) )

Any help you can give is much appreciated.

[comment]

Define Database > Fields > Options > Auto-Enter > Calculated value.

Deselect "Do not replace existing value.."

[Heathbo]

I got it working now. I didn't realize I had to update the info that the field was referencing.