|
»
»
»
Data from a portal
|
View:
New views
11 Messages
—
Rating Filter:
Alert me
|
 |
Data from a portal
by Salman Maidan-2
::
Rate this Message:
Hello Experts,
FMP9 WinXP sp2 No doubt this comes up again and again, I tried the archives, but could not locate any trail to this type of info. I have a portal which holds many child records to each record in the mother table, I need to create a few calc fields in the mother table that will give the following results: 1) The value from field A on the FIRST portal row 2) The value from field A only from the LAST portal row 3) A list of all the values from field A from all the portal rows Is This possible with just creating calculation fields in the mother table without looping. Or maybe a special function. Can anyone help please. ___________ Regards Salman Maidan _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Data from a portal
by Ibrahim Bittar Torres
::
Rate this Message:
Salam Aleikum Salman
> 1) The value from field A on the FIRST portal row From the parent table a calc field = Portal_Table::Field A > 2) The value from field A only from the LAST portal row From the parent table a calc field = Last ( Portal_Table::Field A ) > 3) A list of all the values from field A from all the portal rows From the parent table a calc field = List ( Portal_Table::Field A ) Saludos Ibrahim Bittar Torres Director General Eikonsys FileMaker 9 Certified Developer http://www.eikonsys.com FileMaker Business Alliance _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Data from a portal
by Lorne & Joan Walton
::
Rate this Message:
On Aug 27, 2008, at 1:35 AM, salman Maidan wrote: > > 1) The value from field A on the FIRST portal row > Relation::FieldA will give you the value form the first row > 2) The value from field A only from the LAST portal row > Last ( Relation::FieldA ) will give you the value from the last row > 3) A list of all the values from field A from all the portal rows List ( Relation::FieldA ) will give you a return-delimited list. -- Somebody's boring me. I think it's me. [Dylan Thomas] Lorne Walton, Maple Ridge, BC, Canada _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
RE: Data from a portal
by Salman Maidan-2
::
Rate this Message:
Wa Alikom Salam,
Thanks Ibrahim, it all worked perfectly. Can I bother you with one more. How would You get the results from point no 3) to show horizontally instead of a vertical list. And sorry for the multiple postings everyone, I sent out the first one yesterday but nothing happened so I followed it with another and you know the rest of the story. SORRY ___________ Regards Salman Maidan -----Original Message----- Salam Aleikum Salman > 1) The value from field A on the FIRST portal row From the parent table a calc field = Portal_Table::Field A > 2) The value from field A only from the LAST portal row From the parent table a calc field = Last ( Portal_Table::Field A ) > 3) A list of all the values from field A from all the portal rows From the parent table a calc field = List ( Portal_Table::Field A ) Saludos Ibrahim Bittar Torres Director General Eikonsys FileMaker 9 Certified Developer http://www.eikonsys.com FileMaker Business Alliance _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Data from a portal
by Ibrahim Bittar Torres
::
Rate this Message:
Simple: Substitute ( List ( Portal_Table::Field A ) , "¶" , " " )
Saludos Ibrahim Bittar Torres Director General Eikonsys FileMaker 9 Certified Developer http://www.eikonsys.com FileMaker Business Alliance On 28/08/2008, at 03:14 PM, salman Maidan wrote: > Wa Alikom Salam, > > Thanks Ibrahim, it all worked perfectly. Can I bother you with one > more. How > would You get the results from point no 3) to show horizontally > instead of a > vertical list. > > > And sorry for the multiple postings everyone, I sent out the first one > yesterday but nothing happened so I followed it with another and you > know > the rest of the story. SORRY > ___________ > Regards > Salman Maidan > > > -----Original Message----- > > > Salam Aleikum Salman > >> 1) The value from field A on the FIRST portal row > > From the parent table a calc field = Portal_Table::Field A > >> 2) The value from field A only from the LAST portal row > > From the parent table a calc field = Last ( Portal_Table::Field A ) > >> 3) A list of all the values from field A from all the portal >> rows > > From the parent table a calc field = List ( Portal_Table::Field A ) > > Saludos > > Ibrahim Bittar Torres > Director General > Eikonsys > FileMaker 9 Certified Developer > http://www.eikonsys.com > FileMaker Business Alliance > > > _______________________________________________ > 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 |
|
|
Re: Data from a portal
by kazar
::
Rate this Message:
On 08-28-2008 4:14 PM, salman Maidan wrote:
> Wa Alikom Salam, > Creo que Ibrahim habla (y escriba) espanol, no arabe :-) > Thanks Ibrahim, it all worked perfectly. Can I bother you with one more. How > would You get the results from point no 3) to show horizontally instead of a > vertical list. > Salman, the List function will return a return-delimited list. Simply use the Substitute function to change the return to the delimiter of your choice. For example, if your preferred delimiter will be a comma and space: Substitute( List(portalRelationship::field); "¶"; ", ") > > And sorry for the multiple postings everyone, I sent out the first one > yesterday but nothing happened so I followed it with another and you know > the rest of the story. SORRY > kazar -- Datatude, Ltd. -- http://www.datatude.net/ strategies & solutions "Tools of Choice" forums at http://network.datatude.net/ _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Data from a portal
by Ibrahim Bittar Torres
::
Rate this Message:
Well, a little bit of arabic. My father was from Lebanon and we spoke
arabic at home when I was a child. I'd love to speak more but the lack of use has made my arabic go away. Saludos Ibrahim Bittar Torres Director General Eikonsys FileMaker 9 Certified Developer http://www.eikonsys.com FileMaker Business Alliance On 28/08/2008, at 03:22 PM, Datatude wrote: > Creo que Ibrahim habla (y escriba) espanol, no arabe _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Data from a portal
by kazar
::
Rate this Message:
Pues, lo siento mi error, y, "salaam"
:-) kazar On 08-28-2008 4:35 PM, Ibrahim Bittar Torres wrote: > Well, a little bit of arabic. My father was from Lebanon and we spoke > arabic at home when I was a child. > > I'd love to speak more but the lack of use has made my arabic go away. > > > On 28/08/2008, at 03:22 PM, Datatude wrote: > >> Creo que Ibrahim habla (y escriba) espanol, no arabe -- Datatude, Ltd. -- http://www.datatude.net/ strategies & solutions "Tools of Choice" forums at http://network.datatude.net/ _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
RE: Data from a portal
by Salman Maidan-2
::
Rate this Message:
Thank you, You wonderful people for all your help.
I could teach you both Arabic in jiffy as they would say in the Uk ;-) ___________ Regards Salman Maidan -----Original Message----- From: fmpexperts-bounces@... [mailto:fmpexperts-bounces@...] On Behalf Of Datatude Sent: Thursday, August 28, 2008 11:40 PM To: fmpexperts@... Subject: Re: Data from a portal Pues, lo siento mi error, y, "salaam" :-) kazar On 08-28-2008 4:35 PM, Ibrahim Bittar Torres wrote: > Well, a little bit of arabic. My father was from Lebanon and we spoke > arabic at home when I was a child. > > I'd love to speak more but the lack of use has made my arabic go away. > > > On 28/08/2008, at 03:22 PM, Datatude wrote: > >> Creo que Ibrahim habla (y escriba) espanol, no arabe -- Datatude, Ltd. -- http://www.datatude.net/ strategies & solutions "Tools of Choice" forums at http://network.datatude.net/ _______________________________________________ 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 |
|
|
Re: Data from a portal
by Binhex
::
Rate this Message:
This will work correctly in most situations, however it may return an
incorrect result if the portal has been sorted. Last ( Relation::FieldA ) will give you the last record as sorted in the relationship definition which is not necessarily the same as that in the portal. On 28 Aug 2008, at 18:01, Lorne & Joan Walton wrote: >> >> 2) The value from field A only from the LAST portal row >> > Last ( Relation::FieldA ) will give you the value from the last row _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
RE: Data from a portal
by Salman Maidan-2
::
Rate this Message:
Thanks for that Binhex.
___________ Regards Salman Maidan -----Original Message----- From: fmpexperts-bounces@... [mailto:fmpexperts-bounces@...] On Behalf Of Binhex Sent: Friday, August 29, 2008 11:43 AM To: fmpexperts@... Subject: Re: Data from a portal This will work correctly in most situations, however it may return an incorrect result if the portal has been sorted. Last ( Relation::FieldA ) will give you the last record as sorted in the relationship definition which is not necessarily the same as that in the portal. On 28 Aug 2008, at 18:01, Lorne & Joan Walton wrote: >> >> 2) The value from field A only from the LAST portal row >> > Last ( Relation::FieldA ) will give you the value from the last row _______________________________________________ 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 |
| Free Forum Powered by Nabble | Forum Help |
