* Custom Events fields

[Darryl-W]

Hello,
I created a custom EVENT to display the Interment of individuals.
I need to have the Interment DATE and the Interment NUMBER .
My custom events shows the number but it is NOT a number I thinks it is sorting as TEXT .
I cant see a way to force the event NUMBER as a Number .
My sort on the number field reveals in sequence 1002799 , 1003, 1003629 , 10057 how can I make it NUMERIC and sort low to high
Thank you for considering my dilemma

Darryl

[Valkrider]

The typical way to do this in any computer programme is to pad the number with leading or trailing zero's (whichever is appropriate in the individual case) so they are all the same length. They will then sort properly.

[Jane]

Did you mean an Event or an Attribute?

Are you sorting them in a Query? If so have you tried wrapping the data reference with the =number() function?

[tatewise]

Unfortunately the =Number(...) function does not produce a text display in a Query column.
However, the =TextToNumber(...) function works perfectly.

So if the Interment Number is the Value of your custom Interment Attribute the Expression would be:
=TextToNumber(FactValue(%FACT%)) in the Columns tab of a Fact Query.

However, if other Attribute facts have non-numeric Values, then they will not display correctly.
So what seems to work is two Columns :-
=TextToNumber(FactValue(%FACT%)) Sort: Ascending Type: Hidden
=FactValue(%FACT%) Sort: Ascending Type: Normal