• Multiple line entries in view

    By Jay Badasie 1 decade ago

    I managed to export the "Notes Clnt Build" into an.xls file BUT i noticed it takes the first line entry only..



    The "Notes Client Build" + "Notes Client Machine" + "Notes Client + Platform" + "Updated At"

    has multiple entries in it.



    How do I export the LAST entry only as it is the latest info



    Regards

    • Here is the formula to use

      By David Jeyachandran 1 decade ago

      Hi Jay,



      It is difficult to assist without being able to see your Notes database but hope this helps.



      To get the last value in a multi-value field you could use @Subset( Fieldname; -1)



      So if you want to get the last updated, you could use a formula like this in Notes Reconn.

      @Subset( @Name([Abbreviate];$UpdatedBy); -1)



      Regards

      David