We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

how to write a field value into a messagebody of send email+ node?

Comments

11 comments

  • Avatar
    Infogix Support
    Originally posted by: rebeccanew

    I have the same question. How to write values of fields into the MessageBody?
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: gmullin

    Have a look here.
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: rebeccanew

    Thanks for the reply, gmullin. I tried your way, but it seems it doesn't work for me. I will describe my simple graph to you.
    The input of send mail+ is a filter node which has a field named DateTime in which I got the string including the current date and current time. Then in the MessageBody of the Send Email+ node, I input the DateTime. I hope that the value of the DateTime field can be sent out to a email address. But when I open the email, the email body is the plain text DateTime, not the value of the DateTime field. I don't know what's wrong. And my bre version is v6.1.4. Can you guys please give me some help? Thanks.
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: gmullin

    In the drop down beside MessageBody do you have it set to Field and not Literal?

    Can you attach your graph here?
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: rebeccanew

    hi, gmullin, thank you very much. I got it.
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: rebeccanew

    Thanks very much. Can I ask you more questions about the Send Email+ node?
    The first one is: I have three columns. I input three rows in the MessageBody: 1 TheStartTime, 2 TheEndTime, 3 TheGraphName. But I got an error which is ERROR:Column is missing.
    The second one is: I tried to mixed the literal and field together. I input "The Start Time is: " + TheStartTime into the MessageBody. I got the same error: ERROR:Column is missing.

    Can anybody help, please?
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: gmullin

    You can't mix Literal/Field values, you have to pick one or the other. What you should do is have a Filter node leading into the Send + node and have something like the following:

    emit "The Start Time is: " + TheStartTime as "MessageBody"

    The you have a field called MessageBody you can use as an input.
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: rebeccanew

    Ok, got it. Thanks a lot.
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: ThomasT

    Everything works fine here except when I try to use a field as input in the "MessageBody", then I get this message, even if the column is there:

    ERROR: Column is missing: (MessageBody )
    Error Code: ls.brain.node.sendEmailPlus.errorColumnMissing
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: ThomasT

    OK, seems the MessageBody also have to be named "MessageBody"
    Works now
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: online

    Thank you very much. I got it.
    0
    Comment actions Permalink

Please sign in to leave a comment.