Concatenate string with field value when prefilling values

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.