Show vLookup results as columns

Forums vLooup for SharePoint Show vLookup results as columns

Viewing 4 reply threads
  • Author
    Posts
    • #16716
      Artaker
      Participant

      Hi!

      I’ve been trying to find some hints here and though I saw something that might go the direction I need, but I’m unable to find it anymore:(

      I have a calendar list which contains a vLookup to a doc lib. I can query the entries fine and also show values (well not all, lookupfields are not sown but this might be my old version).

      Now since this chils list has many properties the form get’s really wide, which isn’t really comfortable for the user to look at.
      Is it possible to format this view to have them kind of boxed up?

      Or is there a possibility to get the values of those looked up items and just put them into fields on a tab I created via html?

      I use the vlookup since I can’t know how many items there are. But if I could just query the items in the background and fill them into a fixed form that might work as well.

      Thanks for suggestions

      Verion: switching to the latest release soon, still the parent is a calendar list…

      BR
      Nicole

    • #16751
      Alexander Bautz
      Keymaster

      Hi,
      In later versions of vLookup you can set a fixed width on each field in a vLookup table to control the width, but there is not built in method to box it up. You might be able to use Custom CSS in DFFS to set the width of each column:

      .vLookupTable{
          width:auto!important;
      }
      .childTableHeader:nth-child(2){
          width:100px;
      }
      .childTableHeader:nth-child(3){
          width:50px;
      }

      Change the “nth-child(x)” to match the number of columns from the left.

      Alexander

    • #16842
      Artaker
      Participant

      Hi!

      This looks great, thanks
      I’m going to implement it and then hopefully my users like it too ๐Ÿ˜‰

      Best regards,
      Nicole

    • #17346
      Artaker
      Participant

      Just wanted to say Thx again – my users like this solution, so everything is perfect ๐Ÿ˜€

      BR,
      Nicole

      • This reply was modified 2 years, 10 months ago by Artaker.
    • #17363
      Alexander Bautz
      Keymaster

      Thanks for the feedback, I’m glad it worked out.

      Alexander

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