random number

[ayra]

I have data with random serial numbers, for example

3. alex

4. steve

5. josh

6. john

I want to make a pdf and want to make it sequential by number, what is the formula ?

[Suvrutt_Gurjar]

You could try using EXTRACTNUMBERS() function to get the number value from that column containing 3. alex etc. in another number type column.

Thereafter you could ORDERBY() records by those extracted numbers column in your template <> expression.

EXTRACTNUMBERS() - AppSheet Help

ORDERBY() - AppSheet Help

Use templates in an automation - AppSheet Help

Use Start expressions in templates - AppSheet Help

[Tommy62]

Dieser Ausdruck gewährt dies:

ORDERBY(Tabelle[KEY], [Spaltenname])

Der Ausdruck kann auch in entsprechender Spalte mit “TYP Text” als “Valid If Ausdruck” verwendet werden.

[Suvrutt_Gurjar]

Oh yes, you are correct @Tommy62 . Good point. One could use text column as well for sorting in ORDERBY().

@ayra : You can omit the EXTRACTNUMBERS() step.