Skip to main content
BOOK A DEMO

Search

Lookup field from another List (newest value only)

Raoul_Dobal_PMG
  • Discussion Created

I have two lists. A list with client contacts (master) and a connected (sub) list with notes from meetings In the sublist I have a field with the date of the visit. I would like to display in my client contact list view the last date of the visit. Imagine a summary view of a list of all your clients showing also the last time they were visited.

 

I thought of doing something in the "values" section, but did not really see an approach there. Any thoughts how to go about this?

0

Comments

2 comments

Date Votes
  • Matthias_Walter

    Hi Raoul Dobal,

    you are on the right track and this would be the correct approach using our aggregation functionality in the column configuration. At the moment the Min/Max option does not yet support date fields, but we could implement this in the future.

     

    Another approach / workaround would be to use a daily scheduled action -> update list item which updates the last visit date using our query function e.g. as follows:

    [[@Web.GetFirstValueForQuery('Activities', '<Where><Eq><FieldRef Name="AccountRef" LookupId="TRUE" /><Value Type="Lookup">[[ID]]</Value></Eq></Where><OrderBy><FieldRef Name=ActivityDateTime Ascending=False /></OrderBy>', 'ActivityDateTime')]]

    Simply adjust the parts in bold to your needs.

     

    Kind regards

    Matthias

    0
  • Christof

    Hi Raoul Dobal

     

    We did release the Min/Max aggregation for date fields with Solution Studio Update 17.01.2020. 

     

    Your case is now working with expected aggregation configuration on date field in master list:

    0

Please sign in to leave a comment.