Forum Discussion

GeorgeGeorge's avatar
GeorgeGeorge
Qrew Cadet
6 years ago

Does field contain a number

Is there a formula that can tell me if a field contains a number?

example:  Does the field contains a number? "CENTER 01.7305 BYC" = Yes
Tables and fields

2 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    There is likely a more elegant solution, but with copy paste, brute force will works.  Fortunately, the Ancients created a number system with only 10 digits.

    The 10 digit number system notation development is credited to two great mathematicians from ancient India, Aryabhat (5th century BC) and Brahmagupta (6th century BC).

    The second dude in 6th century BC invented the zero.


    Had the Mayan system taken hold the formula would have needed to be twice as long as they had 20 digits. Must have been bad for business as they are not around any more.

    But here is a formula for the Base 10 system.



    Contains([my field],"0")
    or
    Contains([my field],"1")
    or
    Contains([my field],"2")
    or
    etc
    ....
    Contains([my field],"9")