selectFirst()

Updated: 2026-01-16

Similar to select(), selectFirst() allows you to select the first instance of a specific row of a table based on data in one of the cells. Use selectFirst() in conjunction with last() to use data from the table on the T1-ADJ.

The example below uses selectFirst() to choose the line, and then dereferences the required value with .AmountOfChange:

{{#CurrentClient}}{{#last(Adjustments)}}{{#T1ADJ}}

{{selectFirst(AdjustmentDetails, where(LineNumber = 48400)).AmountOfChange+selectFirst(AdjustmentDetails, where(LineNumber = 48500)).AmountOfChange}}

{{/T1ADJ}}{{/last(Adjustments)}}{{/CurrentClient}}