Hi:
I have a Creator Application with several forms. Most of the form need a field that I am using as a relationship. To make things easier for the users I have a Pick List of imported data from the Personal Information Form. Here is the script code that generates the list:
ust have Contractor_ID
(
displayname = "Contractor"
type = picklist
values = Contractor_Information.Contractor_ID
displayformat = [ " " + Last_Name + ", " + First_Name + " - " + Contractor_ID ]
searchable = true
width = 206px
The list is working fine, but the list of individuals is very long and it appears in NATURAL order I am trying to sort it Alphabetical to make it easier for the people entering the data.
I have tried adding a Sort by statement in two ways:
- values = Contractor_Information.Contractor_ID Sort by Last_Name
- displayformat = [ " " + Last_Name + ", " + First_Name + " - " + Contractor_ID ] Sort by Last_Name
In both cases when I try to update the form definition it fails.
How can I sort the list.
Thanks.