String comparison for sorting Text Input column in a Table

[pmeidingerParticipant]

I’d like to sort a Text Input column of employee names in a Table. I know there’s no built-in sorting function in the Table object, so I’m using helper fields and tables. However, comparing strings to see which one comes first alphabetically doesn’t seem to work.

For instance, if I do a Simple Branch with 'a' < 'b' it always returns false. What’s the correct way to compare two Text Inputs to see which comes first alphabetically?

[Dennis @ PerfectFormsBlocked]

You could use a Java script to sort a string alphabetically. There is an example on this web site: http://www.roseindia.net/java/javascript-array/javascript-array-sort-alphabets.shtml/. The form would have to be embedded in a page that contains the Java script. Use the Call Java Script behavior object: http://www.perfectforms.com/Documentation/manual/html/?fg_calling_javascript_from_a_form.htm.

If you wanted to create a web service that sorts alphabetically you could use that as well. I couldn’t easily find any examples of web services that sort alphabetically, but I didn’t search for too long.

Workflow software, Process software, Procedure software

[pmeidingerParticipant]

Thanks for the response, Dennis!

[Author]

Posts