AnsweredAssumed Answered

RE-ordering checkbox selection list

Question asked by kwojnar on Oct 15, 2014
Latest reply on Oct 15, 2014 by user19752

Yet another formatting question from the new guy ...

 

Is there a way to re-order the items in the checkbox/radio button selection list from an external table ? I see there is a "Re-sort values based on:" check box in the 'specifiy fields for value list' window but regardless of if it is checked or not, the order doesn't change on the form. Very simple example - 2 column table with index value column and description value column. Indexes are 1 and 2 with associated descriptions 'A' and 'B' . The form always displays in order A and B regardless of the index value (Index for A = 1 or index for A = 3) I want B to display first in this simple example but it appears that the displayed list is always descending alpha based on the displayed list description value. Not sure if it make a difference but the value stored in the database is the index.

 

I have tried sorting the list items internally in the table based on the index/key as well as sorting by the data values. Tried adding rows to the table that the value list is pulled from but the sort is always alpha according to the displayed value. Don't see any documentation on the sort beyond sorting in table view and couldn't make that work either.

 

Thanks for any suggestions or if anyone can point me to a good reference source where I might find answers to these questions. Have looked through the user guide v13.

 

Also is there any comprehensive reference material covering all functionality ?

Outcomes