Return to FileMaker.com
Why not enter the 0 in Filemaker
how you enter the value exactly as i entered.
for example : I typed 0902 222 987 then my script copy the 0902 222 987 to another related number field, after copy i can see only 902 222 987 in related field.
Field type is number. not sure why it does not copy 0
any thoughts ?
You will have to change your field type to text to keep the 0. If you need to use the field in a calculation then you will have to use the GetAsNumber(YourTextField).
Retrieving data ...