Aggregation of related records --> First value only

Did you try this?

https://docs.appian.com/suite/help/22.3/fnc_system_relatedrecorddata.html

Hi Stefan,

I've read the documentation and it looks promising - as of now I'm on a loss where to apply this from within the 'Record Type' GUI (and 'New Custom Record Field). 

(I'm able to get part of this working from within a 'Expression Rule' though)

I am not sure whether this works in a custom record field. But give it a try and post an update.

I did not succeed in getting this to work in a custom record field:

• I cannot access a 1:n relation from the base record type from the relationships (only the other way around relationships are "auto-completed"
• I cannot reference the related record type itself: 'You must reference a record field or related record field from the base record type.'
• its required to include (at least on) custom record function
• not sure if the function is allowed in this kind of template ('Custom Record'): The following functions are not supported in this expression: [a!relatedRecordData]

Maybe I did not yet get the syntax right though...

I also had the same problem, so it would be great if you could update it.                                                pou

Custom record fields are made for a pretty narrow range of typical use cases and might not cover yours. But you can always go the way and implement your own query and show that in a grid.

Custom record fields are made for a pretty narrow range of typical use cases and might not cover yours. But you can always go the way and implement your own query and show that in a grid.