Re: Multi-join relationships?

On Sep 28, 2005, at 7:25 AM, Ugo Di Luca wrote:

> First of all, may be I should ask some enligthment on what exactly  
> is a PriceSheet in your mind.
> Is it a grid, is it tied to a Customer, a Date Range ?
>
> Having the Price Sheet in Invoice actually doesn't seem natural *to  
> me*.
> Price Sheet would be pulled into the Line Items from the beginning.
> If one day you inherit a system where before Invoices are Quotes  
> and Orders and Deliveries,
> well the same Price Sheet should apply for all successive documents  
> leading to any final Invoice.
>

Price Sheet is a separate table from Invoice. Each invoice is  
assigned to a price sheet, either automatically based on date, or  
manually in case of an override. The prices can't be pulled into line  
items at the time of creation because the price might change. This  
isn't a standard invoice system. Comparisons will be done after the  
fact. More than one price sheet will be used. So I should have said  
that Invoice has a many-to-many relation to Price Sheet, not a many- 
to-one.

But for reporting purposes, the relationship needs to be from Line  
Items into the Price Sheet table, based on the (multiple) foreign  
keys into Price Sheet stored in the Invoice table.

regards,

Re: Position of Hyphen

Though long, this calc should do it:

Case(IsEmpty(FN), "",

    Case(PatternCount(FN, "-"),

        Left(FN, 1) & "." &
        Middle(FN, Position(FN, " ", 1, 1) + 1, 1) &
        Middle(FN, Position(FN, "-", 1, 1) + 1, 1) & ".",

        Left(FN, 1) & "." &
        Left(RightWords(FN, 1),1) & ".")

)

where FN is the FullName field....

hth,

Bart

Bart Bartholomay
HAB Marketing
3725 8th Lane
Vero Beach, FL 32960

Colm Osiris wrote:

> Dan
>

Re: Position of Hyphen

Dan,

If you use the Substitute function to change the hyphen to a space  
then you can take advantage of the MiddleWords function to (arguably)  
simplify the calculation:

Case( not IsEmpty( FullName ), Left( FullName,1 ) & "." ) &

Case( WordCount( FullName ) > 1, Left( MiddleWords( Substitute 
( FullName, "-", " " ), 2, 1 ), 1 ) & Left( MiddleWords( Substitute 
( FullName, "-", " " ), 3, 1 ), 1 ) &  "." )

Greg

On Sep 30, 2005, at 1:15 PM, Dan Walker wrote:

> I have a field called FullName that has the first and last names of  
> some people. I want to create another field for the initials. I'm  
> ok when I grab the first letter of each word but I have a specific  
> need.
>
> If the person's name is Mary Brown, I want the initials field to be  
> calculated as M.B.
> If the person has a hyphenated last name like Mary Brown-Gibson, I  
> want the initials field to be calculated as M.BG.
>
> Any thoughts? The calculation eludes me. I know I need to find the  
> position of the hyphen and add 1, but the more I try, the more it  
> doesn't work.

Re: Export records to a specific folder

Hi  Richard

> I have an FMP database/Web companion application that exports  
> records to
> text file in a specific folder. When I run this script on a  
> database on
> my own workstation, the database knows into which folder to export the
> records. When I upload the database and folder to my commercial  
> database
> hosting company (Digital Forest) the database exports the records  
> to the
> same folder in which the database resides.
>
> How do I specify the folder into which the records need to be exported
> in this script?
You can re-point the script to export to a specific folder on the  
machine acting as Web server, the one with Web Companion/FMU

Ciao
G. Pupita
Certified FileMaker 7 Developer
FSA Associate

Re: Tooltips glitch? FMA8

Hi Bill,
On Sep 29, 2005, at 5:08 PM, Bill Holt wrote:

> I've run across a minor irritation on a current project.  The setup:  
> in List view, with half dozen fields aligned horizontally so that the 
> list shows one line per record, each line showing half dozen values 
> from that record.  This list is for navigation, not data input.  In 
> any case, I define each of the half dozen fields as a button; each 
> having its particular tooltip.  However, when I point at the first 
> field, and see that tip, and then shift to the second field expecting 
> to see tip number two, the first tooltip is repeated.  In fact, until 
> I pull completely away from all of the fields for a second, the 
> tooltip message for the first field is the only one that will show up. 
>  If I start with the second field and allow its tip to display, the 
> procedure starts again with the second message being displayed for all 
> of the fields ... until I pull completely away from the fields.

I have a similar list layout in a current solution I working on. It is 
set with fields as buttons and different tooltips attached to each. I 
am not seeing the behavior you describe. The tooltip changes the minute 
my cursor moves over the next field. The fields are set with 1 pixel 
between them.

Mac OSX 10.3.8  FMPA 8.0v1

Have you tested on a different platform?

On Sep 30, 2005, at 9:11 AM, Bill Holt wrote:

> Look for a fix in 8.01, perhaps.

[Ann]Professional Buttons for FileMaker Ends today

Our Professional Series of Buttons and Icons sale ends today!

http://www.fmwebschool.com/buttons_v6.php

In Kindness
Stephen K. Knight
www.fmwebschool.com
1-800-353-7950
Professional FileMaker Web Services

Different behaviour of calculations on related fields in FMP8 vs FMP7

Hi Experts,

I came across a strange behaviour of FMP8.
I have a layout with a portal displaying related records (Lines).
I want to get the value of Sum(Lines::amount).

I discovered that the value is NOT returned by FMP8 when a related  
field in portal Lines is selected. Instead I get a "?".
This was not the case on FMP7.
Is that a known fact ? Or do I have a corrupt file ?

FMP8Advanced, Mac OS 10.4.2
-
Arnaud

Re: Different behaviour of calculations on related fields in FMP8 vs FMP7

Re: Different behaviour of calculations on related fields in FMP8 vs FMP7

Re: Different behaviour of calculations on related fields in FMP8 vs FMP7

Hi Arnaud,

In the "FMPA Read Me (English).pdf" file, item 2.2 (under Calculations) says that aggregate functions
from within a portal operate from the portal context.  This allows you to select a portal row and perform a
count to a table farther away and receive the count only for that portal row's related records.

This is a change of behaviour from FM 7 and explains what you are now seeing.

Regards,
Jason L. DeLooze
Annapolis, MD  USA

On 10/1/05 at 21:19 +0200, Budarno Bt wrote:
Nope, the debugger says "unrelated table". FMP8 behaves as if the context was related to the portal, not the layout.

Le 1 oct. 05 à 20:09, Michael Westendorf a écrit :

Just a guess, cause I am no expert but the only times I recall seeing a question mark is when the field box is not
long enough to display the results, check to see if the number field is setup to display only x amount of decimals.
Hope this helps,

Mike

On 10/1/05, Budarno Bt
<<mailto:budarno@...>budarno@...> wrote:

Hi Experts,

I came across a strange behaviour of FMP8.
I have a layout with a portal displaying related records (Lines).
I want to get the value of Sum(Lines::amount).

I discovered that the value is NOT returned by FMP8 when a related
field in portal Lines is selected. Instead I get a "?".
This was not the case on FMP7.
Is that a known fact ? Or do I have a corrupt file ?

FMP8Advanced, Mac OS 10.4.2
-
Arnaud

--
To unsubscribe: send an email to <<mailto:fmpexperts-off@...>fmpexperts-off@...>
FMPexperts is hosted by Ironclad Networks <<http://www.ironclad.net.au/> http://www.ironclad.net.au/>

--
Michael Westendorf