Approval Status in vLookup list

Home › Forums › vLooup for SharePoint › Approval Status in vLookup list

Viewing 4 reply threads
  • Author
    Posts
    • March 3, 2015 at 11:30 #7171
      Andrew Wolfe
      Participant

        I want to show the Approval Status of items in the lookup so I’ve picked _moderationStatus. However that gives me a numeric rather than a word. Do you know how I can turn the number 2 into the relevant status?

      • March 3, 2015 at 12:41 #7172
        Alexander Bautz
        Keymaster

          Currently I cannot think of any method. I’ll add an option in vLookup to “translate” a value like you require.

          It will take a few days, so check back here.

          Alexander

        • March 17, 2015 at 08:16 #7276
          Alexander Bautz
          Keymaster

            I’m sorry for the delay. I’ll look into this later tonight.

            Alexander

          • March 18, 2015 at 00:34 #7281
            Alexander Bautz
            Keymaster

              This is now in place. Check out v2.105 and let me know how it works out.

              Read the change log, and use the “help icon” on the viewFields section to learn how to use “replace”.

              Alexander

            • March 19, 2015 at 13:49 #7295
              Andrew Wolfe
              Participant

                Thanks Alexander. Brilliant, works just how I wanted

            • Author
              Posts
            Viewing 4 reply threads
            • You must be logged in to reply to this topic.