Skip to main content

Return child value based on max date field



  • Permanently deleted user
    Cristina commented  ·    · 

    Hi Michael,

    Thank you for reaching out! This would be possible via a few calculations on both the parent and child tables.

    On the parent table, you can use the max() function, to return the most recent date.

    max({Date on Child Table})

    On the child table, you can then return the Number field, for those records whose date is equal to the max({Date on Child Table}) date.

    if({Field on Parent created above}={Date on Child Table},{Number on Child Table},null())

    Lastly, on the parent table, use the childconcatenate() function on the field you created on the child table, which should only include the number with the highest date.

    childconcatenate({Calc field on Child Table})

    If you would like further assistance, feel free to submit a ticket to our support team at for us to take a further look.



  • Permanently deleted user
    MichaelW commented  ·    · 

    I already had the max date on the child table, so all I had to do was add the two other calculations. Seems to work. Thanks.


Please sign in to leave a comment.

Powered by Zendesk