I would like to use the field name in a calculation. the Get(Active...) only displys information when the cusrsor is in the field. I would like the information displayed all of the time.

Example...

The field name is D101

Case (MoveSample::From="D101";TextColor("FROM";RGB(255;0;0));

MoveSample::To="D101";TextColor("TO";RGB(0;255;0)))

I would like to copy this field many times and only change the name of the field... not the calculation.

Edited November 2, 200520 yr by Guest

Hi, soswald16 !

Function GetField..... dont help?

If I am guessing correctly what you're doing, this should work for you:

Case (

Evaluate ( MoveSample::From ) = D101 ; TextColor ( "FROM"; RGB ( 255 ; 0 ; 0 ) ) ;

...

However, it would require the contents of each D-field to be unique.

Again, I am only guessing, but it looks like your D-fields should be separate records. This would make any manipulations much easier - see attached.

CellShuffle.fp7.zip

GesField does not solve the problem. I am placing each field (D101, C205...) on a map to show locations. I can change the calculations to reflect the field name but would prefer to use the field name in the calculation. I seem to run into a need for this quite often so I am convinced that the wisdom of this forum can solve it.

Better example?

Field Name= C209

Case(

FromClassroom=[i want this to be the field name];TextColor("FROM";RGB(128;0;0));

ToClassroom="C209";TextColor("TO";RGB(0;102;0)))

Not this......^

Hi

I think that your request is related to this: GetFieldName(fieldName)-the missing function