2. ASPRunnerPro General questions
  3. Generate a sort name from a name field
This topic is locked

Generate a sort name from a name field

 		3/16/2010 9:41:15 PM
ASPRunnerPro General questions
S
 suprapen author

Anyone know how to generate a sort name from a company name field. The purpose is to cut off words like "the" from the beginning of the company names so sorting is more accurate. Would be helpful to generate it on add and edit pages after you enter or edit the company name field. Thanks.
J
 		Jane 3/17/2010

Hi,
use Before record added event on the Eventstab to remove all unnecessary words from the field value.

Here is just a sample:

values("FieldName") = Replace(values("FieldName"),"the","")
S
 		suprapen author 3/18/2010



Hi,
use Before record added event on the Eventstab to remove all unnecessary words from the field value.

Here is just a sample:

values("FieldName") = Replace(values("FieldName"),"the","")



Thanks Jane! I actually did this via an onchange js event on the Company field. But basically the function called is the same, replacing any "the " values for the Sort Name field.