1 Reply Latest reply on Feb 29, 2016 12:29 AM by arnojansen1

    linking multiple client names to email template via script calculations

    arnojansen1

      Hi I am filemaker pro advanced 14 user on Mac.

       

      I have created a table with Customers (customers have primary key and one and the same _kf_DosierNumber to link them to Dosier and

      Dosier, (_kp_DosierNumber ) One Dosier can have multiple customer (linked via keys)

      and a table with a travel itinerary. One travel itinerary can have more than one customer and are linked via _kf_foreignkeys. Using DosierNumber

       

      All that works fine. i can select the Dosier number with many clients in my itinerary and bring it in a portal.

       

      I have an email that prepares all details to a hotel. what i am looking for is how do i link two or more customer names to an email via a calculation. it is currently only picking up the first name.

       

      Extract of send email options via outlook using calculations:

      "Names"&"¶"&

      Client Dosier::_kp_DosierNumber&

      Clients::Title &" "& Clients::Customer first name &" "& Clients::Customer last name &"¶¶"&

       

      The client dosier does pick up the number, but the last sentence only picks up the first name of the dossier. i probably need a bit of coding here using a loop?

       

      Your help is appreciated.

       

      cheers

      Arno