Concatenate string with field value when prefilling values

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

Viewing 3 reply threads
  • 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

          Viewing 3 reply threads
          • You must be logged in to reply to this topic.