Show vLookup results as columns

Forums vLooup for SharePoint Show vLookup results as columns

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

  • 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 3 weeks, 1 day ago by  Artaker.
  • #17363

    Alexander Bautz
    Keymaster

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

    Alexander

You must be logged in to reply to this topic.