1 Reply Latest reply on Jul 11, 2015 6:51 AM by SteveMartino

    Wrong info in emails



      Wrong info in emails


      Hi everyone,

      I've got a little issue, maybe bug in system???

      I started with the trialversion of FilemakerPro 13, but with some problems about the payment, I received permission to start with trialversion FilemakerPro 14 and received the code the continue with this version.
      I use Filemaker Pro to make records of people and their various trips to airevents.
      Therefor i have adjusted "Facturen" to my needs.


      Person A is going with aircraft to trip B, aircraft departs from C to D with departurehours 00u00

      Same person is going with bus to trip Z, with departurepoint Y with departurehours 12u00

      So several people will go to the same event, some of those people also booked another trip, etc etc
      Now i want the send an email to the people of a certain trip, so i do a search to get all the people for that trip on 1 screen.
      But if i want to send them an email, some of the people who are going on this trip but also booked another trip, are receiving data from that other trip.

      So like in the example above, he will go to trip Z, with departurepoint C instead of Y and departurehours 00u00 instead of 12u00. See also example of mails below
      When i take a look to the tableview, everything looks like it must be, with the right data as it should be.
      And when i change the data in that other trip, then it's working fine, but i don't think thats the way of working with this program.
      For the other people that hasn't booked another trip, they receive the good information!!!

      Example of the mail:  (both data should be the same!!!)

      Person A who doesn't have booked another trip
      Volgens uw boeking, gemaakt op 18/07/2015 met nummer 2015-0000 stapt u op te Oostkamp (Hotel van der Valk) en vertrek is daar voorzien om 22u15.
      Rond 04u50 zal u terug te Oostkamp (Hotel van der Valk) zijn. 

      Person B who does have a booking for another trip
      Volgens uw boeking, gemaakt op 16/06/2015 met nummer 2015-0000 stapt u op te Zaventem (BRU) en vertrek is daar voorzien om 13u05
      Rond 17u25 zal u terug te Zaventem (BRU) zijn.

      All trips does have another invoice, so no two trips on the same bill

      Is there a bug in the system or is it me that's doing something wrong???



        • 1. Re: Wrong info in emails

          It's a little hard to follow your post, but more then likely you have something set up wrong.  I personally don't like the Invoices starter solutions, I recommend you either build your own, or try FM Starting Point:

          That being said, explain how your relationships are set up? Can you show a pic of your relationship graph

          How are the fields set up?

          What context is the 'Send Email' script coming from?  Is it on the right layout/Table Occurrence?

          If you are following the Invoices solution, and you have a portal on Invoices (trips) that shows related records of people(bookings-line items), then you should be able to send emails only to the people on that 1 trip.  In other words, If you have isolated the people you want to send an email to on the layout that shows bookings for just that trip, then sending an email from that context (layout, table) should only send emails to those people.

          Can you also show your 'Send Email' script.

          You can also zip, save to Dropbox, and post a public link of your file (with sample data) here, and others can take a look at it.