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
example: Does the field contains a number? "CENTER 01.7305 BYC" = Yes
 180 Points
Posted 6 months ago
QuickBaseCoach App Dev./Training, Champion
 67,448 Points
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")
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")
Related Categories

Tables & fields
 7249 Conversations
 184 Followers