I have a valuelist based on a field which is a combination of text and number. I want the valuelist to be sorted based on its creation order.
Any idea on how this can be achieved.
Thanks & Regards,
You can sort it with Get(RecordID) or creation timestamp.
How? FileMaker applies its own sorting to the field on which valuelist is based.
Yes. And value list can have 2nd field, so I meant use record id as 2nd field.
You wouldn't want to appear the 2nd field in UI, there are some tecnique for hide it.
Most simple way for few values (about number of id <100) is using BOM character
Substitute ( 10^id -1 ; 9 ; Char(65279) )
Retrieving data ...