Concatenate string with field value when prefilling values

Forums vLooup for SharePoint Concatenate string with field value when prefilling values

This topic contains 3 replies, has 2 voices, and was last updated by  Alexander Bautz 3 months, 4 weeks ago.

  • Author
    Posts
  • #16911

    Gerard Graham
    Participant

    Hi there

    Is it possible to concatenate a string with the value of a column e.g. “Issue Raised in Project “&[Title]

    Thanks

    Gerry

  • #16931

    Alexander Bautz
    Keymaster

    In later versions of vLookup you can use a variable – look at the help icon in the “Prefill values in child” field – if you see Use variable in the “From” field you can add your variable in Custom JS like this:

    var myCustomVar = "Issue Raised in Project " + getFieldValue("Title");

    and use this variable in the “From” field:

    {{var:myCustomVar}}

    Alexander

  • #16961

    Gerard Graham
    Participant

    Thanks again Alexander. All working now.

    I couldn’t see any ref to the use of var in the help text though.

    Gerry

  • #16970

    Alexander Bautz
    Keymaster

    An – sorry about that, I have updated the use manual.

    Alexander

You must be logged in to reply to this topic.