List function - fields from records in a Portal

[Tim Farris]

Hello

Creating a Sendmail script that collates into the body of the email a  
combination of fields from records in a Portal.

I thought the List function would work nicely however I cannot get the  
List function to format fields next to one another....it inserts  
returns after each field.

Any advice on how to get the contents of a Portal records and  
associated fields nice and neat into a body of an email.  Sample:

Portal Record 1:  List ( field1 ) & " - " & List ( field2 ) & " - " &  
List ( field3 ) < carriage return >
Portal Record 2:  List ( field1 ) & " - " & List ( field2 ) & " - " &  
List ( field3 ) < carriage return >
Portal Record 3:  List ( field1 ) & " - " & List ( field2 ) & " - " &  
List ( field3 ) < carriage return >
Portal Record 4:  List ( field1 ) & " - " & List ( field2 ) & " - " &  
List ( field3 ) < carriage return >
etc...

Thanks,
Tim.

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/

[Paul Spafford-2]

Hey Tim,

I think I understand what you're trying to do.

In your table that the portal is pointing at, create a calc field  
called emailData that uses the following calc:

    field1 & " - " & field2 & " - " & field3


Then your email body just needs to grab the following:

    List ( relatedTable::emailData )


Does that do it?

Paul

--
Paul Spafford
Spafford Data Solutions
Tel: [phone]
www.paulspafford.com





On Jul 2, 2009, at 9:09 AM, Tim Farris wrote:

> Hello
>
> Creating a Sendmail script that collates into the body of the email  
> a combination of fields from records in a Portal.
>
> I thought the List function would work nicely however I cannot get  
> the List function to format fields next to one another....it  
> inserts returns after each field.
>
> Any advice on how to get the contents of a Portal records and  
> associated fields nice and neat into a body of an email.  Sample:
>
> Portal Record 1:  List ( field1 ) & " - " & List ( field2 ) & " - "  
> & List ( field3 ) < carriage return >
> Portal Record 2:  List ( field1 ) & " - " & List ( field2 ) & " - "  
> & List ( field3 ) < carriage return >
> Portal Record 3:  List ( field1 ) & " - " & List ( field2 ) & " - "  
> & List ( field3 ) < carriage return >
> Portal Record 4:  List ( field1 ) & " - " & List ( field2 ) & " - "  
> & List ( field3 ) < carriage return >
> etc...
>
> Thanks,
> Tim.
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/

[Tom Fitch-3]

Tim, you might want to have a look at GetNthRecord:
 http://filemaker.com/help/html/func_ref3.33.10.html#1027997

Tom Fitch
FileMaker 10 Certified Developer
Portland, Oregon

On Thu, Jul 2, 2009 at 6:09 AM, Tim Farris<[hidden email]> wrote:

> Hello
>
> Creating a Sendmail script that collates into the body of the email a
> combination of fields from records in a Portal.
>
> I thought the List function would work nicely however I cannot get the List
> function to format fields next to one another....it inserts returns after
> each field.
>
> Any advice on how to get the contents of a Portal records and associated
> fields nice and neat into a body of an email.  Sample:
>
> Portal Record 1:  List ( field1 ) & " - " & List ( field2 ) & " - " & List (
> field3 ) < carriage return >
> Portal Record 2:  List ( field1 ) & " - " & List ( field2 ) & " - " & List (
> field3 ) < carriage return >
> Portal Record 3:  List ( field1 ) & " - " & List ( field2 ) & " - " & List (
> field3 ) < carriage return >
> Portal Record 4:  List ( field1 ) & " - " & List ( field2 ) & " - " & List (
> field3 ) < carriage return >
> etc...

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/