AnsweredAssumed Answered

email script problem

Question asked by TodPoirier on Jun 16, 2014
Latest reply on Jun 18, 2014 by briancrockett

Title

email script problem

Post

     I am working on setting up a button to send email to people when a trouble report is created inside our inventory database we've created with FMP 13.  I've created a calculation that I've been trying to implement both through a new field or thru the emails message calculation option.  When I view the results of the calculation within the database itself it gives me the data I expect, but when the calculation is used within the body of an email I get the text I've set up inside the calculation but not the data stored in the fields.  My calculation is as follows, what do I have wrong?:

     "Trouble report creation by:"  &  " "  & Trouble Reports::Reported By  &  " " & "on"  &  " "  & Trouble Reports::Date Created  &  ¶ &
     ¶ &
     "The trouble is in: "  &  " "  &  Trouble Reports::Department  & ¶   &
     "In room: " & Trouble Reports::Room  & ¶ &
     ¶ &
     "With equipment: "  & " " & Trouble Reports::Equipment  & ¶&
     ¶ &
     "Problem is:"  & " "  & Trouble Reports::Problem Type  & ¶ &
     ¶ &
     "Reporter notes: " & " " & Trouble Reports::Reporter Notes & ¶ &
     ¶ &
     "Action taken: "  & " "  & Trouble Reports::Action Taken

Outcomes