Summerizing text field

[Salman Maidan-2]

Hello Experts,

 

FMPA 9v3            WinXp-sp2

 

I have two tables, an interface calendar table related to a many visits
table and  the relating fields are dates only. In a portal I can see all the
related visits, my dilemma is some of these visits carry the same data

 

i.e on 09-01-08

 

visit A contact A

visit A contact B

visit A contact C

visit B contact D

visit B contact E

visit B contact F

 

How can I have the portal (or a different portal) to summarize the visits
and show the following:

 

Visit A 3 contacts ABC

Visit B 3 contacts DEF

 

Can anyone help me with this please.

TIA

___________

Regards

Salman Maidan

 

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Steve Cassidy-3]

Hi Salman

I think this is going to be a tricky one ;)

Looking at your data, one might suggest that you have a structure  
that is not optimum for obtaining this kind of display. In fact, you  
don't really have the Visits table that you describe (which would  
have one record for visit A on 09-01-08 and one record for visit B on  
09-01-08). Rather you have a Visit-Contacts table. If you did have a  
structure that included a Visits table, I think obtaining your  
required display would be almost automatic. That is,

Interface –< Visits –< Visit-Contacts

Visits would have fields for summing the number of Visit-Contacts  
records and for Listing the contact letter. These fields would then  
be easily displayed in a portal in Interface.

With your present structure... Well, could possibly come up with a  
way to accomplish what you want with some self-relations and  
calculations. But I think I'll leave the details to superior minds :)  
Alternatively, I think you could script the desired result (or  
perhaps better script the populating of a true Visits table, as above).

I could be wrong of course...

HTH

Steve




On 2 Sep 2008, at 18:23, salman Maidan wrote:

> How can I have the portal (or a different portal) to summarize the  
> visits
> and show the following:
>
>
>
> Visit A 3 contacts ABC
>
> Visit B 3 contacts DEF
>
>
>
> Can anyone help me with this please.

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Salman Maidan-2]

Thanks Steve,

You make perfect since, however as you say I will wait for more superior
minds :-)


___________
Regards
Salman Maidan

-----Original Message-----
From: fmpexperts-bounces@...
[mailto:fmpexperts-bounces@...] On Behalf Of Steve Cassidy
Sent: Tuesday, September 02, 2008 8:42 PM
To: fmpexperts@...
Subject: Re: Summerizing text field

Hi Salman

I think this is going to be a tricky one ;)

Looking at your data, one might suggest that you have a structure  
that is not optimum for obtaining this kind of display. In fact, you  
don't really have the Visits table that you describe (which would  
have one record for visit A on 09-01-08 and one record for visit B on  
09-01-08). Rather you have a Visit-Contacts table. If you did have a  
structure that included a Visits table, I think obtaining your  
required display would be almost automatic. That is,

Interface -< Visits -< Visit-Contacts

Visits would have fields for summing the number of Visit-Contacts  
records and for Listing the contact letter. These fields would then  
be easily displayed in a portal in Interface.

With your present structure... Well, could possibly come up with a  
way to accomplish what you want with some self-relations and  
calculations. But I think I'll leave the details to superior minds :)  
Alternatively, I think you could script the desired result (or  
perhaps better script the populating of a true Visits table, as above).

I could be wrong of course...

HTH

Steve




On 2 Sep 2008, at 18:23, salman Maidan wrote:

> How can I have the portal (or a different portal) to summarize the  
> visits
> and show the following:
>
>
>
> Visit A 3 contacts ABC
>
> Visit B 3 contacts DEF
>
>
>
> Can anyone help me with this please.

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Kevin Frank]

Hi Salman,

Take a look at http://www.kevinfrank.com/dig-fm/kf-donations.zip  --
there are two files in there, and both of them show a technique for
accomplishing this. You only need to open one of the two files,
because the same technique is used in both. Once you have one of the
files open, click the reports button, and you'll see that for a
user-enterable date range, there are two portals:

A. The first shows your typical "donations in this date range" -- ignore that.

B. The second one on the page shows unique *donors* with the count
and total dollar amount. That's the one you want to take a look at.

Note: This technique is very "context sensitive". The date key(s)
must be in the donor (or in your case "contacts") table... and the
layout the portals appear on must also be attached to a specific TO
of the donor (or in your case "contacts") table. Take a look at the
section of the graph labeled "reporting / filtering / querying", and
the preceding should make more sense. Since I used color coding for
processes, rather than to identify base tables, all the TOs in that
section are aqua colored, but I indicate the base table in the TO
name by placing it inside braces, e.g., "date filtered {donations}
per unique donor".

Good Luck and HTH,
Kevin


At 10:23 AM 9/2/2008, salman Maidan wrote:
>How can I have the portal (or a different portal) to summarize the visits
>and show the following:
>
>
>Visit A 3 contacts ABC
>
>Visit B 3 contacts DEF
>
>Can anyone help me with this please.


===========================================================
Kevin Frank & Associates     Email:  kfrank@...
Voice:  707-822-6414         Web:    www.kevinfrank.com
===========================================================
FileMaker 7 & 8 Certified Developer

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Salman Maidan-2]

Thanks Kevin,
I looked at that file, it helped a great deal, thanks for your troubles.

___________
Regards
Salman Maidan

-----Original Message-----
From: fmpexperts-bounces@...
[mailto:fmpexperts-bounces@...] On Behalf Of Kevin Frank
Sent: Tuesday, September 02, 2008 9:13 PM
To: fmpexperts@...
Subject: Re: Summerizing text field

Hi Salman,

Take a look at http://www.kevinfrank.com/dig-fm/kf-donations.zip  --
there are two files in there, and both of them show a technique for
accomplishing this. You only need to open one of the two files,
because the same technique is used in both. Once you have one of the
files open, click the reports button, and you'll see that for a
user-enterable date range, there are two portals:

A. The first shows your typical "donations in this date range" -- ignore
that.

B. The second one on the page shows unique *donors* with the count
and total dollar amount. That's the one you want to take a look at.

Note: This technique is very "context sensitive". The date key(s)
must be in the donor (or in your case "contacts") table... and the
layout the portals appear on must also be attached to a specific TO
of the donor (or in your case "contacts") table. Take a look at the
section of the graph labeled "reporting / filtering / querying", and
the preceding should make more sense. Since I used color coding for
processes, rather than to identify base tables, all the TOs in that
section are aqua colored, but I indicate the base table in the TO
name by placing it inside braces, e.g., "date filtered {donations}
per unique donor".

Good Luck and HTH,
Kevin


At 10:23 AM 9/2/2008, salman Maidan wrote:
>How can I have the portal (or a different portal) to summarize the visits
>and show the following:
>
>
>Visit A 3 contacts ABC
>
>Visit B 3 contacts DEF
>
>Can anyone help me with this please.


===========================================================
Kevin Frank & Associates     Email:  kfrank@...
Voice:  707-822-6414         Web:    www.kevinfrank.com
===========================================================
FileMaker 7 & 8 Certified Developer

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au