topic Re: Need an answer for Scenarios in App Development

Need an answer for Scenarios

Jay587 — Tue, 11 Mar 2025 07:48:02 GMT

Hello Community folks,

I need an answer in several ways to the below questions with the table below.

1.get the latest comment ID based in ID

2.get the latest status based comment ID

ID	Comment ID	Comment
123	1	booked
123	2	shipped
123	3	packed
123	4	closed
345	1	booked
345	2	shipped
345	3	packed
345	4	Delivered
345	5	closed

Please help me on this to get the solution is multiple ways. Thanks in advance.

Re: Need an answer for Scenarios

ali_hijazi — Tue, 11 Mar 2025 08:58:42 GMT

there is a function called FirstSortedValue
you may use it as follows:
FirstSortedValue([Comment ID],-[Comment ID])
same applies for the Status
FirstSortedValue(Comment, -[Comment ID])

Re: Need an answer for Scenarios

SRA — Tue, 11 Mar 2025 08:57:55 GMT

Hi,

If we consider you need to display the highest CommentID and the corresponding Comment for each ID you could use this :

If you display the complete table with the details, but want to display some new columns with the max CommentID and corresponding Comment you can add a TOTAL <ID> in the formula:

Hopping it will respond to your requirement