AnsweredAssumed Answered

Need Help with Calculation

Question asked by SydneyBlock_1 on Sep 22, 2014
Latest reply on Sep 22, 2014 by philmodjunk

Title

Need Help with Calculation

Post

I think I need some specific coding help. I created a button to send an email to specific addresses depending on the selection in a field’s drop down list and I am having trouble getting it to function correctly. (We have not received FileMaker Pro Advanced yet) The script has an error right after the “Commit Records/Requests” and it says “The operation could not be completed because the target is not part of a related table.” Not sure what this means or what the target is. The script is pictured below.

In the Send Mail script step, I have a calculation to ask to email specific people depending on the selection in a field. It looks something like this:

If(Observations::Jobsite = "90165 - Oneok MB1";
"dmatherne@tellepsen.com; cramer@tellepsen.com";
"")
&
If(Observations::Jobsite = "90155 - Oneok MB2";
"dmatherne@tellepsen.com; cramer@tellepsen.com";
"")

 

Now, I understand I could nest the If functions, but there's at least 30 of them.

How do I find out what the "target" is to make sure it's part of a related table?

 

Script.jpg

Outcomes