Last record

Hello, I am in need of displaying last record in a table field. I have depth field and second field with entries. I tried to count the number of depth fields and use it with recorditem function. When I used the recorditem function and manually writing the desired position then it works as intended. But when I replaced the manually written entry with the Count function of depth fields I got null. Is there any way to get it to work?

Thanks

  • Hi Jakub,

    Some of it really depends on the keyset of the table, what type of entity, what type of report etc..

    But this is an example of a basic point id depth table and showing the graphic that is selected in the last record. In this case I just put it in a text entity in the header of a log report. this uses the  functions you wanted to use.

    Your scenario may be completely different and there may be better functions to use based on the table keyset, the type of entity and the type of report. Using the let and get functions I can do what you say with count and recorditem

    <<Let(Number of Lithology Records = <<Count(<<LITHOLOGY.Depth>>)>>)>>_
    <<RecordItem(<<LITHOLOGY.Graphic>>,<<Get(Number of Lithology Records)>>)>>

    Answer Verified By: Jakub Hruška