Conditional Formatting

[Peter Clifton]

Is it possible for conditional formatting to work on related files?

In "File A" I have conditonally formatted a field to show if a  
student's score is above average, and it works fine in that file.
When I attempt to do the same thing in a related file using the data  
from "File A" it fails to work.

Any thoughts?

FMP 9 Advanced
Mac OS 10.4.11


_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Jorge Biquez]

Hello all.

I hope this message does not sound too stupid because of the kind of
questions. Here we go.

1) Any comments based on experience about working with FMPA or FMP
and calls or exchange of information with other languages and
applications?. As and Example, Activex. I see that the documentation
on FMPA 8.0 about Activex is very short. I do not know if that
changes with version 9.

2) I know that's the way FMPA runtimes work and that for FM is their
strategy of business. But, is there a way, not directly I guess, that
a runtime application of FMPA can share, update information with
another applicattion running on FMP/FMPA/FMS ? What I have thought is
to see if I can export all the information needed to update and have
another application , maybe a VB exe or C exe running AS A CRON and
checking if there is new information (in the client side and on the
server or FMP application ) and do the exchange of it.
The thing here is that the runtime have to do that. Maybe a plug in?
no problem if a plug in helps (if it is not too expensive). The main
thing is that the clients will have to be using the runtime version
of FMPA because of costs.

Thanks in advance for all the comments and I'm sorry to those that
could think these are question that are off topic.

Take care

Jorge Biquez


_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Hank Shrier-2]

When you say that a client is concerned about cost, have you looked at
volume license agreements?  You may also consider a web front end. My guess
is the development cost for a when front end will exceed the cost of a VLA.

You may need to build your value proposition.  At the current per seat cot
of a license, how can a company afford to0 hire you and then not be able to
pay for the licenses?

Just a business person's perspective

Hank Shrier  Founder GBN
[phone]                 Office
[phone]                 Cell
[phone]                  Fax
[hidden email]

THIS COMMUNICATION IS LEGALLY PRIVILEGED AND CONFIDENTIAL
This e-mail, and any attachments hereto, is intended only for use by the
addressee(s) named herein.   If you are, or are not, the intended recipient
of this e-mail, you are hereby notified that any dissemination, distribution
or copying of this e-mail, and any attachments hereto, without written
permission, is strictly prohibited. If you have received this email in
error, please immediately notify me and permanently delete the original and
any copy of any e-mail and any printout thereof.


-----Original Message-----
From: [hidden email]
[mailto:[hidden email]] On Behalf Of Jorge Biquez
Sent: Saturday, July 05, 2008 6:15 AM
To: [hidden email]
Subject: FMPA Runtimes, Activex & More
Importance: High

Hello all.

I hope this message does not sound too stupid because of the kind of
questions. Here we go.

1) Any comments based on experience about working with FMPA or FMP
and calls or exchange of information with other languages and
applications?. As and Example, Activex. I see that the documentation
on FMPA 8.0 about Activex is very short. I do not know if that
changes with version 9.

2) I know that's the way FMPA runtimes work and that for FM is their
strategy of business. But, is there a way, not directly I guess, that
a runtime application of FMPA can share, update information with
another applicattion running on FMP/FMPA/FMS ? What I have thought is
to see if I can export all the information needed to update and have
another application , maybe a VB exe or C exe running AS A CRON and
checking if there is new information (in the client side and on the
server or FMP application ) and do the exchange of it.
The thing here is that the runtime have to do that. Maybe a plug in?
no problem if a plug in helps (if it is not too expensive). The main
thing is that the clients will have to be using the runtime version
of FMPA because of costs.

Thanks in advance for all the comments and I'm sorry to those that
could think these are question that are off topic.

Take care

Jorge Biquez


_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Patrick Neame]

I have it working between tables. But the two tables are in the same  
file.

FM9A and 10.5.4


Patrick Neame
www.incamera.co.uk  - 07 957 463 933



On Jul 5, 2008, at 2:00 am, Peter Clifton wrote:

> Is it possible for conditional formatting to work on related files?
>
> In "File A" I have conditonally formatted a field to show if a  
> student's score is above average, and it works fine in that file.
> When I attempt to do the same thing in a related file using the data  
> from "File A" it fails to work.
>
> Any thoughts?
>
> FMP 9 Advanced
> Mac OS 10.4.11
>
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Jorge Biquez]

Hello.

Yes you are right. Thing is that I am not getting a cent from this
job, this is for a Non-Profit organization. A collegue of girls
without parents. They have no extra resources at all besides survive.
We got some used computers that run W2000. That's all.

That's why I would like to spend the less on the plug ins if available


JB

At 10:41 p.m. 04/07/2008, Hank Shrier wrote:

>When you say that a client is concerned about cost, have you looked at
>volume license agreements?  You may also consider a web front end. My guess
>is the development cost for a when front end will exceed the cost of a VLA.
>
>You may need to build your value proposition.  At the current per seat cot
>of a license, how can a company afford to0 hire you and then not be able to
>pay for the licenses?
>
>Just a business person's perspective
>
>Hank Shrier  Founder GBN
>[phone]                 Office
>[phone]                 Cell
>[phone]                  Fax
>[hidden email]
>
>THIS COMMUNICATION IS LEGALLY PRIVILEGED AND CONFIDENTIAL
>This e-mail, and any attachments hereto, is intended only for use by the
>addressee(s) named herein.   If you are, or are not, the intended recipient
>of this e-mail, you are hereby notified that any dissemination, distribution
>or copying of this e-mail, and any attachments hereto, without written
>permission, is strictly prohibited. If you have received this email in
>error, please immediately notify me and permanently delete the original and
>any copy of any e-mail and any printout thereof.
>
>
>-----Original Message-----
>From: [hidden email]
>[mailto:[hidden email]] On Behalf Of Jorge Biquez
>Sent: Saturday, July 05, 2008 6:15 AM
>To: [hidden email]
>Subject: FMPA Runtimes, Activex & More
>Importance: High
>
>Hello all.
>
>I hope this message does not sound too stupid because of the kind of
>questions. Here we go.
>
>1) Any comments based on experience about working with FMPA or FMP
>and calls or exchange of information with other languages and
>applications?. As and Example, Activex. I see that the documentation
>on FMPA 8.0 about Activex is very short. I do not know if that
>changes with version 9.
>
>2) I know that's the way FMPA runtimes work and that for FM is their
>strategy of business. But, is there a way, not directly I guess, that
>a runtime application of FMPA can share, update information with
>another applicattion running on FMP/FMPA/FMS ? What I have thought is
>to see if I can export all the information needed to update and have
>another application , maybe a VB exe or C exe running AS A CRON and
>checking if there is new information (in the client side and on the
>server or FMP application ) and do the exchange of it.
>The thing here is that the runtime have to do that. Maybe a plug in?
>no problem if a plug in helps (if it is not too expensive). The main
>thing is that the clients will have to be using the runtime version
>of FMPA because of costs.
>
>Thanks in advance for all the comments and I'm sorry to those that
>could think these are question that are off topic.
>
>Take care
>
>Jorge Biquez
>
>
>_______________________________________________
>FMPexperts mailing list
>[hidden email]
>http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>
>_______________________________________________
>FMPexperts mailing list
>[hidden email]
>http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Jonathan Fletcher]

Ah!

OK, IWP it is.

j.


On Jul 5, 2008, at 9:42 AM, Jorge Biquez wrote:

> Hello.
>
> Yes you are right. Thing is that I am not getting a cent from this  
> job, this is for a Non-Profit organization. A collegue of girls  
> without parents. They have no extra resources at all besides  
> survive. We got some used computers that run W2000. That's all.
>
> That's why I would like to spend the less on the plug ins if available
>
>
> JB
>
> At 10:41 p.m. 04/07/2008, Hank Shrier wrote:
>> When you say that a client is concerned about cost, have you looked  
>> at
>> volume license agreements?  You may also consider a web front end.  
>> My guess
>> is the development cost for a when front end will exceed the cost  
>> of a VLA.
>>
>> You may need to build your value proposition.  At the current per  
>> seat cot
>> of a license, how can a company afford to0 hire you and then not be  
>> able to
>> pay for the licenses?
>>
>> Just a business person's perspective
>>
>> Hank Shrier  Founder GBN
>> [phone]                 Office
>> [phone]                 Cell
>> [phone]                  Fax
>> [hidden email]
>>
>> THIS COMMUNICATION IS LEGALLY PRIVILEGED AND CONFIDENTIAL
>> This e-mail, and any attachments hereto, is intended only for use  
>> by the
>> addressee(s) named herein.   If you are, or are not, the intended  
>> recipient
>> of this e-mail, you are hereby notified that any dissemination,  
>> distribution
>> or copying of this e-mail, and any attachments hereto, without  
>> written
>> permission, is strictly prohibited. If you have received this email  
>> in
>> error, please immediately notify me and permanently delete the  
>> original and
>> any copy of any e-mail and any printout thereof.
>>
>>
>> -----Original Message-----
>> From: [hidden email]
>> [mailto:[hidden email]] On Behalf Of  
>> Jorge Biquez
>> Sent: Saturday, July 05, 2008 6:15 AM
>> To: [hidden email]
>> Subject: FMPA Runtimes, Activex & More
>> Importance: High
>>
>> Hello all.
>>
>> I hope this message does not sound too stupid because of the kind of
>> questions. Here we go.
>>
>> 1) Any comments based on experience about working with FMPA or FMP
>> and calls or exchange of information with other languages and
>> applications?. As and Example, Activex. I see that the documentation
>> on FMPA 8.0 about Activex is very short. I do not know if that
>> changes with version 9.
>>
>> 2) I know that's the way FMPA runtimes work and that for FM is their
>> strategy of business. But, is there a way, not directly I guess, that
>> a runtime application of FMPA can share, update information with
>> another applicattion running on FMP/FMPA/FMS ? What I have thought is
>> to see if I can export all the information needed to update and have
>> another application , maybe a VB exe or C exe running AS A CRON and
>> checking if there is new information (in the client side and on the
>> server or FMP application ) and do the exchange of it.
>> The thing here is that the runtime have to do that. Maybe a plug in?
>> no problem if a plug in helps (if it is not too expensive). The main
>> thing is that the clients will have to be using the runtime version
>> of FMPA because of costs.
>>
>> Thanks in advance for all the comments and I'm sorry to those that
>> could think these are question that are off topic.
>>
>> Take care
>>
>> Jorge Biquez
>>
>>
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>>
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

--
Jonathan Fletcher
[hidden email]
Project Foreman
NewMedia Construction Co.


_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[coolcat]

On 7/4/2008 6:00 PM, "Peter Clifton" <[hidden email]> wrote:

> In "File A" I have conditonally formatted a field to show if a
> student's score is above average, and it works fine in that file.
> When I attempt to do the same thing in a related file using the data
> from "File A" it fails to work.

Are you sure you're using a 'good' relation? (See if other 'related' calcs
are showing up using that T.O.)

>
> Any thoughts?


--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists]



_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Leland Long-2]

Yes, I have had good sucess with runtimes exchanging data with served  
data on FMP and FMS. The theory is using web viewers to send data to a  
Php web page using GET variables in a URL, then the web page receiving  
the data sends it to FMP/S via php/FX as a new record or an edit. Data  
from the server can be sent to the runtime using another php page to  
generate a query, then echo'd to the web page and the HTML source  
scraped all in a script.

A lot of extra effort, but can work beautifully if managed properly.  
Great for smaller solitions!

Sent from my iPhone

On Jul 5, 2008, at 9:42, Jorge Biquez <[hidden email]> wrote:

> Hello.
>
> Yes you are right. Thing is that I am not getting a cent from this  
> job, this is for a Non-Profit organization. A collegue of girls  
> without parents. They have no extra resources at all besides  
> survive. We got some used computers that run W2000. That's all.
>
> That's why I would like to spend the less on the plug ins if available
>
>
> JB
>
> At 10:41 p.m. 04/07/2008, Hank Shrier wrote:
>> When you say that a client is concerned about cost, have you looked  
>> at
>> volume license agreements?  You may also consider a web front end.  
>> My guess
>> is the development cost for a when front end will exceed the cost  
>> of a VLA.
>>
>> You may need to build your value proposition.  At the current per  
>> seat cot
>> of a license, how can a company afford to0 hire you and then not be  
>> able to
>> pay for the licenses?
>>
>> Just a business person's perspective
>>
>> Hank Shrier  Founder GBN
>> [phone]                 Office
>> [phone]                 Cell
>> [phone]                  Fax
>> [hidden email]
>>
>> THIS COMMUNICATION IS LEGALLY PRIVILEGED AND CONFIDENTIAL
>> This e-mail, and any attachments hereto, is intended only for use  
>> by the
>> addressee(s) named herein.   If you are, or are not, the intended  
>> recipient
>> of this e-mail, you are hereby notified that any dissemination,  
>> distribution
>> or copying of this e-mail, and any attachments hereto, without  
>> written
>> permission, is strictly prohibited. If you have received this email  
>> in
>> error, please immediately notify me and permanently delete the  
>> original and
>> any copy of any e-mail and any printout thereof.
>>
>>
>> -----Original Message-----
>> From: [hidden email]
>> [mailto:[hidden email]] On Behalf Of  
>> Jorge Biquez
>> Sent: Saturday, July 05, 2008 6:15 AM
>> To: [hidden email]
>> Subject: FMPA Runtimes, Activex & More
>> Importance: High
>>
>> Hello all.
>>
>> I hope this message does not sound too stupid because of the kind of
>> questions. Here we go.
>>
>> 1) Any comments based on experience about working with FMPA or FMP
>> and calls or exchange of information with other languages and
>> applications?. As and Example, Activex. I see that the documentation
>> on FMPA 8.0 about Activex is very short. I do not know if that
>> changes with version 9.
>>
>> 2) I know that's the way FMPA runtimes work and that for FM is their
>> strategy of business. But, is there a way, not directly I guess, that
>> a runtime application of FMPA can share, update information with
>> another applicattion running on FMP/FMPA/FMS ? What I have thought is
>> to see if I can export all the information needed to update and have
>> another application , maybe a VB exe or C exe running AS A CRON and
>> checking if there is new information (in the client side and on the
>> server or FMP application ) and do the exchange of it.
>> The thing here is that the runtime have to do that. Maybe a plug in?
>> no problem if a plug in helps (if it is not too expensive). The main
>> thing is that the clients will have to be using the runtime version
>> of FMPA because of costs.
>>
>> Thanks in advance for all the comments and I'm sorry to those that
>> could think these are question that are off topic.
>>
>> Take care
>>
>> Jorge Biquez
>>
>>
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>>
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Darren Terry-3]

On Jul 4, 2008, at 6:00 PM, Peter Clifton wrote:

> Is it possible for conditional formatting to work on related files?
>
> In "File A" I have conditonally formatted a field to show if a  
> student's score is above average, and it works fine in that file.
> When I attempt to do the same thing in a related file using the  
> data from "File A" it fails to work.
>
> Any thoughts?

What is the formula, Peter?  And which precise version of FM is this?

If the formula uses the Self function, and if the field being  
conditionally formatted is indeed from another file (through an  
external file reference), then it will not work due to a bug in FM.  
Don't use Self -- instead hard-code the field's name into the  
conditional formatting formula, and it should work.

regards,
Darren

******************************
  Darren Terry                               [hidden email]
  Pacific Data Management, Inc.              http://www.pdm-inc.com/
  111 W. St. John St.                      Phone: [phone] x303
  Suite 404                                  Fax:   [phone]
  San Jose, CA 95113
***** FileMaker 9 Certified Developer *****



_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Bob Patin]

Also, keep in mind that self() only works in FM9...

Bob Patin
Longterm Solutions
[hidden email]
615-333-6858
http://www.longtermsolutions.com
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet

   INSTANT MESSAGING:
      AIM or iChat: longterm1954

--------------------------
Contact us for FileMaker hosting and programming for all versions of  
FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting

On Jul 7, 2008, at 3:28 PM, Darren Terry wrote:

> If the formula uses the Self function, and if the field being  
> conditionally formatted is indeed from another file (through an  
> external file reference), then it will not work due to a bug in FM.  
> Don't use Self -- instead hard-code the field's name into the  
> conditional formatting formula, and it should work.

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Lee Smith-5]

That's because conditional formatting is only available in v9.


On Jul 7, 2008, at 3:40 PM, Bob Patin wrote:

> Also, keep in mind that self() only works in FM9...
>
> Bob Patin
> Longterm Solutions
> [hidden email]
> 615-333-6858
> http://www.longtermsolutions.com
> FileMaker 9 Certified Developer
> Member of FileMaker Business Alliance and FileMaker TechNet
>
>  INSTANT MESSAGING:
>     AIM or iChat: longterm1954
>
> --------------------------
> Contact us for FileMaker hosting and programming for all versions of  
> FileMaker
> PHP • Full email services • Free DNS hosting • Colocation • Consulting
>
> On Jul 7, 2008, at 3:28 PM, Darren Terry wrote:
>
>> If the formula uses the Self function, and if the field being  
>> conditionally formatted is indeed from another file (through an  
>> external file reference), then it will not work due to a bug in FM.  
>> Don't use Self -- instead hard-code the field's name into the  
>> conditional formatting formula, and it should work.
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Bob Patin]

On Jul 7, 2008, at 5:56 PM, Lee Smith wrote:

> That's because conditional formatting is only available in v9.

Respectfully speaking, I'm not understanding what that has to do with  
the self() function; yes, they both came out in 9... ??

I mentioned the self() function because one of my clients, who has  
both 9 and 8.5 on his Macs, tried using self(), only to realize  
eventually that his calc wouldn't work on his v8.5 machines.

It's such a great new function, I've been tempted to use it too in  
solutions that aren't guaranteed to be run only in 9.

Bob Patin
Longterm Solutions
[hidden email]
615-333-6858
http://www.longtermsolutions.com
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet

   INSTANT MESSAGING:
      AIM or iChat: longterm1954

--------------------------
Contact us for FileMaker hosting and programming for all versions of  
FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting






_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[coolcat]

On 7/7/2008 1:28 PM, "Darren Terry" <[hidden email]> wrote:

> What is the formula, Peter?  And which precise version of FM is this?
>
> If the formula uses the Self function, and if the field being
> conditionally formatted is indeed from another file (through an
> external file reference), then it will not work due to a bug in FM.
> Don't use Self -- instead hard-code the field's name into the
> conditional formatting formula, and it should work.

- For what it's worth .. Here's an email from another list - showing a
problem with Conditional Formatting...

Subject: Problem With Conditional Formatting?

Hello folks,

Using FileMaker 9.03 - Mac

I might have found problem with conditional formatting. I added some simple
conditional formatting to a number field, and afterward it seemed to break a
script that was doing a simple find on that field ( using insert calculated
result ).

This seemed kind of weird so I created a little test file that you can
download here:

http://www.brainbeast.com/fmp/conditional_test.fp7.zip


It seems there a problem with FileMaker conditional formatting...

--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists]



_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Lorne & Joan Walton]

Interesting. It does work if the "Insert" is replaced with "Set Field".

On Jul 7, 2008, at 5:15 PM, revDAVE wrote:

> It seems there a problem with FileMaker conditional formatting...

--
If you're not part of the solution, you're part of the precipitate.
Lorne Walton, Maple Ridge, BC, Canada

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Richard DeShong]

Maybe the "Insert" data is being processed by the conditional formatting
rules, whereas the "Set Field" data is not?

--
Richard DeShong, Athletic Study Center, UCBerkeley

-----Original Message-----
From: Lorne & Joan Walton

Interesting. It does work if the "Insert" is replaced with "Set Field".

On Jul 7, 2008, at 5:15 PM, revDAVE wrote:

> It seems there a problem with FileMaker conditional formatting...

--
If you're not part of the solution, you're part of the precipitate.
Lorne Walton, Maple Ridge, BC, Canada

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au


_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Molson]

coolcat wrote:

http://www.brainbeast.com/fmp/conditional_test.fp7.zip

It seems there a problem with FileMaker conditional formatting...

You can use the Insert Calculated Result in the script if you change the formula for the condition to use Self [Self>"1"] rather than aaa::num >1.

Seems to be a combination of the formula used in the Insert step and the formula for the condition.

BTW, the error that is generated when the Insert step fails [and that is the failure] is 102: Field Missing.

Michele

[Peter Clifton]

Peter Clifton

>
> On Jul 4, 2008, at 6:00 PM, Peter Clifton wrote:
>
>> Is it possible for conditional formatting to work on related files?
>>
>> In "File A" I have conditonally formatted a field to show if a  
>> student's score is above average, and it works fine in that file.
>> When I attempt to do the same thing in a related file using the  
>> data from "File A" it fails to work.
>>
>> Any thoughts?
>
> What is the formula, Peter?  And which precise version of FM is this?
>
> If the formula uses the Self function, and if the field being  
> conditionally formatted is indeed from another file (through an  
> external file reference), then it will not work due to a bug in  
> FM.  Don't use Self -- instead hard-code the field's name into the  
> conditional formatting formula, and it should work.
>
> regards,
> Darren
>

Thanks to everyone for all the replies.

I am not using the Self function, the field being conditionally  
formatted is from another file, through an external file reference.  
(Works fine in that file)

Version 9.0v3 Adv. Mac OS 10.4.11

The formula I'm using is......... Related File:Test Score  > Related  
File: Test Average

The relationship between the two files is based on the Students  
name.  All other related calcs work fine.

Appreciate all the advice.
Regards,

Peter




_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Richard DeShong]

When I create a relationship to a table in another file (an "external
table"), and then use conditional formatting, formula, and reference fields
in the external table, the conditional formatting works.  So I was wondering
if one or both fields you are trying to use are actually stored in your
external?  Of suspicion would be your "Test Average" field.  Where is that
number coming from?  Is it a stored field in each student record?

--
Richard DeShong
IT Services, City of Piedmont
510-642-5123 Office
925-285-1088 Cell

-----Original Message-----
From: Peter Clifton

I am not using the Self function, the field being conditionally  
formatted is from another file, through an external file reference.  
(Works fine in that file)

Version 9.0v3 Adv. Mac OS 10.4.11

The formula I'm using is......... Related File:Test Score  > Related  
File: Test Average

The relationship between the two files is based on the Students  
name.  All other related calcs work fine.

>
> On Jul 4, 2008, at 6:00 PM, Peter Clifton wrote:
>
>> Is it possible for conditional formatting to work on related files?
>>
>> In "File A" I have conditonally formatted a field to show if a  
>> student's score is above average, and it works fine in that file.
>> When I attempt to do the same thing in a related file using the  
>> data from "File A" it fails to work.
>>
>> Any thoughts?
>
> What is the formula, Peter?  And which precise version of FM is this?
>
> If the formula uses the Self function, and if the field being  
> conditionally formatted is indeed from another file (through an  
> external file reference), then it will not work due to a bug in  
> FM.  Don't use Self -- instead hard-code the field's name into the  
> conditional formatting formula, and it should work.
>
> regards,
> Darren
>

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Peter Clifton]

Hi Richard,

The "Test Average" is a Summary field (Average of "Test Score").
"Test Score" is a Calculation Field ......  Int ( Test Raw Score / .
25 ) & "%"


"Test  Average" is stored in each student record in the external file.

I tried referencing "Test Raw Score" field as well, thinking that may  
be the problem, but without success.

Regards,
Peter

On 09/07/2008, at 11:13, Richard DeShong wrote:

> When I create a relationship to a table in another file (an "external
> table"), and then use conditional formatting, formula, and  
> reference fields
> in the external table, the conditional formatting works.  So I was  
> wondering
> if one or both fields you are trying to use are actually stored in  
> your
> external?  Of suspicion would be your "Test Average" field.  Where  
> is that
> number coming from?  Is it a stored field in each student record?
>
> --
> Richard DeShong
> IT Services, City of Piedmont
> 510-642-5123 Office
> 925-285-1088 Cell
>
> -----Original Message-----
> From: Peter Clifton
>
> I am not using the Self function, the field being conditionally
> formatted is from another file, through an external file reference.
> (Works fine in that file)
>
> Version 9.0v3 Adv. Mac OS 10.4.11
>
> The formula I'm using is......... Related File:Test Score  > Related
> File: Test Average
>
> The relationship between the two files is based on the Students
> name.  All other related calcs work fine.
>>
>> On Jul 4, 2008, at 6:00 PM, Peter Clifton wrote:
>>
>>> Is it possible for conditional formatting to work on related files?
>>>
>>> In "File A" I have conditonally formatted a field to show if a
>>> student's score is above average, and it works fine in that file.
>>> When I attempt to do the same thing in a related file using the
>>> data from "File A" it fails to work.
>>>
>>> Any thoughts?
>>
>> What is the formula, Peter?  And which precise version of FM is this?
>>
>> If the formula uses the Self function, and if the field being
>> conditionally formatted is indeed from another file (through an
>> external file reference), then it will not work due to a bug in
>> FM.  Don't use Self -- instead hard-code the field's name into the
>> conditional formatting formula, and it should work.
>>
>> regards,
>> Darren
>>
>
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Richard DeShong]

Peter,
When you say that "Test Average" is a Summary field, then I am not clear
what you mean.  I use Summary fields to display data in Preview mode on
reports.  My understanding is that they don't have a value in Browse mode.
If you have a Student rcd that is related to multiple Test rcds, then I
think you would want a Calculation field in the Student rcd that uses the
Average function to calc the avg of all of the related Test::Score values.

Also, as a test, consider simplifying your conditional formatting.  How
about just using a "if Test Average is about a certain number" test?  Maybe
you are not "seeing" the correct Test Average value.

--
Richard DeShong, Athletic Study Center, UCBerkeley

-----Original Message-----
From: Peter Clifton

The "Test Average" is a Summary field (Average of "Test Score").
"Test Score" is a Calculation Field ......  Int ( Test Raw Score / .
25 ) & "%"

"Test  Average" is stored in each student record in the external file.

I tried referencing "Test Raw Score" field as well, thinking that may  
be the problem, but without success.

Regards,
Peter

On 09/07/2008, at 11:13, Richard DeShong wrote:

> When I create a relationship to a table in another file (an "external
> table"), and then use conditional formatting, formula, and  
> reference fields
> in the external table, the conditional formatting works.  So I was  
> wondering
> if one or both fields you are trying to use are actually stored in  
> your
> external?  Of suspicion would be your "Test Average" field.  Where  
> is that
> number coming from?  Is it a stored field in each student record?
>
> --
> Richard DeShong
> IT Services, City of Piedmont
> 510-642-5123 Office
> 925-285-1088 Cell
>
> -----Original Message-----
> From: Peter Clifton
>
> I am not using the Self function, the field being conditionally
> formatted is from another file, through an external file reference.
> (Works fine in that file)
>
> Version 9.0v3 Adv. Mac OS 10.4.11
>
> The formula I'm using is......... Related File:Test Score  > Related
> File: Test Average
>
> The relationship between the two files is based on the Students
> name.  All other related calcs work fine.
>>
>> On Jul 4, 2008, at 6:00 PM, Peter Clifton wrote:
>>
>>> Is it possible for conditional formatting to work on related files?
>>>
>>> In "File A" I have conditonally formatted a field to show if a
>>> student's score is above average, and it works fine in that file.
>>> When I attempt to do the same thing in a related file using the
>>> data from "File A" it fails to work.
>>>
>>> Any thoughts?
>>
>> What is the formula, Peter?  And which precise version of FM is this?
>>
>> If the formula uses the Self function, and if the field being
>> conditionally formatted is indeed from another file (through an
>> external file reference), then it will not work due to a bug in
>> FM.  Don't use Self -- instead hard-code the field's name into the
>> conditional formatting formula, and it should work.
>>
>> regards,
>> Darren
>>
>
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au


_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au