Issue when using Orderby with the option FALSE inside a Start End expression

AppSheet AppSheet Q&A
8

Please try below.

  1. In the “Cargos” table, please add a column called say [Insurer_Name] with an expression something like [Reclamo ID].[Insurer_Table_Key]

  2. Now the template expressions can be something like below

In the template below, [Aseguradora Name] is assumed to be the name column of the insurer.

Aseguradora : <<[Aseguradora ID].[Aseguradora Name]>>

Fecha Placa Auto Reclamo other columns Debito


<<Start: ORDERBY(SELECT(Cargos[Cargos Table Key],[Insurer_Name]=[_THISROW].[Aseguradora ID]), [Fecha], FALSE)>>



<<[Fecha]>>

 <<[Placa]>> <<[Auto]>> <<[Reclamo ID].[Reclamo Number]>> …

<<[Monto]>>



<>

Edit: Made some changes to make the approach simpler.