Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Value List Sort Descending by Timestamp


This topic is 6852 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

Hello. I have been browsing the current topics, looking for a solution to my dilema, and have not found one. Maybe I am searching the wrong topic?

Here's my issue: I have created a Comments table, related to Jobs, and would like to display all related comment records in a large concatenated text field. It will allow user to view entire comment and timestamp vs using a portal (since length of comment is unknown).

However, I would like to sort descending, based on the timestamp, so the most current comment is always at the top of the list.

What I have so far seems to function, but I cannot figure out how to reverse sort the value list. Any help would be appreciated.

Field (Calc) }:( Jobs::Comment_Viewer = ValueListItems ( "Quotes" ; "Job_Comment_Viewer" )

Field (Calc) : Comments|Jobs::c_Comment = Timestamp & " " & AccountName_Created & " " & Comment_New

Field (Text) : Comments::Comment_New

Value List : Job_Comment_Viewer = Use values from field : Comments|Jobs::c_Comment

Please let me know if this is enough information to go off of, or what else I may need to specify to get some help.

Thanking you in advance.

Picture_1.png

Posted

Define a calculation field cNegTime (in Comments table, result is Number) =

- Timestamp

Define your value list to also display values from cNegTime, and to sort by second field.

  • Newbies
Posted

Thanks! It worked! Crazy how it can be the simplest idea that escapes your mind. I appreciate your help.

This topic is 6852 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.