Choose color from container field in prefs file

[LemlerInv]

Hello All,

I'm using FM6 on Mac OS10.3.

I have defined a calculation field, type Container, Do not evaluate is not checked, to grab the proper color for each record depending upon the status of the record. I'm pulling the color from a repeating Container field in my one record preferences file. The container field is defined with 10 repetitions, but I am currently only using 7 of them. All is well until I need repetition 6. I have a dark grey color at present (but have tried many other colors). The records which should show dark grey do not show any color at all, no matter what I change the color to. All other status entries grab the proper color. I have check the status field to ensure it contains the proper status notation.

At one point when I was trying to get the dark grey color to show, I double-clicked in the 5th repetition of the container field and an audio recording dialog opened. I canceled it. Could this have some bearing on my problem?

I have also re-defined the 10 repetition container field to 5 repetitions, and then changed it back to 10 repetitions. No change, repetition 5 still does not show.

I'm at my wits end. Anyone know what I have done?

Thanks,

Lisa

[-Queue-]

What is your calculation?

[LemlerInv]

Here's my script:

If [ IsEmpty(Checks|number|defendant::mark resolved) and

IsEmpty(Checks|number|defendant::mark deleted) and

IsEmpty(Checks|number|defendant::mark returned) and

IsEmpty(Checks|number|defendant::mark back out) ]

Set Field [ Checks|number|defendant::action paid, 4 ]

Set Field [ Checks|number|defendant::date paid, Status(CurrentDate) ]

Set Field [ Checks|number|defendant::remaining sub, "0.00" ]

Set Field [ Checks|number|defendant::remaining misc, "0.00" ]

Set Field [ Checks|number|defendant::remaining tax, "0.00" ]

Set Field [ Checks|number|defendant::mark deleted, "Yes" ]

Else

If [ not IsEmpty(Checks|number|defendant::mark deleted) ]

Set Field [ Checks|number|defendant::action paid, 0 ]

Set Field [ Checks|number|defendant::remaining sub, Checks|number| defendant::amount of check ]

Set Field [ Checks|number|defendant::remaining misc, Checks|number|defendant::misc ]

Set Field [ Checks|number|defendant::remaining tax, Checks|number|defendant::victim fee ]

Set Field [ Checks|number|defendant::date paid, TextToDate("") ]

Set Field [ Checks|number|defendant::mark deleted, "" ]

End If

End If

Setting the code in the Action Paid field determines the color.

Thanks,

Lisa

[transpower]

What is the actual calculation? Does setting the action paid field to 4 select CalculationRepetitionNumber 4? How?

[LemlerInv]

Well, I just answered my own question.

The problem was that I was basing my colors off of the text field that is filled depending on the code in the code field. After re-writing the field definition that pulls the proper color to be based off the code number itself, I now have dark grey!

Thanks,

Lisa