Jump to content

CloudMail Use Field as Body


jshels
 Share

This topic is 2327 days old. Please don't post here. Open a new topic instead.

Recommended Posts

What I would like to do is use a field as the body for my message. I have it working using the calculation below but I would like to be able to call fields within those fields. As an example in my Staff::Email Message HTML field I'd like to say Staff::First Name to insert their first name. Is there any way this can be done? It always seems to just insert Staff::First Name into the body of my message even if I surround it with quotes and use proper scripting language. 

 

Thanks!

Jon

 

CMQueueMessage(
Staff::Email Message HTML;
Staff::Email Message Text;
Staff::Email Subject;
(Staff::Email From);
Staff::Email Subject) = "ERROR"

Link to comment
Share on other sites

  • 3 weeks later...

Hi jshels,

The way to handle this would be to use the FileMaker script step Substitute. You can read about its usage here . You would basically have your body in a field that has placeholders for the information that you want to replace. Then call the Substitute function to replace the placeholders. You can either set the return to another field or to a variable and then pass that into the CMQueMessage function.

Link to comment
Share on other sites

This topic is 2327 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.